UPOV_PR_WCTST_PRA
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)
| View | Type | Join | VDM | Description |
|---|---|---|---|---|
| UPOV_MIGRATED_MEDOC | view | union | Migrated MEDOC records | |
| UPOV_PR_WCTST | view | from | Well Test |
Fields (34)
| Key | Field | CDS Fields | Used 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)
);
Learn More
- Understanding Data Lineage in SAP S/4HANA
- SAP Tables vs CDS Views — Key Differences
- Understanding the SAP S/4HANA Data Model
- BSEG to ACDOCA: The Universal Journal Migration
- Business Partner Migration: KNA1/LFA1 to BUT000
- Material Document Migration: MSEG/MKPF to MATDOC
- How to Find the Right CDS View for an SAP Table
- Sales Document Status Migration: VBUP/VBUK Removal in S/4HANA
- CO Tables in S/4HANA: COEP, COBK, COSS, COSP to ACDOCA