OIU_PR_WCVD

Transparent Table Application Table
20 Fields 2 CDS Views

Well Completion Variable Data

OIU_PR_WCVD is an SAP database table in S/4HANA. Well Completion Variable Data. It contains 20 fields. 2 CDS views read from this table.

CDS Views using this table (2)

ViewTypeJoinVDMDescription
I_PRAWellCompletionDated view_entity from BASIC Well Completion Variable Data
UPOV_PR_WCVD_PRA view from PRA: Well completion variable data

Fields (20)

KeyField Data ElementDescription DomainTypeLength
KEY mandt MANDT Client
KEY wl_no OIU_WL_NO Well
KEY wc_no OIU_WC_NO Well Completion
KEY eff_from_dt OIU_EFF_FROM_DT Effective From
eff_to_dt OIU_EFF_TO_DT Effective To
hvcls OIB_HVCLS HV class
crud_type_cd OIU_CRUD_TYPE_CD Crude type
op_fl OIU_OPERATOR_FL Operated
contn_fl OIU_CYC_CONTN_FL Cycle Cont.
wl_count OIU_WL_COUNT Well Count
prd_mth_cd OIU_PRD_MTH_CD Prod Method
wl_class_cd OIU_WL_CLASS_CD Well Class
bukrs BUKRS Company Code
cost_center OIUCM_KOSTL Cost Center
operator OIU_OPERATOR Operator
status_cd OIU_WC_STATUS_CD Well Status
pspnr PS_POSNR WBS Element
ext_loss_pc OIU_EXT_LOSS_PC Ext. loss %
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.

-- Well Completion Variable Data
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE OIU_PR_WCVD (
    MANDT,          -- Client [MANDT]
    WL_NO,          -- Well [OIU_WL_NO]
    WC_NO,          -- Well Completion [OIU_WC_NO]
    EFF_FROM_DT,    -- Effective From [OIU_EFF_FROM_DT]
    EFF_TO_DT,      -- Effective To [OIU_EFF_TO_DT]
    HVCLS,          -- HV class [OIB_HVCLS]
    CRUD_TYPE_CD,   -- Crude type [OIU_CRUD_TYPE_CD]
    OP_FL,          -- Operated [OIU_OPERATOR_FL]
    CONTN_FL,       -- Cycle Cont. [OIU_CYC_CONTN_FL]
    WL_COUNT,       -- Well Count [OIU_WL_COUNT]
    PRD_MTH_CD,     -- Prod Method [OIU_PRD_MTH_CD]
    WL_CLASS_CD,    -- Well Class [OIU_WL_CLASS_CD]
    BUKRS,          -- Company Code [BUKRS]
    COST_CENTER,    -- Cost Center [OIUCM_KOSTL]
    OPERATOR,       -- Operator [OIU_OPERATOR]
    STATUS_CD,      -- Well Status [OIU_WC_STATUS_CD]
    PSPNR,          -- WBS Element [PS_POSNR]
    EXT_LOSS_PC,    -- Ext. loss % [OIU_EXT_LOSS_PC]
    OIU_CRUSER,     -- Created By [ERNAM]
    OIU_TIMESTAMP,  -- Time Stamp [TZNTSTMPS]
    PRIMARY KEY (MANDT, WL_NO, WC_NO, EFF_FROM_DT)
);

Learn More