OIU_SB_CTRWC_T

Transparent Table Application Table
29 Fields 1 CDS Views

Volumes for sale

OIU_SB_CTRWC_T is an SAP database table in S/4HANA. Volumes for sale. It contains 29 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
OIUCA_V_WC_U_TCTR view_entity union_all Projection View of Contractual Allocation Well Sale Volume

Fields (29)

KeyField Data ElementDescription DomainTypeLength
KEY mandt MANDT Client
KEY dn_no OIU_DN_NO Delivery network ID
KEY sa_dt OIU_SA_DT Sales Date
KEY wl_no OIU_WL_NO Well
KEY wc_no OIU_WC_NO Well Completion
KEY orig_mp_no OIU_ORIG_MP_NO Originating MP
KEY trnsp_no OIU_TRNSP_NO Transporter
KEY matnr MATNR Material
KEY freq_cd OIU_FREQ_CD Frequency
KEY ct_no OIU_CT_NO Contract
vc_cd OIU_VC_CD Volume Class
std_vol_u OIU_STD_VOL_U Unit
std_vol OIU_STD_VOL Std Volume
std_heat_val_u OIU_STD_HEAT_VAL_U Std HV unit
std_heat_val OIU_STD_HEAT_VAL Standardized HV
std_energy_u OIU_STD_ENERGY_U Std.energy UoM
std_energy OIU_STD_ENERGY Std. Energy
qy_u OIU_QY_U Quantity Unit
entl_qy OIU_ENTL_QY Entitled Qy
adj_entl_qy OIU_ADJ_ENTL_QY Tot. Adj. Entl.
phase_1_qy OIU_PHASE_1_QY Phase 1 Imb.
phase_2_qy OIU_PHASE_2_QY Phase 2 Imb.
phase_3_qy OIU_PHASE_3_QY Phase 3 Imb.
phase_4_qy OIU_PHASE_4_QY Phase 4 quant.
phase_5_qy OIU_PHASE_5_QY Phase 5 quant.
me_docnr OIU_ME_DOCNR DocNr
me_docyr OIU_ME_DOCYR Doc. year
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.

-- Volumes for sale
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE OIU_SB_CTRWC_T (
    MANDT,           -- Client [MANDT]
    DN_NO,           -- Delivery network ID [OIU_DN_NO]
    SA_DT,           -- Sales Date [OIU_SA_DT]
    WL_NO,           -- Well [OIU_WL_NO]
    WC_NO,           -- Well Completion [OIU_WC_NO]
    ORIG_MP_NO,      -- Originating MP [OIU_ORIG_MP_NO]
    TRNSP_NO,        -- Transporter [OIU_TRNSP_NO]
    MATNR,           -- Material [MATNR]
    FREQ_CD,         -- Frequency [OIU_FREQ_CD]
    CT_NO,           -- Contract [OIU_CT_NO]
    VC_CD,           -- Volume Class [OIU_VC_CD]
    STD_VOL_U,       -- Unit [OIU_STD_VOL_U]
    STD_VOL,         -- Std Volume [OIU_STD_VOL]
    STD_HEAT_VAL_U,  -- Std HV unit [OIU_STD_HEAT_VAL_U]
    STD_HEAT_VAL,    -- Standardized HV [OIU_STD_HEAT_VAL]
    STD_ENERGY_U,    -- Std.energy UoM [OIU_STD_ENERGY_U]
    STD_ENERGY,      -- Std. Energy [OIU_STD_ENERGY]
    QY_U,            -- Quantity Unit [OIU_QY_U]
    ENTL_QY,         -- Entitled Qy [OIU_ENTL_QY]
    ADJ_ENTL_QY,     -- Tot. Adj. Entl. [OIU_ADJ_ENTL_QY]
    PHASE_1_QY,      -- Phase 1 Imb. [OIU_PHASE_1_QY]
    PHASE_2_QY,      -- Phase 2 Imb. [OIU_PHASE_2_QY]
    PHASE_3_QY,      -- Phase 3 Imb. [OIU_PHASE_3_QY]
    PHASE_4_QY,      -- Phase 4 quant. [OIU_PHASE_4_QY]
    PHASE_5_QY,      -- Phase 5 quant. [OIU_PHASE_5_QY]
    ME_DOCNR,        -- DocNr [OIU_ME_DOCNR]
    ME_DOCYR,        -- Doc. year [OIU_ME_DOCYR]
    OIU_CRUSER,      -- Created By [ERNAM]
    OIU_TIMESTAMP,   -- Time Stamp [TZNTSTMPS]
    PRIMARY KEY (MANDT, DN_NO, SA_DT, WL_NO, WC_NO, ORIG_MP_NO, TRNSP_NO, MATNR, FREQ_CD, CT_NO)
);

Learn More