UPOV_PR_SET

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_SET.
-- 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_SET

CREATE VIEW UPOV_PR_SET AS
SELECT
  ppn_non_mig.SET_UUID AS SET_UUID,
  ppn_non_mig.SET_AREA AS SET_AREA,
  ppn_non_mig.DN_NO AS DN_NO,
  ppn_non_mig.PRCS_DT AS PRCS_DT,
  ppn_non_mig.FREQ_CD AS FREQ_CD,
  ppn_non_mig.MAJPD_CD AS MAJPD_CD,
  ppn_non_mig.BUKRS AS BUKRS,
  ppn_non_mig.VNAME AS VNAME,
  ppn_non_mig.DOI_NO AS DOI_NO,
  ppn_non_mig.CT_NO AS CT_NO,
  ppn_non_mig.WL_NO AS WL_NO,
  ppn_non_mig.WC_NO AS WC_NO,
  ppn_non_mig.MP_NO AS MP_NO,
  ppn_non_mig.HAS_LTXT AS HAS_LTXT,
  ppn_non_mig.VCR_DEL_FL AS VCR_DEL_FL,
  ppn_non_mig.VL_DOC_NO AS VL_DOC_NO,
  ppn_non_mig.VL_DOC_YEAR AS VL_DOC_YEAR,
  ppn_non_mig.XREF_VERSION AS XREF_VERSION,
  ppn_non_mig.STATUS AS STATUS,
  ppn_non_mig.COMMENTS AS COMMENTS,
  ppn_non_mig.ACTION_DT AS ACTION_DT,
  ppn_non_mig.HL_PPA_RSN_CD AS HL_PPA_RSN_CD,
  ppn_non_mig.CREATED_ON AS CREATED_ON,
  ppn_non_mig.UPDATED_ON AS UPDATED_ON,
  ppn_non_mig.CREATED_BY AS CREATED_BY,
  ppn_non_mig.UPDATED_BY as UPDATED_BY AS SET_UUIDasSET_UUID,
  UPDATED_BY
FROM UPOV_PPN_SET_PRA AS ppn_non_mig
INNER JOIN UPOV_TRIM_DN_PRA AS TrimDNumber ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN UPOV_TRIM_FUNCLABEL_UOM AS funcloclabeltrim ON /* join condition not captured in parsed metadata */
-- UNION with additional select branch(es): UPOV_PPN_SET_PRA_CAVL, UPOV_PPN_SET_MP
;