OIU_SB_OAD

Transparent Table Application Table
16 Fields 1 CDS Views

Owner Availability Detail

OIU_SB_OAD is an SAP database table in S/4HANA. Owner Availability Detail. It contains 16 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
I_PRAOwnerAvailabilityDetail view_entity from BASIC PRA Owner Availability Detail

Fields (16)

KeyField Data ElementDescription DomainTypeLength
KEY mandt MANDT Client
KEY oah_no OIU_OAH_NO OAH No
KEY revision_no OIU_REVISION_NO Revision No.
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
mk_rep_no OIU_MK_REP_NO Marketing Rep
mk_rep_isq_no OIU_MK_REP_ISQ_NO Mkt. Rep. ISQ
appr_fl OIU_APPR_FL Approval
orig_gri_pc OIU_ORIG_GRI_PC Original GRI
orig_entl_vl OIU_ORIG_ENTL_VL Orig. Entl. Vol
mkup_vl OIU_MKUP_VL Makeup Vol
adj_entl_vl OIU_ADJ_ENTL_VL Adj. Entl. Vol
adj_gri_pc OIU_ADJ_GRI_PC Adjusted GRI
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.

-- Owner Availability Detail
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE OIU_SB_OAD (
    MANDT,            -- Client [MANDT]
    OAH_NO,           -- OAH No [OIU_OAH_NO]
    REVISION_NO,      -- Revision No. [OIU_REVISION_NO]
    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]
    MK_REP_NO,        -- Marketing Rep [OIU_MK_REP_NO]
    MK_REP_ISQ_NO,    -- Mkt. Rep. ISQ [OIU_MK_REP_ISQ_NO]
    APPR_FL,          -- Approval [OIU_APPR_FL]
    ORIG_GRI_PC,      -- Original GRI [OIU_ORIG_GRI_PC]
    ORIG_ENTL_VL,     -- Orig. Entl. Vol [OIU_ORIG_ENTL_VL]
    MKUP_VL,          -- Makeup Vol [OIU_MKUP_VL]
    ADJ_ENTL_VL,      -- Adj. Entl. Vol [OIU_ADJ_ENTL_VL]
    ADJ_GRI_PC,       -- Adjusted GRI [OIU_ADJ_GRI_PC]
    OIU_CRUSER,       -- Created By [ERNAM]
    OIU_TIMESTAMP,    -- Time Stamp [TZNTSTMPS]
    PRIMARY KEY (MANDT, OAH_NO, REVISION_NO, OWN_NO, OWN_INT_TYPE_CD, OWN_ISQ_NO)
);

Learn More