UPOV_PR_DNVD_PRA
Delivery Network Variable Data_PRA
UPOV_PR_DNVD_PRA is a CDS View in S/4HANA. Delivery Network Variable Data_PRA. It contains 32 fields. 1 CDS views read from this table.
CDS Views using this table (1)
| View | Type | Join | VDM | Description |
|---|---|---|---|---|
| UPOV_PR_DNVD | view | from | Delivery Network Variable Data |
Fields (32)
| Key | Field | CDS Fields | Used in Views |
|---|---|---|---|
| KEY | dn_no | DN_NO | 1 |
| KEY | eff_from_dt | EFF_FROM_DT | 1 |
| al_basis_cd | AL_BASIS_CD | 1 | |
| al_fl | AL_FL | 1 | |
| ca_alloc_bas_cd | CA_ALLOC_BAS_CD | 1 | |
| ca_alloc_meth_cd | CA_ALLOC_METH_CD | 1 | |
| ca_alloc_tol_pc | CA_ALLOC_TOL_PC | 1 | |
| ca_assume_acr_fl | CA_ASSUME_ACR_FL | 1 | |
| ca_assume_doi_fl | CA_ASSUME_DOI_FL | 1 | |
| ca_assume_mkr_fl | CA_ASSUME_MKR_FL | 1 | |
| ca_auto_sel_fl | CA_AUTO_SEL_FL | 1 | |
| ca_fpf_sp_rlf_fl | CA_FPF_SP_RLF_FL | 1 | |
| ca_fpf_wgb_cd | CA_FPF_WGB_CD | 1 | |
| ca_prcs_freq_cd | CA_PRCS_FREQ_CD | 1 | |
| ca_spf_al_basis | CA_SPF_AL_BASIS | 1 | |
| ca_spf_cpnt_fl | CA_SPF_CPNT_FL | 1 | |
| ca_spf_sbe_fl | CA_SPF_SBE_FL | 1 | |
| ca_static_takes | CA_STATIC_TAKES | 1 | |
| cha_compat_cd | CHA_COMPAT_CD | 1 | |
| chem_meas_grp_id | CHEM_MEAS_GRP_ID | 1 | |
| eff_to_dt | EFF_TO_DT | 1 | |
| inactive_fl | INACTIVE_FL | 1 | |
| meas_grp_id | MEAS_GRP_ID | 1 | |
| no_wg | NO_WG | 1 | |
| oiu_cruser | OIU_CRUSER | 1 | |
| oiu_timestamp | OIU_TIMESTAMP | 1 | |
| pi_meth_cd | PI_METH_CD | 1 | |
| theo_basis_cd | THEO_BASIS_CD | 1 | |
| theo_infl_am | THEO_INFL_AM | 1 | |
| vl_auto_sel_fl | VL_AUTO_SEL_FL | 1 | |
| vl_prcs_freq_cd | VL_PRCS_FREQ_CD | 1 | |
| vl_val_on_val_fl | VL_VAL_ON_VAL_FL | 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.
-- Delivery Network Variable Data_PRA
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE UPOV_PR_DNVD_PRA (
DN_NO,
EFF_FROM_DT,
AL_BASIS_CD,
AL_FL,
CA_ALLOC_BAS_CD,
CA_ALLOC_METH_CD,
CA_ALLOC_TOL_PC,
CA_ASSUME_ACR_FL,
CA_ASSUME_DOI_FL,
CA_ASSUME_MKR_FL,
CA_AUTO_SEL_FL,
CA_FPF_SP_RLF_FL,
CA_FPF_WGB_CD,
CA_PRCS_FREQ_CD,
CA_SPF_AL_BASIS,
CA_SPF_CPNT_FL,
CA_SPF_SBE_FL,
CA_STATIC_TAKES,
CHA_COMPAT_CD,
CHEM_MEAS_GRP_ID,
EFF_TO_DT,
INACTIVE_FL,
MEAS_GRP_ID,
NO_WG,
OIU_CRUSER,
OIU_TIMESTAMP,
PI_METH_CD,
THEO_BASIS_CD,
THEO_INFL_AM,
VL_AUTO_SEL_FL,
VL_PRCS_FREQ_CD,
VL_VAL_ON_VAL_FL,
PRIMARY KEY (DN_NO, EFF_FROM_DT)
);
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