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