FMLV_MLCR_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_MLCR_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: FMLCRUCT

CREATE VIEW FMLV_MLCR_UCT AS
SELECT
  m.belnr AS belnr,
  m.kjahr AS kjahr,
  m.posnr AS posnr,
  m.bdatj AS bdatj,
  m.poper AS poper,
  curr.curtype AS curtp,
  waers,
  salk3,
  salk3_old,
  salkv,
  salkv_old,
  peinh,
  pvprs_old,
  stprs_old,
  vprsv_old,
  cast( '01' as fins_ml_sdm_version ) AS sdm_version,
  bnbtr,
  exbwr,
  vkwrt,
  vkwra,
  exvkw,
  vksal_old
FROM mlcrld AS m
LEFT OUTER JOIN finsv_unique_cvtyps AS curr ON /* join condition not captured in parsed metadata */
;