OIU_DO_DO_WK

Division of Interest Ownership Worktable | #masterdata | Component: Production and Revenue Accounting
Column Name Description
MANDT Client
BUKRS FK Company Code
VNAME FK Joint venture
DOI_NO FK Division of interest (DOI)
CUST_VEND_CD Customer/Vendor Indicator Show values
OWN_NO FK PRA owner
OWN_INT_TYPE_CD FK Participant Interest Type
OWN_ISQ_NO Owner Interest Sequence Number
EFF_FROM_DT Effective from date
Column Name Description
💲 Currency Key (DO_CURR):
MIN_ROY_AM Minimum Royalty Amount
Column Name Description
Column Name Description
EFF_FROM_DT Effective from date
EFF_TO_DT Effective To Date
MIN_ROY_DT Minimum Royalty Date
Column Name Description
CUST_VEND_CD Customer/Vendor Indicator Show values
JIB_OFFS_FL Joint Interest Billing Offset Flag Show values
PAY_CD Pay Code Show values
ENTL_CD Entitlement Code Show values
SSC_FL Sliding Scale Indicator Flag Show values
MMS_POP_COMP_FL MMS Percent of Proceeds Flag Show values
DUAL_ACCT_FL Dual Accounting Flag Show values
ENTY_CD Entity Code Show values
ACCT_ENT_FL Accounting Entry Override Flag Show values
INT_CAT_CD Interest Category Show values
ADV_ARRS_CD Advance Arrears Payment Code Show values
LSE_USE_PMT_CD Pay on Lease Use Fuel Show values
MMS_RECON_FL MMS Reconciliation Flag Show values
SET_DIV Owner Settlement Diversity Indicator Show values
Column Name Description Domain name
DO_NO Division of Interest Number OIU_SYS_NO
NRI_PC Net Revenue Interest Percent OIU_PERCENT98
BG_NO Bearer Group Number OIU_BG_NO
CARR_BG_CD Carried bearer group code OIU_CARR_BG_CD
OIU_CRUSER Name of Person Responsible for Creating the Object USNAM
OIU_TIMESTAMP UTC Time Stamp in Short Form (YYYYMMDDhhmmss) TZNTSTMPS
LEASE_ID Lease ID for an owner OIU_LEASE_ID
NET_MINERAL_ACRES Net Mineral Acres OIU_NET_MINERAL_ACRES
GRI_PC Gross Revenue Interest Decimal OIU_PERCENT98
RT_BG_NO Bearer Group Number OIU_BG_NO
Master Data Relations Join Conditions
Company code
  • OIU_DO_DO_WK.MANDT == T001.MANDT
  • OIU_DO_DO_WK.BUKRS == T001.BUKRS
Division Of Interest
  • Joint venture
  • Division of interest (DOI)
  • Company Code
Currency
  • OIU_DO_DO_WK.MANDT == TCURC.MANDT
  • OIU_DO_DO_WK.DO_CURR == TCURC.WAERS
Customer/Partner
  • OIU_DO_DO_WK.MANDT == KNA1.MANDT
  • OIU_DO_DO_WK.JIB_PARTN == KNA1.KUNNR
Participant Interest Type OIU_DO_DO_WK.OWN_INT_TYPE_CD == OIU_CM_PINTTY.OWN_INT_TYPE_CD
PRA owner
  • OIU_DO_DO_WK.MANDT == LFA1.MANDT
  • OIU_DO_DO_WK.OWN_NO == LFA1.LIFNR
PP KUNNR
OIU_CM_PAYOUT OIU_DO_DO_WK.PYOUT_CD == OIU_CM_PAYOUT.PYOUT_CD
Suspense Code
Tax Free Code OIU_DO_DO_WK.TAX_FREE_CD == OIU_CM_TFC.TAX_FREE_CD
Venture
  • Joint venture
  • Company Code