UPOV_MEASDOC_DTL

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

CREATE VIEW UPOV_MEASDOC_DTL AS
SELECT
  std_h.netid AS netid,
  std_h.netobj AS netobj,
  std_h.frequency AS frequency,
  imrg_ext.mdocm AS mdocm,
  imptt.measmnt_grp AS measmnt_grp,
  imptt.mediu AS mediu,
  mpvl.mpvl_no AS mpvl_no,
  mpvl.mpvl_year AS mpvl_year,
  cast(substring(tstmp_to_dats(std_h.prod_timestamp,iflot.gho_pn_tz,$session.client,'NULL'),1,6) as abap.char(6)) AS yr_mnth
INNER JOIN gho_imrg_std_h AS std_h ON /* join condition not captured in parsed metadata */
INNER JOIN gho_iflot_ext AS iflot ON /* join condition not captured in parsed metadata */
INNER JOIN gho_imrg_ext AS imrg_ext ON /* join condition not captured in parsed metadata */
INNER JOIN gho_imptt_ext AS imptt ON /* join condition not captured in parsed metadata */
INNER JOIN upot_int_mpvnqci AS mpvl ON /* join condition not captured in parsed metadata */
;