OIU_PR_WCTCM

Transparent Table Application Table

PRA: Well Completion Theoretical Calculation Method

OIU_PR_WCTCM is an SAP database table in S/4HANA. PRA: Well Completion Theoretical Calculation Method. It contains 13 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
I_PRAWellCompltnThrtclCalcMeth view_entity from BASIC PRA Well Completion Thrtcl Calc Method

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 freq_cd OIU_FREQ_CD Frequency
KEY majpd_cd OIU_MAJPD_CD Major Product
KEY eff_from_dt OIU_EFF_FROM_DT Effective From
eff_to_dt OIU_EFF_TO_DT Effective To
tcm_cd OIU_TCM_CD Theo Calc Meth
wt_majpd_cd OIU_WT_MAJPD_CD Well Tst Volume
rto_cd OIU_TCM_RTO_CD TCM Ratio Code
tst_qy OIU_TST_QY Test Quantity
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 Theoretical Calculation Method
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE OIU_PR_WCTCM (
    MANDT,          -- Client [MANDT]
    WL_NO,          -- Well [OIU_WL_NO]
    WC_NO,          -- Well Completion [OIU_WC_NO]
    FREQ_CD,        -- Frequency [OIU_FREQ_CD]
    MAJPD_CD,       -- Major Product [OIU_MAJPD_CD]
    EFF_FROM_DT,    -- Effective From [OIU_EFF_FROM_DT]
    EFF_TO_DT,      -- Effective To [OIU_EFF_TO_DT]
    TCM_CD,         -- Theo Calc Meth [OIU_TCM_CD]
    WT_MAJPD_CD,    -- Well Tst Volume [OIU_WT_MAJPD_CD]
    RTO_CD,         -- TCM Ratio Code [OIU_TCM_RTO_CD]
    TST_QY,         -- Test Quantity [OIU_TST_QY]
    OIU_CRUSER,     -- Created By [ERNAM]
    OIU_TIMESTAMP,  -- Time Stamp [TZNTSTMPS]
    PRIMARY KEY (MANDT, WL_NO, WC_NO, FREQ_CD, MAJPD_CD, EFF_FROM_DT)
);