FCML_MAT_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 FCML_MAT_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: FCML_MAT_V

CREATE VIEW FCML_MAT_DDL AS
SELECT
  hd.kalnr AS kalnr,
  cast ('00000000' as vszhl preserving type) AS vszhl,
  cast ('MA' as j_obart preserving type) AS obart,
  hd.matnr AS matnr,
  hd.bwkey AS bwkey,
  t001w.werks AS werks,
  hd.sobkz AS sobkz,
  hd.vbeln AS vbeln,
  hd.posnr AS posnr,
  hd.lifnr AS lifnr,
  hd.bwtar AS bwtar,
  hd.pspnr AS pspnr,
  mbew.bklas AS bklas,
  hd.mlast AS mlast,
  mbew.hrkft AS hrkft,
  t001k.bukrs AS bukrs,
  tka02.kokrs AS kokrs,
  cast (' ' as kostl preserving type) AS kostl,
  cast (' ' as lstar preserving type) AS lstar,
  cast (' ' as co_prznr preserving type) AS prznr,
  marc.prctr AS prctr,
  mara.mtart AS mtart,
  mara.mbrsh AS mbrsh,
  mara.matkl AS matkl,
  mara.meins AS meins,
  mara.spart AS spart,
  mara.prdha AS prdha,
  mara.attyp AS attyp,
  mara.laeda AS laeda,
  t001.periv AS periv
FROM ckmlhd AS hd
INNER JOIN mara ON /* join condition not captured in parsed metadata */
INNER JOIN t001k ON /* join condition not captured in parsed metadata */
INNER JOIN t001 ON /* join condition not captured in parsed metadata */
INNER JOIN t001w ON /* join condition not captured in parsed metadata */
INNER JOIN tka02 ON /* join condition not captured in parsed metadata */
INNER JOIN v_mbew_md AS mbew ON /* join condition not captured in parsed metadata */
INNER JOIN v_marc_md AS marc ON /* join condition not captured in parsed metadata */
INNER JOIN v_ebew_md AS ebew ON /* join condition not captured in parsed metadata */
INNER JOIN v_qbew_md AS qbew ON /* join condition not captured in parsed metadata */
INNER JOIN v_obew_md AS obew ON /* join condition not captured in parsed metadata */
-- UNION ALL with additional select branch(es): ckmlhd, ckmllahd
;