OIU_PR_WCDT

Transparent Table Application Table
12 Fields 2 CDS Views

PRA: Well Completion Downtime

OIU_PR_WCDT is an SAP database table in S/4HANA. PRA: Well Completion Downtime. It contains 12 fields. 2 CDS views read from this table.

CDS Views using this table (2)

ViewTypeJoinVDMDescription
I_PRAWellCompltnDwnHdr view from BASIC PRA WCDwnTme Hdr IVew
UPOV_PR_WCDT_PRA view from Well Completion Downtime PRA Data

Fields (12)

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
KEY strm_type_cd OIU_STRM_TYPE_CD Multi strm type
eff_to_ts OIU_EFF_TO_TS Eff. to TS
wcdt_no OIU_WCDT_NO WC downtime no
cond_cd OIU_COND_CD Condtion Code
hour_fl OIU_HOUR_FL Hour flag
hrs OIU_HRS Hours
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.

-- PRA: Well Completion Downtime
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE OIU_PR_WCDT (
    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]
    STRM_TYPE_CD,   -- Multi strm type [OIU_STRM_TYPE_CD]
    EFF_TO_TS,      -- Eff. to TS [OIU_EFF_TO_TS]
    WCDT_NO,        -- WC downtime no [OIU_WCDT_NO]
    COND_CD,        -- Condtion Code [OIU_COND_CD]
    HOUR_FL,        -- Hour flag [OIU_HOUR_FL]
    HRS,            -- Hours [OIU_HRS]
    OIU_CRUSER,     -- Created By [ERNAM]
    OIU_TIMESTAMP,  -- Time Stamp [TZNTSTMPS]
    PRIMARY KEY (MANDT, WL_NO, WC_NO, EFF_FROM_TS, STRM_TYPE_CD)
);

Learn More