UPOV_PR_MP

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_MP.
-- 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: UPO_PR_MP

CREATE VIEW UPOV_PR_MP AS
SELECT
  nonmig_mp_tb.mp_no AS MP_NO,
  nonmig_mp_tb.mp_de AS MP_DE,
  nonmig_mp_tb.shtxt AS SHTXT,
  nonmig_mp_tb.type_cd AS TYPE_CD,
  nonmig_mp_tb.uom_grp AS UOM_GRP,
  nonmig_mp_tb.mtr_cl_cd AS MTR_CL_CD,
  nonmig_mp_tb.cntry_cd AS CNTRY_CD,
  nonmig_mp_tb.pri_geo_loc AS PRI_GEO_LOC,
  nonmig_mp_tb.sec_geo_loc AS SEC_GEO_LOC,
  nonmig_mp_tb.lat_no AS LAT_NO,
  nonmig_mp_tb.lat_dir_cd AS LAT_DIR_CD,
  nonmig_mp_tb.lng_no AS LNG_NO,
  nonmig_mp_tb.lng_dir_cd AS LNG_DIR_CD,
  nonmig_mp_tb.mp_grp AS MP_GRP,
  nonmig_mp_tb.mp_set AS MP_SET,
  nonmig_mp_tb.docnr AS DOCNR,
  nonmig_mp_tb.docyr AS DOCYR,
  nonmig_mp_tb.oiu_cruser AS OIU_CRUSER,
  nonmig_mp_tb.oiu_timestamp as OIU_TIMESTAMP AS MP_NOasMP_NO,
  functloc.OIU_TIMESTAMP AS OIU_TIMESTAMP
FROM UPOV_PR_MP_PRA AS nonmig_mp_tb
LEFT OUTER JOIN UPOV_MIGRATED_MP AS migMP ON /* join condition not captured in parsed metadata */
-- UNION with additional select branch(es): UPOV_PR_MP_UOM
;