FMLV_PRDH_UCT

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 FMLV_PRDH_UCT.
-- 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: FMLPRDHUCT

CREATE VIEW FMLV_PRDH_UCT AS
SELECT
  H.mlvnr AS mlvnr,
  M.VGABE AS VGABE,
  M.GJAHR AS GJAHR,
  M.BELNR AS BELNR,
  M.BUZEI AS BUZEI,
  M.KALNR AS KALNR,
  M.CURTP AS CURTP,
  H.aufnr AS aufnr,
  H.posnr AS posnr,
  H.logsys AS logsys,
  H.initpoper AS initpoper,
  H.initbdatj AS initbdatj,
  H.init_done AS init_done,
  M.budat AS budat,
  M.menge AS menge,
  M.poper AS poper,
  M.bdatj AS bdatj,
  M.hrkft AS hrkft,
  M.kstar AS kstar,
  M.bwart AS bwart,
  M.aufnr AS MLAUF_AUFNR,
  M.posnr AS MLAUF_POSNR,
  M.settle_poper AS settle_poper,
  M.saprl AS saprl,
  M.cpudt AS MLAUF_CPUDT,
  M.cputm AS MLAUF_CPUTM,
  M.xwoff AS xwoff,
  M.werks AS werks,
  M.storno AS MLAUF_STORNO,
  M.meins AS meins,
  M.bstmg AS bstmg,
  M.bstme AS bstme,
  M.waers AS MLAUFCR_WAERS,
  M.shkzg AS shkzg,
  M.wrbtr AS wrbtr,
  M.arewr AS arewr,
  M.reewr AS reewr
FROM mlorderhist AS H
INNER JOIN FMLV_MLAUFMFCR_UCT_UNION AS M ON /* join condition not captured in parsed metadata */
;