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

Here we would like to draw your attention to OIURV_DOC_DTL_ZE 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_DTL_ZE is a SAP standard transp table used for storing Valuation Transactions Level 1 – Zero Volume related data in SAP. It comes under the package OIU_RVDC.

SAP OIURV_DOC_DTL_ZE table

Table OIURV_DOC_DTL_ZE technical data

TableOIURV_DOC_DTL_ZE
Data storingValuation Transactions Level 1 – Zero 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_DTL_ZE 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_DTL_ZE 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
  • SEQ_NO : Document Line Number
    Its a key field. Its data type is NUMC (Character String with Digits Only) with field length 5
  • LINE_NO : Document Line Number
    Its a key field. Its data type is NUMC (Character String with Digits Only) with field length 5
  • DN_NO : Delivery network number
    Its data type is CHAR (Character String) with field length 20
  • SALE_DT : Sales Date / Month
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • FREQ_CD : Frequency
    Its data type is CHAR (Character String) with field length 1
  • WL_NO : Well ID number
    Its data type is CHAR (Character String) with field length 15
  • WC_NO : Well Completion Number
    Its data type is CHAR (Character String) with field length 5
  • MP_NO : Measurement point number
    Its data type is CHAR (Character String) with field length 20
  • MATNR : Material Number
    Its data type is CHAR (Character String) with field length 18
  • BUKRS : Company Code
    Its data type is CHAR (Character String) with field length 4
  • VNAME : Joint venture
    Its data type is CHAR (Character String) with field length 6
  • DOI_NO : Division of interest (DOI)
    Its data type is CHAR (Character String) with field length 5
  • CT_NO : Contract Number
    Its data type is CHAR (Character String) with field length 10
  • CT_TYPE_CD : Contract Type
    Its data type is CHAR (Character String) with field length 2
  • UNIT_VNAME : Joint venture
    Its data type is CHAR (Character String) with field length 6
  • MAJPD_CD : Major product code
    Its data type is CHAR (Character String) with field length 1
  • SCHOOL_DIST_CD : School district code
    Its data type is CHAR (Character String) with field length 3
  • TAX_CLASS : Tax Class
    Its data type is CHAR (Character String) with field length 4
  • 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
  • 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
  • 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
  • ORIG_MP_NO : Original measurement point number
    Its data type is CHAR (Character String) with field length 20
  • MP_TYPE_CD : Measurement point type code
    Its data type is CHAR (Character String) with field length 2
  • FRML_NO : Formula number
    Its data type is CHAR (Character String) with field length 8
  • PPA_RSN_CD : Prior Period Adjustment Reason Code
    Its data type is CHAR (Character String) with field length 2
  • REJ_RSN_CD : Rejection Reason Code
    Its data type is CHAR (Character String) with field length 3
  • REJ_ZV_CD : Valuation REJ ZV code
    Its data type is CHAR (Character String) with field length 2
  • DOI_SUM_FL : Summarize RD to DOI Level Flag
    Its data type is CHAR (Character String) with field length 1
  • REJ_REPRCS_FL : Reject Reprocess Flag
    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