UPOV_MIGRATED_MEDOC

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_MIGRATED_MEDOC.
-- 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_MIG_MEDOC

CREATE VIEW UPOV_MIGRATED_MEDOC AS
SELECT
  migrated_data.mpvl_no AS src_docnr,
  migrated_data.mpvl_year as src_docyr AS test_dt,
  'UTC' AS UTC,
  $session.client AS client,
  migrated_data.doc_year as src_docyr AS eff_from_ts,
  migrated_data.doc_year AS src_docyr
FROM UPOV_PR_MPVL_PRA AS migrated_data
INNER JOIN UPOV_ME_MEDOC_PRA AS medoc ON /* join condition not captured in parsed metadata */
INNER JOIN UPOV_MIGRATED_MP AS migrated_mp ON /* join condition not captured in parsed metadata */
INNER JOIN UPOV_MIGRATED_WC AS migrated_wc ON /* join condition not captured in parsed metadata */
-- UNION with additional select branch(es): UPOV_PR_WCTST_PRA, UPOV_PRA_WCDPS
;