ML4H_CDS_MLDOCAHD

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

CREATE VIEW ML4H_CDS_MLDOCAHD AS
SELECT
  ahd.werks AS bwkey,
  doc.docref AS docref,
  doc.curtp AS curtp,
  doc.rldnr AS rldnr,
  doc.kalnr AS kalnr,
  doc.runref AS runref,
  doc.jahrper AS jahrper,
  doc.jahrper_wip AS jahrper_wip,
  doc.current_per AS current_per,
  doc.xabr AS xabr,
  doc.glvor AS glvor,
  doc.vgart AS vgart,
  doc.posart AS posart,
  doc.categ AS categ,
  doc.ptyp AS ptyp,
  doc.bewartgrp AS bewartgrp,
  doc.bvalt AS bvalt,
  doc.process AS process,
  doc.pkalnr AS pkalnr,
  doc.quant AS quant,
  doc.meins AS meins,
  doc.stval AS stval,
  doc.prd AS prd,
  doc.kdm AS kdm,
  doc.tpprd AS tpprd,
  doc.altval AS altval,
  doc.waers AS waers,
  doc.lbkum AS lbkum,
  doc.salk3 AS salk3,
  doc.salkv AS salkv,
  doc.stprs AS stprs,
  doc.pvprs AS pvprs,
  doc.peinh AS peinh,
  doc.xekrel AS xekrel,
  doc.plqty AS plqty,
  doc.markup AS markup,
  doc.vkwrt AS vkwrt,
  doc.vksal AS vksal,
  doc.eqnum AS eqnum,
  doc.timestamp AS timestamp,
  doc.budat AS budat,
  doc.cyclenr AS cyclenr,
  doc.aufnr AS aufnr,
  doc.aufps AS aufps,
  doc.belnr AS belnr,
  doc.kjahr AS kjahr,
  doc.posnr AS posnr_doc,
  doc.awtyp AS awtyp,
  doc.awsys AS wasys,
  doc.aworg AS aworg,
  doc.awref AS awref,
  doc.awitem AS awitem,
  doc.awitgrp AS awitgrp,
  doc.usnam AS usnam,
  doc.tcode AS tcode
FROM ckmllahd AS ahd
LEFT OUTER JOIN mldoc AS doc ON /* join condition not captured in parsed metadata */
;