OIU_DO_DO

Transparent Table Application Table
43 Fields 10 CDS Views

Division of Interest Ownership

OIU_DO_DO is an SAP database table in S/4HANA. Division of Interest Ownership. It contains 43 fields. 10 CDS views read from this table.

CDS Views using this table (10)

ViewTypeJoinVDMDescription
/pra/ofs_V_Do_Do_Pv view from Private View: Division Order
I_PRADivnOfIntrstOwner view_entity from BASIC PRA DOI Owner Information
I_PRAMaintDOIOwner view from BASIC Maintain DOI Ownership
I_PRAMaintMarketingExempt view inner BASIC Maintain Marketing Exemption XI
I_PRAMaintSlidingScale view inner BASIC Maintain Owner Sliding Scale XI
I_PRAMaintSlidingScaleHdr view inner BASIC Maintain Sliding Scale Header XI
I_PRAMaintStateTaxExempt view inner BASIC Maintain State Tax Exemption XI
OIUOW_V_DO_LEASE_OAG_USAGE view_entity from View of oiu_do_do w lease and oag
oiuow_v_do_mkex_oag_mfg view_entity from View of oiu_do_do w mkex, oag and mfg
oiuow_v_do_mkex_oag_mfg view_entity union_all View of oiu_do_do w mkex, oag and mfg

Fields (43)

KeyField Data ElementDescription DomainTypeLength
KEY mandt MANDT Client
KEY bukrs BUKRS Company Code
KEY vname JV_NAME Joint venture
KEY doi_no OIU_DOI_NO Venture/DOI
KEY cust_vend_cd OIU_CUST_VEND_CD CustVend Ind
KEY own_no OIU_OWN_NO Owner
KEY own_int_type_cd OIU_PART_INT_TYPE Interest Type
KEY own_isq_no OIU_OWN_ISQ_NO Own. ISQ
KEY eff_from_dt OIU_EFF_FROM_DT Effective From
eff_to_dt OIU_EFF_TO_DT Effective To
do_no OIU_DO_NO Div.int.no
jib_offs_fl OIU_JIB_OFFS_FL JIB Offset
nri_pc OIU_NRI_PC NRI
susp_cd OIU_SUSP_CD Suspense Reason
tax_free_cd OIU_TAX_FREE_CD Tax Free
bg_no OIU_BG_NO Bearer Group
pyout_cd OIU_PYOUT_CD Payout Code
pay_cd OIU_PAY_CD Pay Code
entl_cd OIU_ENTL_CD Entitlement CD
ssc_fl OIU_SSC_FL Sliding Scale
mms_pop_comp_fl OIU_MMS_POP_COMP_FL MMS Proceeds =
dual_acct_fl OIU_DUAL_ACCT_FL Dual Accounting
enty_cd OIU_ENTY_CD Entity Type
acct_ent_fl OIU_ACCT_ENT_FL Acct. Override
int_cat_cd OIU_INT_CAT_CD Interest Cat.
min_roy_dt OIU_MIN_ROY_DT Min. Royalty Dt.
do_curr WAERS Currency
min_roy_am OIU_MIN_ROY_AM Min. Royalty Am.
adv_arrs_cd OIU_ADV_ARRS_CD Adv. Arrears
carr_bg_cd OIU_CARR_BG_CD Carried Bearer
lse_use_pmt_cd OIU_LSE_USE_PMT_CD Lease Use Fuel
jib_partn OIU_JIB_PARTN JIB Partner
pp_kunnr OIU_PP_KUNNR Prod. Pay. Own.
mms_recon_fl OIU_MMS_RECON_FL MMS Reconcile
oiu_cruser ERNAM Created By
oiu_timestamp TZNTSTMPS Time Stamp
set_div OIU_SET_DIV_IND Set Div
lease_id OIU_LEASE_ID Lease ID
net_mineral_acres OIU_NET_MINERAL_ACRES Net Mineral Acres
gri_pc OIU_GRI_PC GRI
oag_id OIU_OAG_ID Attribute Group
dsd_instr OIU_DSD_INSTR_VALUE DSD Instruction
rt_bg_no OIU_RT_BG_NO Record Title BG

