UPOV_PR_DNVD

Derived SQL interpretation, reconstructed from the parsed view metadata (data sources, associations, and field mappings). SAP annotations are omitted and the structure is reformulated as SQL — this is a functional approximation, not the verbatim SAP source.

-- Derived SQL interpretation of CDS view UPOV_PR_DNVD.
-- Reconstructed from parsed metadata (data sources, associations, fields).
-- SAP annotations are omitted and the structure is reformulated as SQL;
-- this is a functional approximation, not the verbatim SAP source. Some join
-- conditions may be unavailable and a few CDS constructs are kept as-is.
-- SQL view name: UPOS_PR_DNVD

CREATE VIEW UPOV_PR_DNVD AS
SELECT
  del_netobj.dn_no AS DN_NO,
  del_netobj.eff_from_dt AS EFF_FROM_DT,
  del_netobj.eff_to_dt AS EFF_TO_DT,
  del_netobj.al_basis_cd AS AL_BASIS_CD,
  del_netobj.al_fl AS AL_FL,
  del_netobj.theo_basis_cd AS THEO_BASIS_CD,
  del_netobj.theo_infl_am AS THEO_INFL_AM,
  del_netobj.cha_compat_cd AS CHA_COMPAT_CD,
  del_netobj.pi_meth_cd AS PI_METH_CD,
  del_netobj.inactive_fl AS INACTIVE_FL,
  del_netobj.chem_meas_grp_id AS CHEM_MEAS_GRP_ID,
  del_netobj.meas_grp_id AS MEAS_GRP_ID,
  del_netobj.ca_prcs_freq_cd AS CA_PRCS_FREQ_CD,
  del_netobj.ca_auto_sel_fl AS CA_AUTO_SEL_FL,
  del_netobj.ca_alloc_meth_cd AS CA_ALLOC_METH_CD,
  del_netobj.ca_alloc_tol_pc AS CA_ALLOC_TOL_PC,
  del_netobj.ca_alloc_bas_cd AS CA_ALLOC_BAS_CD,
  del_netobj.ca_assume_mkr_fl AS CA_ASSUME_MKR_FL,
  del_netobj.ca_assume_acr_fl AS CA_ASSUME_ACR_FL,
  del_netobj.ca_assume_doi_fl AS CA_ASSUME_DOI_FL,
  del_netobj.ca_spf_sbe_fl AS CA_SPF_SBE_FL,
  del_netobj.ca_spf_cpnt_fl AS CA_SPF_CPNT_FL,
  del_netobj.ca_fpf_wgb_cd AS CA_FPF_WGB_CD,
  del_netobj.ca_fpf_sp_rlf_fl AS CA_FPF_SP_RLF_FL,
  del_netobj.vl_prcs_freq_cd AS VL_PRCS_FREQ_CD,
  del_netobj.vl_auto_sel_fl AS VL_AUTO_SEL_FL,
  del_netobj.vl_val_on_val_fl AS VL_VAL_ON_VAL_FL,
  del_netobj.oiu_cruser AS OIU_CRUSER,
  del_netobj.oiu_timestamp AS OIU_TIMESTAMP,
  del_netobj.ca_static_takes AS CA_STATIC_TAKES,
  del_netobj.ca_spf_al_basis AS CA_SPF_AL_BASIS,
  del_netobj.no_wg AS NO_WG,
  del_netobj.enh_inv_alloc_fl as ENH_INV_ALLOC_FL AS DN_NOasDN_NO,
  ' ' AS ENH_INV_ALLOC_FL
FROM UPOV_PR_DNVD_PRA AS del_netobj
LEFT OUTER JOIN UPOV_MIGRATED_DN AS mig_dn ON /* join condition not captured in parsed metadata */
-- UNION with additional select branch(es): UPOV_PR_DNVD_UOM
;