OIU_SB_OAD

Transparent Table Application Table
14 Fields 1 CDS Views

Owner Availability Detail

OIU_SB_OAD is an SAP database table in S/4HANA. Owner Availability Detail. It contains 14 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 (14)

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

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]
    PRIMARY KEY (MANDT, OAH_NO, REVISION_NO, OWN_NO, OWN_INT_TYPE_CD, OWN_ISQ_NO)
);

Learn More