1. SAP Tutorial
  2. Oil & Gas

OIURV_DOC_VOLDTL SAP table for – Valuation Transaction Level 2 -Volume

Here we would like to draw your attention to OIURV_DOC_VOLDTL table in SAP. As we know it is being mainly used with the SAP IS-OIL-PRA (Production and Revenue Accounting in IS-OIL) component which is coming under IS-OIL module (Oil & Gas). OIURV_DOC_VOLDTL is a SAP standard transp table used for storing Valuation Transaction Level 2 -Volume related data in SAP. It comes under the package OIU_RVDC.

SAP OIURV_DOC_VOLDTL table

Table OIURV_DOC_VOLDTL technical data

TableOIURV_DOC_VOLDTL
Data storingValuation Transaction Level 2 -Volume
ModuleIS-OIL
Sub ModuleIS-OIL-PRA-REV-VAL
SAP PackageOIU_RVDC
Delivery ClassA – Application table (master and transaction data)
ComponentIS-OIL
Table CategoryTRANSP

SAP OIURV_DOC_VOLDTL Table Fields

Here is the details of each fields in this SAP table. You can find the discription, data type and assigned lenth of each of the fields in OIURV_DOC_VOLDTL table.

  • MANDT : Client
    Its a key field. Its data type is CLNT (Character with length 3) with field length 3
  • DOC_NO : Val. document number
    Its a key field. Its data type is CHAR (Character String) with field length 20
  • DOC_YEAR : Document year
    Its a key field. Its data type is NUMC (Character String with Digits Only) with field length 4
  • LINE_NO : Document Line Number
    Its a key field. Its data type is NUMC (Character String with Digits Only) with field length 5
  • POS_NO : Position Number for
    Its a key field. Its data type is NUMC (Character String with Digits Only) with field length 10
  • LAND1 : Country Key
    Its data type is CHAR (Character String) with field length 3
  • PRI_GEO_LOC : Primary geographical location (PRI geo. loc.)
    Its data type is CHAR (Character String) with field length 2
  • SEC_GEO_LOC : Secondary geographic location
    Its data type is CHAR (Character String) with field length 3
  • SCHOOL_DIST_CD : School district code
    Its data type is CHAR (Character String) with field length 3
  • TAX_CLS : Tax Class
    Its data type is CHAR (Character String) with field length 4
  • ONS_OFS_CD : Onshore/Offshore codes
    Its data type is CHAR (Character String) with field length 1
  • SYSTEM_SRCE_CD : Valuation Transaction Source Code
    Its data type is CHAR (Character String) with field length 2
  • PAY_CD : Pay Code
    Its data type is CHAR (Character String) with field length 2
  • VNAME_TYPE_CD : Venture Usage Type
    Its data type is CHAR (Character String) with field length 2
  • THEO_CND_TAX_FL : Theoretical Condensate Tax Calculation Flag
    Its data type is CHAR (Character String) with field length 1
  • CA_ALLOC_METH_CD : Allocation Method Code
    Its data type is CHAR (Character String) with field length 1
  • RELATED_CT : Related Contract
    Its data type is CHAR (Character String) with field length 10
  • LVL_CD : Level Code
    Its data type is NUMC (Character String with Digits Only) with field length 2
  • WI_OWN_NO : Working Interest Owner
    Its data type is CHAR (Character String) with field length 10
  • WI_INT_TYPE_CD : Participant Interest Type
    Its data type is CHAR (Character String) with field length 2
  • WI_OWN_ISQ_NO : Owner Interest Sequence Number
    Its data type is CHAR (Character String) with field length 2
  • TR_BUKRS : Company Code
    Its data type is CHAR (Character String) with field length 4
  • TR_VNAME : Joint venture
    Its data type is CHAR (Character String) with field length 6
  • TR_DOI : Division of interest (DOI)
    Its data type is CHAR (Character String) with field length 5
  • NI_OWN_NO : Net Interest Owner
    Its data type is CHAR (Character String) with field length 10
  • NI_INT_TYPE_CD : Participant Interest Type
    Its data type is CHAR (Character String) with field length 2
  • NI_OWN_ISQ_NO : Owner Interest Sequence Number
    Its data type is CHAR (Character String) with field length 2
  • NI_FRML_NO : Formula number
    Its data type is CHAR (Character String) with field length 8
  • TR_DOI_SUM_FL : Summarize RD to DOI Level Flag
    Its data type is CHAR (Character String) with field length 1
  • TOT_GRI_PC : Total Gross Interest %
    Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 9
  • TOT_NRI_PC : Total Net Revenue Interest Percentage
    Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 9
  • CT_DECM : Contract Decimal
    Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 9
  • REL_CT_DECM : Relative Contract Decimal
    Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 9
  • SETT_DECM : Sett. Div. Decimal Amount
    Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 9
  • TOT_MKT_GRP_GRI : Total Market Groups GRI
    Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 9
  • MP_TYPE_CD : Measurement point type code
    Its data type is CHAR (Character String) with field length 2
  • ORIG_MP_NO : Original measurement point number
    Its data type is CHAR (Character String) with field length 20
  • MP_TYPE_CD2 : Measurement point type code
    Its data type is CHAR (Character String) with field length 2
  • VL_TYPE_CD : Volume type code
    Its data type is CHAR (Character String) with field length 2
  • VL_CLS_CD : Volume class code
    Its data type is CHAR (Character String) with field length 1
  • FRML_ACTL_FL : Actual indicator
    Its data type is CHAR (Character String) with field length 1
  • FRML_ENTL_FL : Entitled Flag
    Its data type is CHAR (Character String) with field length 1
  • FRML_SETT_FL : Settlement Flag
    Its data type is CHAR (Character String) with field length 1
  • TOT_CT_VL_U : Measurement unit
    Its data type is UNIT (Unit key for a Quantity field) with field length 3
  • TOT_CT_VL : Total Contract Volume
    Its data type is QUAN (Quantity field) with field length 13
  • TOT_GR_VL_U : Measurement unit
    Its data type is UNIT (Unit key for a Quantity field) with field length 3
  • TOT_GR_VL : Total Gross Volume
    Its data type is QUAN (Quantity field) with field length 13
  • ACTL_GR_VL : Actual Gross Volume Amount
    Its data type is QUAN (Quantity field) with field length 13
  • ACTL_GR_VL_U : Measurement unit
    Its data type is UNIT (Unit key for a Quantity field) with field length 3
  • ENTL_GR_VL : Entitled Gross Volume Amount
    Its data type is QUAN (Quantity field) with field length 13
  • ENTL_GR_VL_U : Measurement unit
    Its data type is UNIT (Unit key for a Quantity field) with field length 3
  • SETT_GR_VL : Settlement Gross Volume Amount
    Its data type is QUAN (Quantity field) with field length 13
  • SETT_GR_VL_U : Measurement unit
    Its data type is UNIT (Unit key for a Quantity field) with field length 3
  • TOT_CT_ENERGY : Total contract energy
    Its data type is QUAN (Quantity field) with field length 13
  • ACTL_ENERGY : Actual Energy
    Its data type is QUAN (Quantity field) with field length 13
  • ACTL_ENERGY_U : Measurement unit
    Its data type is UNIT (Unit key for a Quantity field) with field length 3
  • ENTL_ENERGY : Entitlement Energy
    Its data type is QUAN (Quantity field) with field length 13
  • ENTL_ENERGY_U : Measurement unit
    Its data type is UNIT (Unit key for a Quantity field) with field length 3
  • SETT_ENERGY : Settlement Amount
    Its data type is QUAN (Quantity field) with field length 13
  • SETT_ENERGY_U : Measurement unit
    Its data type is UNIT (Unit key for a Quantity field) with field length 3
  • UNCR_GR_VL_U : Measurement unit
    Its data type is UNIT (Unit key for a Quantity field) with field length 3
  • UNCR_GR_VL : Uncorrected Gross Volume
    Its data type is QUAN (Quantity field) with field length 13
  • UNCR_SETT_GR_VL : Uncorr. Sett. Div. Gross Volume
    Its data type is QUAN (Quantity field) with field length 13
  • RUN_TKT_NO : Run Ticket Number
    Its data type is CHAR (Character String) with field length 7
  • TOT_TKT_DAYS : Total Number of Ticket Days
    Its data type is NUMC (Character String with Digits Only) with field length 5
  • PRD_DAYS : Days produced
    Its data type is NUMC (Character String with Digits Only) with field length 2
  • SALE_DT_TO : Sales To-Date
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • SALE_DT_FROM : Sales From-Date
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • TANK_METER : Measurement point number
    Its data type is CHAR (Character String) with field length 20
  • GRV_AM : Oil/gas density at standard/base conditions
    Its data type is FLTP (Floating point number) with field length 16
  • DENSITY_U : Unit for densities at standard/base conditions
    Its data type is UNIT (Unit key for a Quantity field) with field length 3
  • DNTYP : Density Type
    Its data type is CHAR (Character String) with field length 1
  • HEAT_VALUE_FCT_U : Measurement unit
    Its data type is UNIT (Unit key for a Quantity field) with field length 3
  • ACT_HEAT_VAL_FCT : Actual Heating Factor
    Its data type is QUAN (Quantity field) with field length 13
  • SET_HEAT_VAL_FCT : Sett. Stmt. Heating Factor
    Its data type is QUAN (Quantity field) with field length 13
  • CT_HEAT_VA_FCT_U : Measurement unit
    Its data type is UNIT (Unit key for a Quantity field) with field length 3
  • CT_HEAT_VAL_FCT : Contract Heating Factor
    Its data type is QUAN (Quantity field) with field length 13
  • VL_TIMESTAMP : UTC Time Stamp in Short Form (YYYYMMDDhhmmss)
    Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 15
  • TRNSP_NO : Transporter number
    Its data type is CHAR (Character String) with field length 10
  • TRNSP_REF_NO : Transporter Reference Number
    Its data type is CHAR (Character String) with field length 25
  • TRNSP_ROU_CD : Transporter route code
    Its data type is CHAR (Character String) with field length 1
  • GASLIFT_WL_NO : Well ID number
    Its data type is CHAR (Character String) with field length 15
  • GASLIFT_WC_NO : Well Completion Number
    Its data type is CHAR (Character String) with field length 5
  • REJ_RSN_CD : Rejection Reason Code
    Its data type is CHAR (Character String) with field length 3
  • RA_PCT : RA Formation Percent
    Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 7
  • TIK_PA_PC : Processing Agreements Percent
    Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 7
  • CA_WGB_CD : Wet Gas Balancing Code
    Its data type is CHAR (Character String) with field length 1
  • CALC_WLR_FL : Calc. WetLesRes
    Its data type is CHAR (Character String) with field length 1
  • PCT_RET_LSE : Percent Returned to Lease
    Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 7
  • ACTL_WLR_VL_AM : Act. Wet-less-Residue Vol. Amount
    Its data type is QUAN (Quantity field) with field length 13
  • ACTL_WLR_VL_AM_U : Measurement unit
    Its data type is UNIT (Unit key for a Quantity field) with field length 3
  • ENTL_WLR_VL_AM : Entl. Wet-less-Residue Vol. Amount
    Its data type is QUAN (Quantity field) with field length 13
  • ENTL_WLR_VL_AM_U : Measurement unit
    Its data type is UNIT (Unit key for a Quantity field) with field length 3
  • SETT_WLR_VL_AM : Sett. Wet-less-Residue Vol. Amount
    Its data type is QUAN (Quantity field) with field length 13
  • SETT_WLR_VL_AM_U : Measurement unit
    Its data type is UNIT (Unit key for a Quantity field) with field length 3
  • ENT_VL_ALLOC_DEC : Entitled Volume Allocation Decimal
    Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 9
  • ENT_ENG_ALLC_DEC : Entitled Energy Allocation Decimal
    Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 9
  • ENT_SET_GR_VL_U : Measurement unit
    Its data type is UNIT (Unit key for a Quantity field) with field length 3
  • ENTL_SETT_GR_VL : Entitled Sett. Gross Volume
    Its data type is QUAN (Quantity field) with field length 13
  • ENTL_SETT_ENG_U : Measurement unit
    Its data type is UNIT (Unit key for a Quantity field) with field length 3
  • ENTL_SETT_ENERGY : Entitiled Sett. Energy
    Its data type is QUAN (Quantity field) with field length 13
  • COST_CENTER : Cost Center
    Its data type is CHAR (Character String) with field length 10
  • LSE_VOL : Lease Volume
    Its data type is QUAN (Quantity field) with field length 13
  • LSE_VOL_U : Measurement unit
    Its data type is UNIT (Unit key for a Quantity field) with field length 3
  • REJ_ZV_CD : Valuation REJ ZV code
    Its data type is CHAR (Character String) with field length 2
  • GPLT_VNAME : Gas Plant Venture
    Its data type is CHAR (Character String) with field length 6
  • GPLT_DOI_DOI : Gasplant DOI No
    Its data type is CHAR (Character String) with field length 5
  • ORIG_GRI_PC : Total Gross Interest %
    Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 9
  • ENTL_CT_DECM : Contract Decimal
    Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 9

    • OIURV_DOC_VOLDTL related tables

    • OIURV_DOC_TAXDTL : Valuation Tax Master Detail
    • OIURV_DOC_DTL_BK : Valuation Transactions Level 1 – Vltxns
    • OIURV_PROC_LIMIT : Allowed concurrent and free dialog processes for VL/RD
    • OIURV_DOC_FRMMKT : Valuation Transactions Level 3 – Marketing Detail
    • OIURV_DOC_BCN : Revenue Document Concept – Batch Control Number
    • OIURV_DO_DPSEVT : DOI Accounting Severance Tax Types Table
    • OIURV_DOC_VOLDTL : Valuation Transaction Level 2 -Volume
    • OIURV_DOC_CRTAX : Oil and Gas appl table
    • OIU_CM_MKT : Marketing types table
    • OIURV_DOC_VOLUNT : Valuation Document Concept – Volume Unit
    • OIURV_TAXCONFD : State tax configuration detail
    • OIURV_DOC_CRAD : Oil and Gas appl table
    • OIURV_TCD : Tax calculation data
    • OIURV_GASSTMTH : Gas Statement Header
    • OIURV_STS_EMP : Severance Tax Statistics – Exempt
    • OIURV_DOC_CRMKT : Oil and Gas appl table
    • OIURV_DOC_CRH : Oil and Gas appl table
    • OIURV_STS_MKT : Severance Tax Statistics – Marketing
    • OIURV_STS : Severance tax statistics
    • OIURV_TCD_EMP : Tax calculation data

    OIURV_DOC_VOLDTL related transaction codes under SAP package OIU_RVDC

    • O3U_DP1 : DOI Accounting – Doc Concept
    • O3U_VLFR2 : Change Valuation Formula
    • O3U_VLFR9 : Valuation Formula list processing
    • O3URV_SST0 : Settlement Stmnt/DOI Cross-Reference
    • O3UCP_MKT_CST0 : Contract Marketing Costs
    • S_SOG_81000016 : Generated Text
    • O3UVL_MTA : Marketing Cost Tax Allowance
    • O3U_DP6 : DOI Accounting Delete – Doc Concept
    • O3UVL_TCD0 : Tax Calculation Data – Doc Concept
    • O3U_VLFR3 : Display Valuation Formula
    • O3URV_SRPT : Valuation Selection Report
    • O3U_MKT3 : Display Internal Marketing Rates
    • O3U_MKT2 : Change Internal Marketing Rates
    • S_SO7_65001125 : Generated Text
    • O3U_PP2 : Price maintenance
    • O3U_VLFR1 : Create Valuation Formula
    • O3U_DP3 : DOI Accounting Display – Doc Concept
    • O3URV_SS0 : Settlement Statement
    • O3U_PP3 : Price maintenance
    • S_SO7_65001124 : Generated Text

    Related References

    Related Tutorials

    OIURV03_VOLDTL SAP table for – Valuation Transaction Level 2 -Volume

    OIURV03_VOLDTL table in SAP IS-OIL (Production and Revenue Accounting in IS-OIL) module. This table is used for storing data of...

    OIURV03_FRMHDR SAP table for – Valuation Transaction Level 3 – Formula

    OIURV03_FRMHDR table in SAP IS-OIL (Production and Revenue Accounting in IS-OIL) module. This table is used for storing data of...

    OIURV_DOC_FRMHDR SAP table for – Valuation Transaction Level 3 – Formula

    OIURV_DOC_FRMHDR table in SAP IS-OIL (Production and Revenue Accounting in IS-OIL) module. This table is used for storing data of...

    OIURV_DOC_VOLUNT SAP table for – Valuation Document Concept – Volume Unit

    OIURV_DOC_VOLUNT table in SAP IS-OIL (Production and Revenue Accounting in IS-OIL) module. This table is used for storing data of...

    OIURV03_DTL_ZE SAP table for – Valuation Transactions Level 1 – Zero Volume

    OIURV03_DTL_ZE table in SAP IS-OIL (Production and Revenue Accounting in IS-OIL) module. This table is used for storing data of...

    OIURV_DOC_DTL_ZE SAP table for – Valuation Transactions Level 1 – Zero Volume

    OIURV_DOC_DTL_ZE table in SAP IS-OIL (Production and Revenue Accounting in IS-OIL) module. This table is used for storing data of...

    OIUP_SB_RNEWC SAP table for – Residue and NGL entitlements at a WC level (PDM Shadow)

    OIUP_SB_RNEWC table in SAP IS-OIL (Production and Revenue Accounting in IS-OIL) module. This table is used for storing data of...

    «
    »