UPOV_PR_MPVD

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

CREATE VIEW UPOV_PR_MPVD AS
SELECT
  nonmig_mpvd.mp_no AS MP_NO,
  nonmig_mpvd.eff_from_dt AS EFF_FROM_DT,
  nonmig_mpvd.eff_to_dt AS EFF_TO_DT,
  nonmig_mpvd.hvcls AS HVCLS,
  nonmig_mpvd.crud_type_cd AS CRUD_TYPE_CD,
  nonmig_mpvd.sa_pt_fl AS SA_PT_FL,
  nonmig_mpvd.inactive_fl AS INACTIVE_FL,
  nonmig_mpvd.op_fl AS OP_FL,
  nonmig_mpvd.sat_dry_cd AS SAT_DRY_CD,
  nonmig_mpvd.intra_nwk_fl AS INTRA_NWK_FL,
  nonmig_mpvd.plt_inlet_fl AS PLT_INLET_FL,
  nonmig_mpvd.strm_type_cd AS STRM_TYPE_CD,
  nonmig_mpvd.strm_dflt_fl AS STRM_DFLT_FL,
  nonmig_mpvd.rlf_usage_fl AS RLF_USAGE_FL,
  nonmig_mpvd.company_code AS COMPANY_CODE,
  nonmig_mpvd.cost_center AS COST_CENTER,
  nonmig_mpvd.chrt_typ_cd AS CHRT_TYP_CD,
  nonmig_mpvd.oiu_cruser AS OIU_CRUSER,
  nonmig_mpvd.oiu_timestamp AS OIU_TIMESTAMP,
  nonmig_mpvd.pipl_open_pd as PIPL_OPEN_PD AS MP_NOasMP_NO,
  net_obj_vdata.PIPL_OPEN_PD AS PIPL_OPEN_PD
FROM UPOV_PR_MPVD_PRA AS nonmig_mpvd
LEFT OUTER JOIN UPOV_MIGRATED_MP AS migMP ON /* join condition not captured in parsed metadata */
-- UNION with additional select branch(es): UPOV_PR_MPVD_UOM
;