OIU_SB_RNAWC

Transparent Table Application Table
36 Fields 2 CDS Views

Residue and NGL actual at a WC level

OIU_SB_RNAWC is an SAP database table in S/4HANA. Residue and NGL actual at a WC level. It contains 36 fields. 2 CDS views read from this table.

CDS Views using this table (2)

ViewTypeJoinVDMDescription
I_ContrAllocVolSecdryProdWC view from BASIC CA Volume Secondary Product For WC
OIUCA_V_WC_U_TRNA view_entity from Projection View of Contractual Allocation Well NGL Volume

Fields (36)

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 ct_no OIU_CT_NO Contract
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
KEY orig_mp_no OIU_ORIG_MP_NO Originating MP
KEY trnsp_no OIU_TRNSP_NO Transporter
actl_vol_u OIU_ACTL_VOL_U Unit
actl_vol OIU_ACTL_VOL Actual Volume
heat_val_u OIU_HEAT_VAL_U HV Unit
heat_val OIU_HEAT_VAL Heat.val.factor
actl_energy_u OIU_ACTL_ENERGY_U Energy Unit
actl_energy OIU_ACTL_ENERGY Energy
wg_equiv_qy_u OIU_WG_EQUIV_U WG equiv. UoM
wg_equiv_qy OIU_WG_EQUIV WG equiv.
basis_qy_u OIU_BASIS_QY_U Basis UoM
basis_qy OIU_BASIS_QY Basis qy
entl_ct_vol OIU_ENTL_CT_VOL Ent. Ct. Volume
entl_ct_vol_u OIU_VOL_U Unit
entl_ct_ener OIU_ENTL_CT_ENER Ent Energy
entl_ct_ener_u OIU_ENERGY_U Energy Unit
oiu_cruser ERNAM Created By
oiu_timestamp TZNTSTMPS Time Stamp
pvr /PRA/OWN_PVR Owner PVR
ptr /PRA/OWN_PTR Owner PTR
pvr_uom OIU_ACTL_VOL_U Unit
ptr_uom OIU_ACTL_ENERGY_U Energy Unit
entl_pvr /PRA/OWN_PVR Owner PVR
entl_ptr /PRA/OWN_PTR Owner PTR
entl_pvr_uom OIU_ACTL_VOL_U Unit
entl_ptr_uom OIU_ACTL_ENERGY_U Energy Unit

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.

-- Residue and NGL actual at a WC level
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE OIU_SB_RNAWC (
    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]
    CT_NO,            -- Contract [OIU_CT_NO]
    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]
    ORIG_MP_NO,       -- Originating MP [OIU_ORIG_MP_NO]
    TRNSP_NO,         -- Transporter [OIU_TRNSP_NO]
    ACTL_VOL_U,       -- Unit [OIU_ACTL_VOL_U]
    ACTL_VOL,         -- Actual Volume [OIU_ACTL_VOL]
    HEAT_VAL_U,       -- HV Unit [OIU_HEAT_VAL_U]
    HEAT_VAL,         -- Heat.val.factor [OIU_HEAT_VAL]
    ACTL_ENERGY_U,    -- Energy Unit [OIU_ACTL_ENERGY_U]
    ACTL_ENERGY,      -- Energy [OIU_ACTL_ENERGY]
    WG_EQUIV_QY_U,    -- WG equiv. UoM [OIU_WG_EQUIV_U]
    WG_EQUIV_QY,      -- WG equiv. [OIU_WG_EQUIV]
    BASIS_QY_U,       -- Basis UoM [OIU_BASIS_QY_U]
    BASIS_QY,         -- Basis qy [OIU_BASIS_QY]
    ENTL_CT_VOL,      -- Ent. Ct. Volume [OIU_ENTL_CT_VOL]
    ENTL_CT_VOL_U,    -- Unit [OIU_VOL_U]
    ENTL_CT_ENER,     -- Ent Energy [OIU_ENTL_CT_ENER]
    ENTL_CT_ENER_U,   -- Energy Unit [OIU_ENERGY_U]
    OIU_CRUSER,       -- Created By [ERNAM]
    OIU_TIMESTAMP,    -- Time Stamp [TZNTSTMPS]
    PVR,              -- Owner PVR [/PRA/OWN_PVR]
    PTR,              -- Owner PTR [/PRA/OWN_PTR]
    PVR_UOM,          -- Unit [OIU_ACTL_VOL_U]
    PTR_UOM,          -- Energy Unit [OIU_ACTL_ENERGY_U]
    ENTL_PVR,         -- Owner PVR [/PRA/OWN_PVR]
    ENTL_PTR,         -- Owner PTR [/PRA/OWN_PTR]
    ENTL_PVR_UOM,     -- Unit [OIU_ACTL_VOL_U]
    ENTL_PTR_UOM,     -- Energy Unit [OIU_ACTL_ENERGY_U]
    PRIMARY KEY (MANDT, DN_NO, WL_NO, WC_NO, MATNR, CT_NO, SA_DT, OWN_NO, OWN_INT_TYPE_CD, OWN_ISQ_NO, ORIG_MP_NO, TRNSP_NO)
);

Learn More