OIU_PR_WCTST

Transparent Table Application Table
34 Fields 2 CDS Views

Well Test

OIU_PR_WCTST is an SAP database table in S/4HANA. Well Test. It contains 34 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 (34)

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

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]
    PRIMARY KEY (MANDT, WCTST_NO, DOC_YEAR)
);

Learn More