V_ML_ACDOC_EX_UL_DDL

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 V_ML_ACDOC_EX_UL_DDL.
-- 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: V_ML_ACDOC_EX_UL

CREATE VIEW V_ML_ACDOC_EX_UL_DDL AS
SELECT
  acdoca_m_extract.rclnt AS rclnt,
  acdoca_m_extract.rldnr AS rldnr,
  acdoca_m_extract.rbukrs AS rbukrs,
  acdoca_m_extract.kalnr AS kalnr,
  acdoca_m_extract.matnr AS matnr,
  acdoca_m_extract.bwkey AS bwkey,
  acdoca_m_extract.bwtar AS bwtar,
  acdoca_m_extract.ml_sobkz AS ml_sobkz,
  acdoca_m_extract.ml_kdauf AS ml_kdauf,
  acdoca_m_extract.ml_kdpos AS ml_kdpos,
  acdoca_m_extract.ml_lifnr AS ml_lifnr,
  acdoca_m_extract.ml_pspnr AS ml_pspnr,
  sum(acdoca_m_extract.vmsl) AS vmsl,
  sum(acdoca_m_extract.hsl) AS hsl,
  sum(acdoca_m_extract.hvkwrt) AS hvkwrt
FROM acdoca_m_extract
INNER JOIN fmlv_logistic_currency AS mapp ON /* join condition not captured in parsed metadata */
;