OIU_PR_WCDVLH

Transparent Table Application Table
50 Fields 3 CDS Views

Well Completion Disposition Volumes Header

OIU_PR_WCDVLH is an SAP database table in S/4HANA. Well Completion Disposition Volumes Header. It contains 50 fields. 3 CDS views read from this table.

CDS Views using this table (3)

ViewTypeJoinVDMDescription
I_WellCompltnDisposnVol view from BASIC Well Completion Disposition Volume
OIUPR_V_WC_VOL_U_TWCD view_entity from Projection View of Production Well Completion Volume
UPOV_WCDVLH_PRA view from WC Disposition Volumes Header (PRA)

Fields (50)

KeyField Data ElementDescription DomainTypeLength
KEY mandt MANDT Client
KEY wcdvlh_no OIU_WCDVLH_NO Document No.
KEY doc_year GJAHR Fiscal Year
wl_no OIU_WL_NO Well
wc_no OIU_WC_NO Well Completion
dn_no OIU_DN_NO Delivery network ID
eff_from_dt OIU_EFF_FROM_DT Effective From
eff_to_dt OIU_EFF_TO_DT Effective To
prd_dt OIU_PRD_DT Production Date
prd_matnr OIU_PRD_MATNR Material
matnr MATNR Material
freq_cd OIU_FREQ_CD Frequency
tkbtry_mp_no OIU_TKBTRY_MP_NO Tk.Batt. MP.No.
vt_cd OIU_VT_CD Volume Type
vc_cd OIU_VC_CD Volume Class
vs_cd OIU_VS_CD Volume Source
trnsp_no OIU_TRNSP_NO Transporter
trnsp_ref_no OIU_TRNSP_REF_NO Trsprt.Ref.
rec_type_cd OIU_REC_TYPE_CD Record tp. code
days_prod OIU_DAYS_PROD Days produced
prd_hrs OIU_PRD_HRS Prod. hours
tkt_no OIU_TKT_NO Ticket Number
tkt_timestamp OIU_TKT_TIMESTP Ticket timestp
orig_mp_no OIU_ORIG_MP_NO Originating MP
orig_mp_doc_no OIU_ORIG_MP_DOC_NO Orig. MP docno
orig_mp_doc_year OIU_ORIG_MP_DOC_YEAR Orig. MP docyr
theo_u OIU_THEO_U Theo. unit
theo OIU_THEO Theo. volume
conv_grp OIB_UMRSL Conv. Group
std_vol_u OIU_STD_VOL_U Unit
std_vol OIU_STD_VOL Std Volume
energy_u OIU_ENERGY_U Energy Unit
energy OIU_ENERGY Energy Qty.
heat_val_u OIU_HEAT_VAL_U HV Unit
heat_val OIU_HEAT_VAL Heat.val.factor
base_density OIU_BDICH Base density
base_density_u OIU_BDNEH Unit
dentyp OIU_DNTYP Dens. Type
mol_volume OIU_MOL_VOLUME Ratio/Mole %
invt_dt OIU_INV_DT Inventory date
xref_wl_no OIU_XREF_WL_NO Crossref.Wl.No.
xref_wc_no OIU_XREF_WC_NO Crossref.WC.No.
orig_no OIU_ORIG_NO WCDVl. nr.
orig_doc_year GJAHR Fiscal Year
oiu_cruser ERNAM Created By
oiu_timestamp TZNTSTMPS Time Stamp
ld_oil_wo_recov OIU_LD_OIL_WO_RECOV Ld Oil w/o Recovery
status OIU_WCVL_STS_CD WC Volume Status Code
draft_me_docnr OIU_ME_DOCNR DocNr
draft_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.

