OIUPR_WCDPS

Transparent Table Application Table
13 Fields 2 CDS Views

Well Completion Daily Pressures

OIUPR_WCDPS is an SAP database table in S/4HANA. Well Completion Daily Pressures. It contains 13 fields. 2 CDS views read from this table.

CDS Views using this table (2)

ViewTypeJoinVDMDescription
I_PRAWellCompltnPrssrHdr view from BASIC Well Completion Daily Pressure Header
UPOV_PRA_WCDPS view from Well Completion Daily Pressures (PRA)

Fields (13)

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_ts OIU_EFF_FROM_TS Eff. from TS
eff_to_ts OIU_EFF_TO_TS Eff. to TS
cho_sz OIU_CHO_SZ Choke size
cho_sz_u OIU_CHO_SZ_U Choke unit
tub_ps OIU_TUB_PS Tubing pres.
tub_ps_u OIU_TUB_PS_U Tubing Pres Unt
wcdps_no OIUPR_WCDPS_NO Wcdps no
doc_year OIU_DOC_YEAR Document 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.

-- Well Completion Daily Pressures
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE OIUPR_WCDPS (
    MANDT,          -- Client [MANDT]
    WL_NO,          -- Well [OIU_WL_NO]
    WC_NO,          -- Well Completion [OIU_WC_NO]
    EFF_FROM_TS,    -- Eff. from TS [OIU_EFF_FROM_TS]
    EFF_TO_TS,      -- Eff. to TS [OIU_EFF_TO_TS]
    CHO_SZ,         -- Choke size [OIU_CHO_SZ]
    CHO_SZ_U,       -- Choke unit [OIU_CHO_SZ_U]
    TUB_PS,         -- Tubing pres. [OIU_TUB_PS]
    TUB_PS_U,       -- Tubing Pres Unt [OIU_TUB_PS_U]
    WCDPS_NO,       -- Wcdps no [OIUPR_WCDPS_NO]
    DOC_YEAR,       -- Document year [OIU_DOC_YEAR]
    OIU_CRUSER,     -- Created By [ERNAM]
    OIU_TIMESTAMP,  -- Time Stamp [TZNTSTMPS]
    PRIMARY KEY (MANDT, WL_NO, WC_NO, EFF_FROM_TS)
);

Learn More