ML4H_CDS_VMV

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 ML4H_CDS_VMV.
-- 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: ML4H_CDS_VMV_DD
-- Parameters: p_runref : ml4h_runref, p_from_jp : ml4h_jahrper, p_to_jp : ml4h_jahrper, p_runid : ckml_run_id, p_bukrs : bukrs, p_curtp : fins_ext_curtype, p_rldnr : fins_ledger

CREATE VIEW ML4H_CDS_VMV AS
SELECT
  d.curtp AS curtp,
  d.rldnr AS rldnr,
  d.runref AS runref,
  d.kalnr AS kalnr,
  h.matnr AS matnr,
  h.bwtar AS bwtar,
  h.vbeln AS vbeln,
  h.posnr AS posnr,
  h.pspnr AS pspnr,
  h.lifnr AS lifnr,
  la.objnr AS objnr,
  la.werks AS werks,
  left( la.objnr, 2 ) AS objtyp,
  d.posart AS posart,
  d.categ AS categ,
  d.vgart AS VGART,
  d.ptyp AS PTYP,
  rl.xsettle AS xsettle,
  rl.xclose AS xclose,
  h.mlast AS mlast,
  d.xabr AS xabr,
  d.waers AS waers
FROM mldoc AS d
LEFT OUTER JOIN ckmlhd AS h ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN ckmllahd AS la ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN t001w AS w ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN mlrunlist AS rl ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN ckmlrunperiod AS rp ON /* join condition not captured in parsed metadata */
;