UPOV_ME_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_ME_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_ME_MEDOC

CREATE VIEW UPOV_ME_MEDOC AS
SELECT
  nonMigrated.docnr AS docnr,
  nonMigrated.docyr AS docyr,
  nonMigrated.mecls AS mecls,
  nonMigrated.metyp AS metyp,
  nonMigrated.objnr AS objnr,
  nonMigrated.mesrc AS mesrc,
  nonMigrated.srcky AS srcky,
  nonMigrated.src_docnr AS src_docnr,
  nonMigrated.src_docyr AS src_docyr,
  nonMigrated.uomgr AS uomgr,
  nonMigrated.umrsl AS umrsl,
  nonMigrated.meayr AS meayr,
  nonMigrated.meapd AS meapd,
  nonMigrated.meats AS meats,
  nonMigrated.xchng AS xchng,
  nonMigrated.xdelt AS xdelt,
  nonMigrated.oiu_cruser AS oiu_cruser,
  uomCreated.OIU_TIMESTAMP AS OIU_TIMESTAMP
FROM UPOV_ME_MEDOC_PRA AS nonMigrated
LEFT OUTER JOIN UPOV_MIGRATED_MEDOC AS Migrated ON /* join condition not captured in parsed metadata */
-- UNION with additional select branch(es): UPOV_ME_MEDOC_UOM
;