UPOV_PR_WCTST_PRA

CDS View

Well Test PRA

UPOV_PR_WCTST_PRA is a CDS View in S/4HANA. Well Test PRA. It contains 34 fields. 2 CDS views read from this table.

CDS Views using this table (2)

ViewTypeJoinVDMDescription
UPOV_MIGRATED_MEDOC view union Migrated MEDOC records
UPOV_PR_WCTST view from Well Test

Fields (34)

KeyField CDS FieldsUsed in Views
KEY doc_year doc_year 1
KEY wctst_no wctst_no 1
al_fl al_fl 1
base_density base_density 1
base_density_u base_density_u 1
cho_sz cho_sz 1
cho_sz_u cho_sz_u 1
co2_pc co2_pc 1
dentyp dentyp 1
dur_hrs dur_hrs 1
dur_min dur_min 1
flo_ps flo_ps 1
flo_ps_u flo_ps_u 1
gas gas 1
gas_u gas_u 1
glg glg 1
glg_u glg_u 1
heat_val heat_val 1
heat_val_u heat_val_u 1
n2_pc n2_pc 1
net_gas net_gas 1
net_gas_u net_gas_u 1
oc oc 1
oc_u oc_u 1
oiu_cruser oiu_cruser 1
strm_type_cd strm_type_cd 1
test_dt test_dt 1
tmp tmp 1
tmp_u tmp_u 1
tst_type_cd tst_type_cd 1
water water 1
water_u water_u 1
wc_no wc_no 1
wl_no wl_no 1

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 PRA
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE UPOV_PR_WCTST_PRA (
    DOC_YEAR,
    WCTST_NO,
    AL_FL,
    BASE_DENSITY,
    BASE_DENSITY_U,
    CHO_SZ,
    CHO_SZ_U,
    CO2_PC,
    DENTYP,
    DUR_HRS,
    DUR_MIN,
    FLO_PS,
    FLO_PS_U,
    GAS,
    GAS_U,
    GLG,
    GLG_U,
    HEAT_VAL,
    HEAT_VAL_U,
    N2_PC,
    NET_GAS,
    NET_GAS_U,
    OC,
    OC_U,
    OIU_CRUSER,
    STRM_TYPE_CD,
    TEST_DT,
    TMP,
    TMP_U,
    TST_TYPE_CD,
    WATER,
    WATER_U,
    WC_NO,
    WL_NO,
    PRIMARY KEY (DOC_YEAR, WCTST_NO)
);