Fcml_Rep_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_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_V

CREATE VIEW Fcml_Rep_Ddl AS
SELECT
  cast( doc.kalnr as ck_kalnr preserving type ) AS kalnr_mat,
  cast( substring(doc.jahrper, 5, 3) as poper) AS poper,
  cast( substring(doc.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( 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( doc.jahrper as jahrper) AS jahrper,
  cast ( doc.meins as meins preserving type ) AS meins,
  cast ( 0 as ckml_mstprd ) AS mstprd,
  cast ( 0 as ckml_mstkdm ) AS mstkdm,
  cast ( lbkum as ck_lbkum ) AS lbkum,
  salk3,
  estprd,
  estkdm,
  waers
FROM mldoc AS doc
-- UNION ALL with additional select branch(es): fcml_rep_ab_eb_v
;