-- Well Completion Disposition Volumes Header
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE OIU_PR_WCDVLH (
    MANDT,             -- Client [MANDT]
    WCDVLH_NO,         -- Document No. [OIU_WCDVLH_NO]
    DOC_YEAR,          -- Fiscal Year [GJAHR]
    WL_NO,             -- Well [OIU_WL_NO]
    WC_NO,             -- Well Completion [OIU_WC_NO]
    DN_NO,             -- Delivery network ID [OIU_DN_NO]
    EFF_FROM_DT,       -- Effective From [OIU_EFF_FROM_DT]
    EFF_TO_DT,         -- Effective To [OIU_EFF_TO_DT]
    PRD_DT,            -- Production Date [OIU_PRD_DT]
    PRD_MATNR,         -- Material [OIU_PRD_MATNR]
    MATNR,             -- Material [MATNR]
    FREQ_CD,           -- Frequency [OIU_FREQ_CD]
    TKBTRY_MP_NO,      -- Tk.Batt. MP.No. [OIU_TKBTRY_MP_NO]
    VT_CD,             -- Volume Type [OIU_VT_CD]
    VC_CD,             -- Volume Class [OIU_VC_CD]
    VS_CD,             -- Volume Source [OIU_VS_CD]
    TRNSP_NO,          -- Transporter [OIU_TRNSP_NO]
    TRNSP_REF_NO,      -- Trsprt.Ref. [OIU_TRNSP_REF_NO]
    REC_TYPE_CD,       -- Record tp. code [OIU_REC_TYPE_CD]
    DAYS_PROD,         -- Days produced [OIU_DAYS_PROD]
    PRD_HRS,           -- Prod. hours [OIU_PRD_HRS]
    TKT_NO,            -- Ticket Number [OIU_TKT_NO]
    TKT_TIMESTAMP,     -- Ticket timestp [OIU_TKT_TIMESTP]
    ORIG_MP_NO,        -- Originating MP [OIU_ORIG_MP_NO]
    ORIG_MP_DOC_NO,    -- Orig. MP docno [OIU_ORIG_MP_DOC_NO]
    ORIG_MP_DOC_YEAR,  -- Orig. MP docyr [OIU_ORIG_MP_DOC_YEAR]
    THEO_U,            -- Theo. unit [OIU_THEO_U]
    THEO,              -- Theo. volume [OIU_THEO]
    CONV_GRP,          -- Conv. Group [OIB_UMRSL]
    STD_VOL_U,         -- Unit [OIU_STD_VOL_U]
    STD_VOL,           -- Std Volume [OIU_STD_VOL]
    ENERGY_U,          -- Energy Unit [OIU_ENERGY_U]
    ENERGY,            -- Energy Qty. [OIU_ENERGY]
    HEAT_VAL_U,        -- HV Unit [OIU_HEAT_VAL_U]
    HEAT_VAL,          -- Heat.val.factor [OIU_HEAT_VAL]
    BASE_DENSITY,      -- Base density [OIU_BDICH]
    BASE_DENSITY_U,    -- Unit [OIU_BDNEH]
    DENTYP,            -- Dens. Type [OIU_DNTYP]
    MOL_VOLUME,        -- Ratio/Mole % [OIU_MOL_VOLUME]
    INVT_DT,           -- Inventory date [OIU_INV_DT]
    XREF_WL_NO,        -- Crossref.Wl.No. [OIU_XREF_WL_NO]
    XREF_WC_NO,        -- Crossref.WC.No. [OIU_XREF_WC_NO]
    ORIG_NO,           -- WCDVl. nr. [OIU_ORIG_NO]
    ORIG_DOC_YEAR,     -- Fiscal Year [GJAHR]
    OIU_CRUSER,        -- Created By [ERNAM]
    OIU_TIMESTAMP,     -- Time Stamp [TZNTSTMPS]
    LD_OIL_WO_RECOV,   -- Ld Oil w/o Recovery [OIU_LD_OIL_WO_RECOV]
    STATUS,            -- WC Volume Status Code [OIU_WCVL_STS_CD]
    DRAFT_ME_DOCNR,    -- DocNr [OIU_ME_DOCNR]
    DRAFT_ME_DOCYR,    -- Doc. year [OIU_ME_DOCYR]
    PRIMARY KEY (MANDT, WCDVLH_NO, DOC_YEAR)
);

Learn More