OIU_PR_WCTST

Transparent Table Application Table
36 Fields 2 CDS Views

Well Test

OIU_PR_WCTST is an SAP database table in S/4HANA. Well Test. It contains 36 fields. 2 CDS views read from this table.

CDS Views using this table (2)

ViewTypeJoinVDMDescription
I_PRAWellTestHdr view from BASIC PRA Well Test Header
UPOV_PR_WCTST_PRA view from Well Test PRA

Fields (36)

KeyField Data ElementDescription DomainTypeLength
KEY mandt MANDT Client
KEY wctst_no OIU_WCTST_NO Well Test No
KEY doc_year OIU_DOC_YEAR Document year
wl_no OIU_WL_NO Well
wc_no OIU_WC_NO Well Completion
test_dt OIU_TEST_DT Test date
strm_type_cd OIU_STRM_TYPE_CD Multi strm type
tst_type_cd OIU_TST_TYPE_CD Test type
al_fl OIU_AL_IND_CD Allocated
oc_u OIU_OC_U Oil Cond. Unit
oc OIU_OC Oil Condensate
water_u OIU_WATER_U Water Unit
water OIU_WATER Water Quantity
dur_hrs OIU_DUR_HRS Duration hours
dur_min OIU_DUR_MIN Duration Min.
heat_val_u OIU_HEAT_VAL_U HV Unit
heat_val OIU_HEAT_VAL Heat.val.factor
glg_u OIU_GLG_U GLG Unit
glg OIU_GLG Gas Lift Gas
gas_u OIU_GAS_U Gas Unit
gas OIU_GAS Gas
net_gas_u OIU_NET_GAS_U Net Gas Ut
net_gas OIU_NET_GAS Net Gas
n2_pc OIU_N2PC N2 Percent
co2_pc OIU_CO2PC CO2 PC
cho_sz OIU_CHO_SZ Choke size
cho_sz_u OIU_CHO_SZ_U Choke unit
flo_ps_u OIU_FLO_PS_U Flow PS unit
flo_ps OIU_FLO_PS Flow PS
tmp_u OIU_TMP_U Temp unit
tmp OIU_TMP Temp.
base_density_u OIU_OIB_BDNEH Unit
base_density OIU_OIB_BDICH Base density
dentyp OIU_OIB_DNTYP Dens. Type
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 Test
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE OIU_PR_WCTST (
    MANDT,           -- Client [MANDT]
    WCTST_NO,        -- Well Test No [OIU_WCTST_NO]
    DOC_YEAR,        -- Document year [OIU_DOC_YEAR]
    WL_NO,           -- Well [OIU_WL_NO]
    WC_NO,           -- Well Completion [OIU_WC_NO]
    TEST_DT,         -- Test date [OIU_TEST_DT]
    STRM_TYPE_CD,    -- Multi strm type [OIU_STRM_TYPE_CD]
    TST_TYPE_CD,     -- Test type [OIU_TST_TYPE_CD]
    AL_FL,           -- Allocated [OIU_AL_IND_CD]
    OC_U,            -- Oil Cond. Unit [OIU_OC_U]
    OC,              -- Oil Condensate [OIU_OC]
    WATER_U,         -- Water Unit [OIU_WATER_U]
    WATER,           -- Water Quantity [OIU_WATER]
    DUR_HRS,         -- Duration hours [OIU_DUR_HRS]
    DUR_MIN,         -- Duration Min. [OIU_DUR_MIN]
    HEAT_VAL_U,      -- HV Unit [OIU_HEAT_VAL_U]
    HEAT_VAL,        -- Heat.val.factor [OIU_HEAT_VAL]
    GLG_U,           -- GLG Unit [OIU_GLG_U]
    GLG,             -- Gas Lift Gas [OIU_GLG]
    GAS_U,           -- Gas Unit [OIU_GAS_U]
    GAS,             -- Gas [OIU_GAS]
    NET_GAS_U,       -- Net Gas Ut [OIU_NET_GAS_U]
    NET_GAS,         -- Net Gas [OIU_NET_GAS]
    N2_PC,           -- N2 Percent [OIU_N2PC]
    CO2_PC,          -- CO2 PC [OIU_CO2PC]
    CHO_SZ,          -- Choke size [OIU_CHO_SZ]
    CHO_SZ_U,        -- Choke unit [OIU_CHO_SZ_U]
    FLO_PS_U,        -- Flow PS unit [OIU_FLO_PS_U]
    FLO_PS,          -- Flow PS [OIU_FLO_PS]
    TMP_U,           -- Temp unit [OIU_TMP_U]
    TMP,             -- Temp. [OIU_TMP]
    BASE_DENSITY_U,  -- Unit [OIU_OIB_BDNEH]
    BASE_DENSITY,    -- Base density [OIU_OIB_BDICH]
    DENTYP,          -- Dens. Type [OIU_OIB_DNTYP]
    OIU_CRUSER,      -- Created By [ERNAM]
    OIU_TIMESTAMP,   -- Time Stamp [TZNTSTMPS]
    PRIMARY KEY (MANDT, WCTST_NO, DOC_YEAR)
);

Learn More