Fcml_Rep_AB_EB_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_AB_EB_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_AB_EB_V

CREATE VIEW Fcml_Rep_AB_EB_Ddl AS
SELECT
  _mlextr.kalnr_mat AS kalnr_mat,
  cast ( substring(periods.jahrper, 5, 3) as poper) AS poper,
  cast ( substring(periods.jahrper, 1, 4) as bdatj) AS BDATJ,
  cast ( ' ' as ckml_run_type preserving type ) AS RUN_ACT,
  cast ( ' ' as ckml_run_appl preserving type ) AS RUN_APPL,
  cast ( 'AB' as ckml_categ preserving type ) AS CATEG,
  cast ( ' ' as ck_ptyp_bvalt preserving type ) AS PTYP,
  cast ( ' ' as ck_psart preserving type ) AS PSART,
  cast ( '000000000000' as ck_kalnr preserving type ) AS KALNR_PMAT,
  cast ( '000000000000' as ckml_alprocnr preserving type ) AS bvalt,
  cast ( '000000000000' as ckml_f_procnr preserving type ) AS process,
  _mlextr.curtp AS curtp,
  _mlextr.rldnr AS rldnr,
  sum (_mlextr.lbkum) AS lbkum,
  _mlextr.meins AS meins,
  sum (_mlextr.salk3) AS salk3,
  cast ( 0 as ckml_estprd ) AS estprd,
  cast ( 0 as ckml_estkdm ) AS estkdm,
  cast ( 0 as ckml_mstprd ) AS mstprd,
  cast ( 0 as ckml_mstkdm ) AS mstkdm,
  _mlextr.waers AS waers
FROM fcml_act_perds_v AS periods
LEFT OUTER JOIN FCMLDOC_EX_MAT_DDL AS _mlextr ON /* condition not available in parsed metadata */  -- association [1..*]
-- UNION ALL with additional select branch(es): fcml_act_perds_v
;