OIU_DO_OAG

Transparent Table Application Table
18 Fields 1 CDS Views

Ownership Attribute Grouping

OIU_DO_OAG is an SAP database table in S/4HANA. Ownership Attribute Grouping. It contains 18 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
I_OwnerAttributeGroup view_entity from BASIC Owner Attribute Group

Fields (18)

KeyField Data ElementDescription DomainTypeLength
KEY mandt mandt Client
KEY oag_id oiu_oag_id Attribute Group
KEY eff_from_dt oiu_eff_from_dt Effective From
eff_to_dt oiu_eff_to_dt Effective To
oag_desc oiu_oag_desc Attribute Group Desc
mfg_is_used oiu_oag_mfg_is_used Use MFG for Owners
con_as_oil_fl oiu_oag_con_as_oil_fl Use Oil MFG for Cond
ngl_as_gas_fl oiu_oag_ngl_as_gas_fl Use Gas MFG for NGLs
maint_wtr_sul_inj_fl oiu_oag_maint_wtr_sul_inj_fl Maint Misc Pd MFGs
mfg_majpd_oil oiu_mkt_fg_oil Oil Mkt Free Preset
mfg_majpd_gas oiu_mkt_fg_gas Gas Mkt Free Preset
mfg_majpd_con oiu_mkt_fg_con Cond Mkt Free Preset
mfg_majpd_ngl oiu_mkt_fg_ngl NGL Mkt Free Preset
mfg_majpd_wtr oiu_mkt_fg_wtr Water Mkt Fr Preset
mfg_majpd_sul oiu_mkt_fg_sul Sulfur Mkt Fr Preset
mfg_majpd_inj oiu_mkt_fg_inj Inj Mkt Free Preset
last_user oiu_user_id User ID
last_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.

-- Ownership Attribute Grouping
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE OIU_DO_OAG (
    MANDT,                 -- Client [mandt]
    OAG_ID,                -- Attribute Group [oiu_oag_id]
    EFF_FROM_DT,           -- Effective From [oiu_eff_from_dt]
    EFF_TO_DT,             -- Effective To [oiu_eff_to_dt]
    OAG_DESC,              -- Attribute Group Desc [oiu_oag_desc]
    MFG_IS_USED,           -- Use MFG for Owners [oiu_oag_mfg_is_used]
    CON_AS_OIL_FL,         -- Use Oil MFG for Cond [oiu_oag_con_as_oil_fl]
    NGL_AS_GAS_FL,         -- Use Gas MFG for NGLs [oiu_oag_ngl_as_gas_fl]
    MAINT_WTR_SUL_INJ_FL,  -- Maint Misc Pd MFGs [oiu_oag_maint_wtr_sul_inj_fl]
    MFG_MAJPD_OIL,         -- Oil Mkt Free Preset [oiu_mkt_fg_oil]
    MFG_MAJPD_GAS,         -- Gas Mkt Free Preset [oiu_mkt_fg_gas]
    MFG_MAJPD_CON,         -- Cond Mkt Free Preset [oiu_mkt_fg_con]
    MFG_MAJPD_NGL,         -- NGL Mkt Free Preset [oiu_mkt_fg_ngl]
    MFG_MAJPD_WTR,         -- Water Mkt Fr Preset [oiu_mkt_fg_wtr]
    MFG_MAJPD_SUL,         -- Sulfur Mkt Fr Preset [oiu_mkt_fg_sul]
    MFG_MAJPD_INJ,         -- Inj Mkt Free Preset [oiu_mkt_fg_inj]
    LAST_USER,             -- User ID [oiu_user_id]
    LAST_TIMESTAMP,        -- Time Stamp [tzntstmps]
    PRIMARY KEY (MANDT, OAG_ID, EFF_FROM_DT)
);

Learn More