UPOV_PR_DNVD_PRA

CDS View

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)

ViewTypeJoinVDMDescription
UPOV_PR_DNVD view from Delivery Network Variable Data

Fields (32)

KeyField CDS FieldsUsed 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)
);