FCML_CCS_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_CCS_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_CCS_REP_V
-- Parameters: p_sys_langu : syst_langu

CREATE VIEW FCML_CCS_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,
  cast ( ccs.elesmhk as ck_elesmhk preserving type ) AS elesmhk,
  cast ( ccs.element as ck_element preserving type ) AS element,
  cast ( ccs.svrel as ml4h_svrel preserving type ) AS svrel,
  cast ( ccs.mlcct as ml4h_mlcct preserving type ) AS mlcct,
  cast ( ccs.keart as keart preserving type ) AS keart,
  doc.curtp AS curtp,
  doc.rldnr AS rldnr,
  cast( doc.jahrper as jahrper) AS jahrper,
  cast ( t3.egrup as ck_el_grup preserving type ) AS egrup,
  case doc.categ when 'EB' then 0 - cast ( sum (ccs.fix) as fcml_ccsvalf ) else cast ( sum (ccs.fix) as fcml_ccsvalf ) end as PRCDIF_FIX AS fixasfcml_ccsvalfendasPRCDIF_FIX,
  case doc.categ when 'EB' then cast (sum ( ccs.fix) as fcml_ccsvalv ) - cast ( sum ( ccs.tot) as fcml_ccsvalv ) else cast ( sum ( ccs.tot) as fcml_ccsvalv ) - cast (sum ( ccs.fix) as fcml_ccsvalv ) end as PRCDIF_VAR AS fixasfcml_ccsvalvendasPRCDIF_VAR,
  doc.waers AS waers,
  cast ( t1.txele as fcml_eletxt preserving type ) AS ELETXT,
  case doc.categ when 'EB' then 0 - cast ( sum (ccs.fixll) as fcml_ccsvalf_s ) else cast ( sum (ccs.fixll) as fcml_ccsvalf_s ) end as PRCDIF_FIX_S AS fixllasfcml_ccsvalf_sendasPRCDIF_FIX_S,
  ccs_ext_ae.prcdif_fix AS prcdif_fix,
  ccs_ext_ae.prcdif_var AS prcdif_var,
  ccs_ext_ae.prcdif_fix_s AS prcdif_fix_s,
  ccs_ext_ae.prcdif_var_s AS prcdif_var_s
FROM mldoc AS doc
INNER JOIN mlrunlist AS mlrun ON /* join condition not captured in parsed metadata */
INNER JOIN mldocccs AS ccs ON /* join condition not captured in parsed metadata */
INNER JOIN tckh3 AS t3 ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN tckh1 AS t1 ON /* join condition not captured in parsed metadata */
-- UNION ALL with additional select branch(es): fcml_ccs_r_ae_v
;