OIURV_DOC_DTL_BK SAP table for – Valuation Transactions Level 1 – Vltxns

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

SAP OIURV_DOC_DTL_BK table

Table OIURV_DOC_DTL_BK technical data

TableOIURV_DOC_DTL_BK
Data storingValuation Transactions Level 1 – Vltxns
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_BK 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_BK 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
  • DN_NO : Delivery network number
    Its data type is CHAR (Character String) with field length 20
  • 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
  • MAJPD_CD : Major product code
    Its data type is CHAR (Character String) with field length 1
  • FREQ_CD : Frequency
    Its data type is CHAR (Character String) with field length 1
  • SALE_DT : Sales Date / Month
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • FRML_NO : Formula number
    Its data type is CHAR (Character String) with field length 8
  • POS_NO : Position Number for
    Its data type is NUMC (Character String with Digits Only) with field length 10
  • LVL_CD : Level Code
    Its data type is NUMC (Character String with Digits Only) with field length 2
  • GROUP_CD : Group Code
    Its data type is CHAR (Character String) with field length 1
  • PPA_RSN_CD : Prior Period Adjustment Reason Code
    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
  • DOI_SUM_FL : Summarize RD to DOI Level Flag
    Its data type is CHAR (Character String) with field length 1
  • RM_FEE_FL : CO2 Removal Fee Flag
    Its data type is CHAR (Character String) with field length 1
  • DUAL_ACCT_FL : Dual Accounting Flag
    Its data type is CHAR (Character String) with field length 1
  • TXN_PRCS_CD : Transaction Process Code
    Its data type is CHAR (Character String) with field length 2
  • CT_TYPE_CD : Contract Type
    Its data type is CHAR (Character String) with field length 2
  • VL_VAL_ON_VAL_FL : Value on Value indicator
    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
  • FULL_SMPL_PLT_CD : Full Simple Plant Network
    Its data type is CHAR (Character String) with field length 1
  • REJ_ZV_CD : Valuation REJ ZV code
    Its data type is CHAR (Character String) with field length 2
  • RPT_POS_NO : Position Number for
    Its data type is NUMC (Character String with Digits Only) with field length 10
  • REJ_RSN_CD : Rejection Reason Code
    Its data type is CHAR (Character String) with field length 3
  • .INCLUDE : Creator and date/time created
  • OIU_CRUSER : Name of Person who Created the Object
    Its data type is CHAR (Character String) with field length 12
  • OIU_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
  • REMT_NO : Remitter
    Its data type is CHAR (Character String) with field length 10
  • REMT_SEQ_NO : Owner Interest Sequence Number
    Its data type is CHAR (Character String) with field length 2
  • PU_PR_NO : Purchaser’s Lease Number
    Its data type is CHAR (Character String) with field length 18
  • PU_PD_CD : Purchaser’s Xref Product / Material
    Its data type is CHAR (Character String) with field length 3
  • ACCT_PERD_DT : Accounting Period
    Its data type is CHAR (Character String) with field length 10
  • SPC_DIST_CD : Special Distribution Flag
    Its data type is CHAR (Character String) with field length 1