OIU_SB_ENTMP

Transparent Table Application Table
26 Fields 2 CDS Views

MP level owner entitlements

OIU_SB_ENTMP is an SAP database table in S/4HANA. MP level owner entitlements. It contains 26 fields. 2 CDS views read from this table.

CDS Views using this table (2)

ViewTypeJoinVDMDescription
I_PRAMsmtPtOwnerEntitlement view_entity from BASIC DOI for Measurement Point
OIUCA_V_MP_U_TENT view_entity from Projection View of Contractual Allocation MP Entitle Volume

Fields (26)

KeyField Data ElementDescription DomainTypeLength
KEY mandt MANDT Client
KEY dn_no OIU_DN_NO Delivery network ID
KEY matnr MATNR Material
KEY mp_no OIU_MP_NO Measurement Pt
KEY bukrs BUKRS Company Code
KEY vname JV_NAME Joint venture
KEY doi_no OIU_DOI_NO Venture/DOI
KEY sa_dt OIU_SA_DT Sales Date
KEY freq_cd OIU_FREQ_CD Frequency
KEY vt_cd OIU_VT_CD Volume Type
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
vol_u OIU_VOL_U Unit
entl_vol OIU_ENTL_VOL Entl. Vol.
adj_entl_vol OIU_ADJ_ENTL_VOL Adj.Entl.Vol.
energy_u OIU_ENERGY_U Energy Unit
entl_energy OIU_ENTL_ENERGY Energy
adj_entl_energy OIU_ADJ_ENTL_ENERGY Adj. Entl. En.
gri_pc OIU_GRI_PC GRI
adj_gri_pc OIU_ADJ_GRI_PC Adjusted GRI
oiu_cruser ERNAM Created By
oiu_timestamp TZNTSTMPS Time Stamp
kw_own_cd BOOLEAN Boolean Variable (X = True, - = False, Space = Unknown)

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.

-- MP level owner entitlements
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE OIU_SB_ENTMP (
    MANDT,            -- Client [MANDT]
    DN_NO,            -- Delivery network ID [OIU_DN_NO]
    MATNR,            -- Material [MATNR]
    MP_NO,            -- Measurement Pt [OIU_MP_NO]
    BUKRS,            -- Company Code [BUKRS]
    VNAME,            -- Joint venture [JV_NAME]
    DOI_NO,           -- Venture/DOI [OIU_DOI_NO]
    SA_DT,            -- Sales Date [OIU_SA_DT]
    FREQ_CD,          -- Frequency [OIU_FREQ_CD]
    VT_CD,            -- Volume Type [OIU_VT_CD]
    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]
    VOL_U,            -- Unit [OIU_VOL_U]
    ENTL_VOL,         -- Entl. Vol. [OIU_ENTL_VOL]
    ADJ_ENTL_VOL,     -- Adj.Entl.Vol. [OIU_ADJ_ENTL_VOL]
    ENERGY_U,         -- Energy Unit [OIU_ENERGY_U]
    ENTL_ENERGY,      -- Energy [OIU_ENTL_ENERGY]
    ADJ_ENTL_ENERGY,  -- Adj. Entl. En. [OIU_ADJ_ENTL_ENERGY]
    GRI_PC,           -- GRI [OIU_GRI_PC]
    ADJ_GRI_PC,       -- Adjusted GRI [OIU_ADJ_GRI_PC]
    OIU_CRUSER,       -- Created By [ERNAM]
    OIU_TIMESTAMP,    -- Time Stamp [TZNTSTMPS]
    KW_OWN_CD,        -- Boolean Variable (X = True, - = False, Space = Unknown) [BOOLEAN]
    PRIMARY KEY (MANDT, DN_NO, MATNR, MP_NO, BUKRS, VNAME, DOI_NO, SA_DT, FREQ_CD, VT_CD, OWN_NO, OWN_INT_TYPE_CD, OWN_ISQ_NO)
);

Learn More