OIU_SB_SPEWC_T

Transparent Table Application Table
17 Fields 1 CDS Views

Special owner entitlements at WC level

OIU_SB_SPEWC_T is an SAP database table in S/4HANA. Special owner entitlements at WC level. It contains 17 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
OIUCA_V_WC_U_TSPE view_entity union_all Projection View of Contractual Allocation Well Entitle Volume

Fields (17)

KeyField Data ElementDescription DomainTypeLength
KEY mandt MANDT Client
KEY dn_no OIU_DN_NO Delivery network ID
KEY wl_no OIU_WL_NO Well
KEY wc_no OIU_WC_NO Well Completion
KEY matnr MATNR Material
KEY sa_dt OIU_SA_DT Sales Date
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
entl_vol_u OIU_ENTL_VOL_U Unit
entl_vol OIU_ENTL_VOL Entl. Vol.
heat_val_u OIU_HEAT_VAL_U HV Unit
heat_val OIU_HEAT_VAL Heat.val.factor
energy_u OIU_ENERGY_U Energy Unit
entl_energy OIU_ENTL_ENERGY Energy
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.

-- Special owner entitlements at WC level
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE OIU_SB_SPEWC_T (
    MANDT,            -- Client [MANDT]
    DN_NO,            -- Delivery network ID [OIU_DN_NO]
    WL_NO,            -- Well [OIU_WL_NO]
    WC_NO,            -- Well Completion [OIU_WC_NO]
    MATNR,            -- Material [MATNR]
    SA_DT,            -- Sales Date [OIU_SA_DT]
    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]
    ENTL_VOL_U,       -- Unit [OIU_ENTL_VOL_U]
    ENTL_VOL,         -- Entl. Vol. [OIU_ENTL_VOL]
    HEAT_VAL_U,       -- HV Unit [OIU_HEAT_VAL_U]
    HEAT_VAL,         -- Heat.val.factor [OIU_HEAT_VAL]
    ENERGY_U,         -- Energy Unit [OIU_ENERGY_U]
    ENTL_ENERGY,      -- Energy [OIU_ENTL_ENERGY]
    OIU_CRUSER,       -- Created By [ERNAM]
    OIU_TIMESTAMP,    -- Time Stamp [TZNTSTMPS]
    PRIMARY KEY (MANDT, DN_NO, WL_NO, WC_NO, MATNR, SA_DT, OWN_NO, OWN_INT_TYPE_CD, OWN_ISQ_NO)
);

Learn More