OIU_DO_DP SAP table for – DOI Accounting Information

Here we would like to draw your attention to OIU_DO_DP 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). OIU_DO_DP is a SAP standard transp table used for storing DOI Accounting Information related data in SAP. It comes under the package OIU.

SAP OIU_DO_DP table

Table OIU_DO_DP technical data

TableOIU_DO_DP
Data storingDOI Accounting Information
ModuleIS-OIL
Sub ModuleIS-OIL-PRA
SAP PackageOIU
Delivery ClassA – Application table (master and transaction data)
ComponentIS-OIL
Table CategoryTRANSP

SAP OIU_DO_DP 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 OIU_DO_DP table.

  • MANDT : Client
    Its a key field. Its data type is CLNT (Character with length 3) with field length 3
  • BUKRS : Company Code
    Its a key field. Its data type is CHAR (Character String) with field length 4
  • VNAME : Joint venture
    Its a key field. Its data type is CHAR (Character String) with field length 6
  • DOI_NO : Division of interest (DOI)
    Its a key field. Its data type is CHAR (Character String) with field length 5
  • MAJPD_CD : Major product code
    Its a key field. Its data type is CHAR (Character String) with field length 1
  • EFF_FROM_DT : Effective from date
    Its a key field. Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • PLT_COND_FL : Plant Condensate Material FLag
    Its data type is CHAR (Character String) with field length 1
  • SCUBBER_OIL_FL : Scrubber Oil Material FLag
    Its data type is CHAR (Character String) with field length 1
  • EFF_TO_DT : Effective To Date
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • DP_NO : DOI Accounting Information Number
    Its data type is NUMC (Character String with Digits Only) with field length 12
  • ENTL_CD : Entitlement Code
    Its data type is CHAR (Character String) with field length 1
  • MP_NO : Measurement point number
    Its data type is CHAR (Character String) with field length 20
  • BLN_ROY_FL : Blanchard Royalty Flag
    Its data type is CHAR (Character String) with field length 1
  • REV_RCPT_LAG : Revenue Receipt Lag Month
    Its data type is NUMC (Character String with Digits Only) with field length 2
  • REV_PRCS_CD : Revenue Process Code
    Its data type is CHAR (Character String) with field length 2
  • NRTF_CD : Normal Recording Time Frame Code
    Its data type is CHAR (Character String) with field length 1
  • REC_PYMT_CD : Record Payment/ Check Write Code
    Its data type is CHAR (Character String) with field length 1
  • IGNR_PYMT_FL : Ignore Payment/Pay Next Check Write Flag
    Its data type is CHAR (Character String) with field length 1
  • TAX_RMB_GRNT_CD : Tax Reimbursement at Gross or Net Code
    Its data type is CHAR (Character String) with field length 1
  • TAX_GRNT_CD : Tax Gross or Net Code
    Its data type is CHAR (Character String) with field length 1
  • SSC_FL : Sliding Scale Indicator Flag
    Its data type is CHAR (Character String) with field length 1
  • CUR_HIST_CD : Pay on Current/Historical Ownership (Allocate to Owners)
    Its data type is CHAR (Character String) with field length 1
  • ACCT_ENT_FL : Accounting Entry Override Flag
    Its data type is CHAR (Character String) with field length 1
  • DOI_SUM_FL : Summarize RD to DOI Level Flag
    Its data type is CHAR (Character String) with field length 1
  • OVRD_OWN_CD : Override Owner code
    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
  • WI_PAY_OVRD_FL : Working Interest Payment Override Flag
    Its data type is CHAR (Character String) with field length 1
  • KOSTL : PRA Cost Center
    Its data type is CHAR (Character String) with field length 10
  • .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