Derived SQL schema, reconstructed from the indexed DDIC field metadata (field names, types, lengths and key flags) — a functional representation, not the verbatim SAP source.

-- Division of Interest Ownership
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE OIU_DO_DO (
    MANDT,              -- Client [MANDT]
    BUKRS,              -- Company Code [BUKRS]
    VNAME,              -- Joint venture [JV_NAME]
    DOI_NO,             -- Venture/DOI [OIU_DOI_NO]
    CUST_VEND_CD,       -- CustVend Ind [OIU_CUST_VEND_CD]
    OWN_NO,             -- Owner [OIU_OWN_NO]
    OWN_INT_TYPE_CD,    -- Interest Type [OIU_PART_INT_TYPE]
    OWN_ISQ_NO,         -- Own. ISQ [OIU_OWN_ISQ_NO]
    EFF_FROM_DT,        -- Effective From [OIU_EFF_FROM_DT]
    EFF_TO_DT,          -- Effective To [OIU_EFF_TO_DT]
    DO_NO,              -- Div.int.no [OIU_DO_NO]
    JIB_OFFS_FL,        -- JIB Offset [OIU_JIB_OFFS_FL]
    NRI_PC,             -- NRI [OIU_NRI_PC]
    SUSP_CD,            -- Suspense Reason [OIU_SUSP_CD]
    TAX_FREE_CD,        -- Tax Free [OIU_TAX_FREE_CD]
    BG_NO,              -- Bearer Group [OIU_BG_NO]
    PYOUT_CD,           -- Payout Code [OIU_PYOUT_CD]
    PAY_CD,             -- Pay Code [OIU_PAY_CD]
    ENTL_CD,            -- Entitlement CD [OIU_ENTL_CD]
    SSC_FL,             -- Sliding Scale [OIU_SSC_FL]
    MMS_POP_COMP_FL,    -- MMS Proceeds = [OIU_MMS_POP_COMP_FL]
    DUAL_ACCT_FL,       -- Dual Accounting [OIU_DUAL_ACCT_FL]
    ENTY_CD,            -- Entity Type [OIU_ENTY_CD]
    ACCT_ENT_FL,        -- Acct. Override [OIU_ACCT_ENT_FL]
    INT_CAT_CD,         -- Interest Cat. [OIU_INT_CAT_CD]
    MIN_ROY_DT,         -- Min. Royalty Dt. [OIU_MIN_ROY_DT]
    DO_CURR,            -- Currency [WAERS]
    MIN_ROY_AM,         -- Min. Royalty Am. [OIU_MIN_ROY_AM]
    ADV_ARRS_CD,        -- Adv. Arrears [OIU_ADV_ARRS_CD]
    CARR_BG_CD,         -- Carried Bearer [OIU_CARR_BG_CD]
    LSE_USE_PMT_CD,     -- Lease Use Fuel [OIU_LSE_USE_PMT_CD]
    JIB_PARTN,          -- JIB Partner [OIU_JIB_PARTN]
    PP_KUNNR,           -- Prod. Pay. Own. [OIU_PP_KUNNR]
    MMS_RECON_FL,       -- MMS Reconcile [OIU_MMS_RECON_FL]
    OIU_CRUSER,         -- Created By [ERNAM]
    OIU_TIMESTAMP,      -- Time Stamp [TZNTSTMPS]
    SET_DIV,            -- Set Div [OIU_SET_DIV_IND]
    LEASE_ID,           -- Lease ID [OIU_LEASE_ID]
    NET_MINERAL_ACRES,  -- Net Mineral Acres [OIU_NET_MINERAL_ACRES]
    GRI_PC,             -- GRI [OIU_GRI_PC]
    OAG_ID,             -- Attribute Group [OIU_OAG_ID]
    DSD_INSTR,          -- DSD Instruction [OIU_DSD_INSTR_VALUE]
    RT_BG_NO,           -- Record Title BG [OIU_RT_BG_NO]
    PRIMARY KEY (MANDT, BUKRS, VNAME, DOI_NO, CUST_VEND_CD, OWN_NO, OWN_INT_TYPE_CD, OWN_ISQ_NO, EFF_FROM_DT)
);

Learn More