OIU_DO_DP

Transparent Table Application Table

DOI Accounting Information

OIU_DO_DP is an SAP database table in S/4HANA. DOI Accounting Information. It contains 30 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
I_PRADivnOfIntrstAccounting view_entity from BASIC DOI Accounting Information

Fields (30)

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 majpd_cd OIU_MAJPD_CD Major Product
KEY eff_from_dt OIU_EFF_FROM_DT Effective From
plt_cond_fl OIU_PLT_COND_FL Plant Cond
scubber_oil_fl OIU_SCRUBBER_OIL_FL Scrubber Oil
eff_to_dt OIU_EFF_TO_DT Effective To
dp_no OIU_DP_NO DOI acc. no
entl_cd OIU_ENTL_CD Entitlement CD
mp_no OIU_MP_NO Measurement Pt
bln_roy_fl OIU_BLN_ROY_FL Bln Royalty fl
rev_rcpt_lag OIU_REV_RCPT_LAG RevRcpt Lag Mth
rev_prcs_cd OIU_REV_PRCS_CD Rev Process
nrtf_cd OIU_NRTF_CD Normal RTF
rec_pymt_cd OIU_REC_PYMT_CD Record Payment
ignr_pymt_fl OIU_IGNR_PYMT_FL Make Next Pymt
tax_rmb_grnt_cd OIU_TAX_RMB_GRNT_CD Tax Reimbursmtn
tax_grnt_cd OIU_TAX_GRNT_CD Tax G/N
ssc_fl OIU_SSC_FL Sliding Scale
cur_hist_cd OIU_CUR_HIST_CD Current/Hist
acct_ent_fl OIU_ACCT_ENT_FL Acct. Override
doi_sum_fl OIU_DOI_SUM_FL Sum DOI lvl
ovrd_own_cd OIU_OVRD_OWN_CD Override owner
theo_cnd_tax_fl OIU_THEO_CND_TAX_FL Theo Cond Tax
wi_pay_ovrd_fl OIU_WI_PAY_OVRD_FL WI payment ovr
kostl OIUCM_KOSTL Cost Center
oiu_cruser ERNAM Created By
oiu_timestamp TZNTSTMPS Time Stamp

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.

-- DOI Accounting Information
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE OIU_DO_DP (
    MANDT,            -- Client [MANDT]
    BUKRS,            -- Company Code [BUKRS]
    VNAME,            -- Joint venture [JV_NAME]
    DOI_NO,           -- Venture/DOI [OIU_DOI_NO]
    MAJPD_CD,         -- Major Product [OIU_MAJPD_CD]
    EFF_FROM_DT,      -- Effective From [OIU_EFF_FROM_DT]
    PLT_COND_FL,      -- Plant Cond [OIU_PLT_COND_FL]
    SCUBBER_OIL_FL,   -- Scrubber Oil [OIU_SCRUBBER_OIL_FL]
    EFF_TO_DT,        -- Effective To [OIU_EFF_TO_DT]
    DP_NO,            -- DOI acc. no [OIU_DP_NO]
    ENTL_CD,          -- Entitlement CD [OIU_ENTL_CD]
    MP_NO,            -- Measurement Pt [OIU_MP_NO]
    BLN_ROY_FL,       -- Bln Royalty fl [OIU_BLN_ROY_FL]
    REV_RCPT_LAG,     -- RevRcpt Lag Mth [OIU_REV_RCPT_LAG]
    REV_PRCS_CD,      -- Rev Process [OIU_REV_PRCS_CD]
    NRTF_CD,          -- Normal RTF [OIU_NRTF_CD]
    REC_PYMT_CD,      -- Record Payment [OIU_REC_PYMT_CD]
    IGNR_PYMT_FL,     -- Make Next Pymt [OIU_IGNR_PYMT_FL]
    TAX_RMB_GRNT_CD,  -- Tax Reimbursmtn [OIU_TAX_RMB_GRNT_CD]
    TAX_GRNT_CD,      -- Tax G/N [OIU_TAX_GRNT_CD]
    SSC_FL,           -- Sliding Scale [OIU_SSC_FL]
    CUR_HIST_CD,      -- Current/Hist [OIU_CUR_HIST_CD]
    ACCT_ENT_FL,      -- Acct. Override [OIU_ACCT_ENT_FL]
    DOI_SUM_FL,       -- Sum DOI lvl [OIU_DOI_SUM_FL]
    OVRD_OWN_CD,      -- Override owner [OIU_OVRD_OWN_CD]
    THEO_CND_TAX_FL,  -- Theo Cond Tax [OIU_THEO_CND_TAX_FL]
    WI_PAY_OVRD_FL,   -- WI payment ovr [OIU_WI_PAY_OVRD_FL]
    KOSTL,            -- Cost Center [OIUCM_KOSTL]
    OIU_CRUSER,       -- Created By [ERNAM]
    OIU_TIMESTAMP,    -- Time Stamp [TZNTSTMPS]
    PRIMARY KEY (MANDT, BUKRS, VNAME, DOI_NO, MAJPD_CD, EFF_FROM_DT)
);