OIU_SB_CTRWC

Transparent Table Application Table
27 Fields 2 CDS Views

Volumes for sale

OIU_SB_CTRWC is an SAP database table in S/4HANA. Volumes for sale. It contains 27 fields. 2 CDS views read from this table.

CDS Views using this table (2)

ViewTypeJoinVDMDescription
I_PRAWellCompltnMnlEntrSlsVol view_entity from BASIC Well Completion Manual Entry Sales Volume
OIUCA_V_WC_U_TCTR view_entity from Projection View of Contractual Allocation Well Sale Volume

Fields (27)

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

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 (
    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]
    PRIMARY KEY (MANDT, DN_NO, SA_DT, WL_NO, WC_NO, ORIG_MP_NO, TRNSP_NO, MATNR, FREQ_CD, CT_NO)
);

Learn More