FCML_REP_AVR_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_REP_AVR_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_REP_AVR_V

CREATE VIEW FCML_REP_AVR_DDL AS
SELECT
  cast ( doc.kalnr as ck_kalnr preserving type ) AS kalnr_mat,
  cast ( rperiod.poper as poper preserving type ) AS poper,
  cast ( rperiod.bdatj as bdatj preserving type ) AS BDATJ,
  cast ( rperiod.run_act as ckml_run_type preserving type ) AS RUN_ACT,
  cast ( rperiod.run_appl as ckml_run_appl preserving type ) AS RUN_APPL,
  cast ( doc.categ as ckml_categ preserving type ) AS CATEG,
  cast ( doc.ptyp as ck_ptyp_bvalt preserving type ) AS PTYP,
  cast ( doc.posart as ck_psart preserving type ) AS PSART,
  cast ( doc.pkalnr as ck_kalnr preserving type ) AS KALNR_PMAT,
  cast ( doc.bvalt as ckml_alprocnr preserving type ) AS bvalt,
  cast ( doc.process as ckml_f_procnr preserving type ) AS process,
  doc.curtp AS curtp,
  doc.rldnr AS rldnr,
  cast ( sum (doc.quant) as ck_lbkum ) AS lbkum,
  cast ( doc.meins as meins ) AS meins,
  cast ( 0 as ckml_mstprd ) AS mstprd,
  cast ( 0 as ckml_mstkdm ) AS mstkdm,
  cast ( sum(doc.stval) as ck_salk3_1 ) AS salk3,
  cast ( sum (doc.prd) as ckml_estprd ) AS estprd,
  cast ( sum (doc.kdm) as ckml_estkdm ) AS estkdm,
  doc.waers AS from_jahrper,
  5,
  1,
  rep.waers AS jahrper,
  doc.waers AS waers
FROM mldoc AS doc
INNER JOIN mlrunlist AS mlrun ON /* join condition not captured in parsed metadata */
INNER JOIN fcml_runperavr_v AS rperiod ON /* join condition not captured in parsed metadata */
-- UNION ALL with additional select branch(es): fcml_rep_v, mldoc
;