OIU_DO_DO_WK SAP table for – Division of Interest Ownership Worktable

Here we would like to draw your attention to OIU_DO_DO_WK 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_DO_WK is a SAP standard transp table used for storing Division of Interest Ownership Worktable related data in SAP. It comes under the package OIU.

SAP OIU_DO_DO_WK table

Table OIU_DO_DO_WK technical data

TableOIU_DO_DO_WK
Data storingDivision of Interest Ownership Worktable
ModuleIS-OIL
Sub ModuleIS-OIL-PRA
SAP PackageOIU
Delivery ClassA – Application table (master and transaction data)
ComponentIS-OIL
Table CategoryTRANSP

SAP OIU_DO_DO_WK 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_DO_WK 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
  • CUST_VEND_CD : Customer/Vendor Indicator
    Its a key field. Its data type is CHAR (Character String) with field length 1
  • OWN_NO : PRA owner
    Its a key field. Its data type is CHAR (Character String) with field length 10
  • OWN_INT_TYPE_CD : Participant Interest Type
    Its a key field. Its data type is CHAR (Character String) with field length 2
  • OWN_ISQ_NO : Owner Interest Sequence Number
    Its a key field. Its data type is CHAR (Character String) with field length 2
  • EFF_FROM_DT : Effective from date
    Its a key field. Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • .INCLUDE : Non-key-fields OIU_DO_DO
  • EFF_TO_DT : Effective To Date
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • DO_NO : Division of Interest Number
    Its data type is NUMC (Character String with Digits Only) with field length 12
  • JIB_OFFS_FL : Joint Interest Billing Offset Flag
    Its data type is CHAR (Character String) with field length 1
  • NRI_PC : Net Revenue Interest Percent
    Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 9
  • SUSP_CD : Suspense Reason Code
    Its data type is CHAR (Character String) with field length 3
  • TAX_FREE_CD : Tax Free Code
    Its data type is CHAR (Character String) with field length 2
  • BG_NO : Bearer Group Number
    Its data type is CHAR (Character String) with field length 2
  • PYOUT_CD : Payout Code
    Its data type is CHAR (Character String) with field length 1
  • PAY_CD : Pay Code
    Its data type is CHAR (Character String) with field length 2
  • ENTL_CD : Entitlement 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
  • MMS_POP_COMP_FL : MMS Percent of Proceeds 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
  • ENTY_CD : Entity Code
    Its data type is CHAR (Character String) with field length 2
  • ACCT_ENT_FL : Accounting Entry Override Flag
    Its data type is CHAR (Character String) with field length 1
  • INT_CAT_CD : Interest Category
    Its data type is CHAR (Character String) with field length 1
  • MIN_ROY_DT : Minimum Royalty Date
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • DO_CURR : Currency Key
    Its data type is CUKY (Currency key for a currency field) with field length 5
  • MIN_ROY_AM : Minimum Royalty Amount
    Its data type is CURR (Currency Field) with field length 7
  • ADV_ARRS_CD : Advance Arrears Payment Code
    Its data type is CHAR (Character String) with field length 1
  • CARR_BG_CD : Carried bearer group code
    Its data type is CHAR (Character String) with field length 2
  • LSE_USE_PMT_CD : Pay on Lease Use Fuel
    Its data type is CHAR (Character String) with field length 1
  • JIB_PARTN : JIB Partner
    Its data type is CHAR (Character String) with field length 10
  • PP_KUNNR : Production Payment Owner
    Its data type is CHAR (Character String) with field length 10
  • MMS_RECON_FL : MMS Reconciliation Flag
    Its data type is CHAR (Character String) with field length 1
  • .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