FCML_CCS_R_AE_DDL

DDL: FCML_CCS_R_AE_V SQL: FCML_CCS_R_AE_V Type: view
45 Fields 2 Data Sources 1 Associations

CDS View struct FCML_CCS_REP,Beg/End.Inv

FCML_CCS_R_AE_DDL is a CDS View that provides data about "CDS View struct FCML_CCS_REP,Beg/End.Inv" in SAP S/4HANA. It reads from 2 data sources (fcml_act_perds_v, fcml_act_perds_v) and exposes 45 fields with key fields kalnr_mat, poper, BDATJ, RUN_ACT, RUN_APPL. It has 1 association to related views.

Data Sources (2)

SourceAliasJoin Type
fcml_act_perds_v periods from
fcml_act_perds_v periods union_all

Associations (1)

CardinalityTargetAliasCondition
[1..*] FCMLCCS_EX_MAT_DDL _mlccsextr _mlccsextr.jahrper < periods.jahrper

Annotations (9)

NameValueLevelField
AbapCatalog.sqlViewName FCML_CCS_R_AE_V view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #NOT_REQUIRED view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ClientHandling.type #CLIENT_DEPENDENT view
ClientHandling.algorithm #AUTOMATED view
EndUserText.label CDS View struct FCML_CCS_REP,Beg/End.Inv view

Fields (45)

KeyFieldSource TableSource FieldDescription
KEY kalnr_mat _mlccsextr kalnr_mat ProdCostEst.No.
KEY poper
KEY BDATJ
KEY RUN_ACT
KEY RUN_APPL
KEY CATEG
KEY PTYP
KEY PSART
KEY KALNR_PMAT
KEY bvalt
KEY process
KEY elesmhk _mlccsextr elesmhk Cost Comp. Str.
KEY element _mlccsextr element Target identifier
KEY svrel _mlccsextr svrel Relev. f. Stock Val.
KEY MLCCT
KEY keart _mlccsextr keart Type of CCS
KEY curtp _mlccsextr curtp Valuation Area
KEY rldnr _mlccsextr rldnr Ledger (Compat.)
PRCDIF_FIX
PRCDIF_VAR
waers _mlccsextr waers Transaction Currency
PRCDIF_FIX_S
kalnr_mat ProdCostEst.No.
KEY poper
KEY BDATJ
KEY RUN_ACT
KEY RUN_APPL
KEY CATEG
KEY PTYP
KEY PSART
KEY KALNR_PMAT
KEY bvalt
KEY process
KEY elesmhk _mlccsextr elesmhk Cost Comp. Str.
KEY element _mlccsextr element Target identifier
KEY svrel _mlccsextr svrel Relev. f. Stock Val.
KEY MLCCT
KEY keart _mlccsextr keart Type of CCS
KEY curtp _mlccsextr curtp Valuation Area
KEY rldnr _mlccsextr rldnr Ledger (Compat.)
PRCDIF_FIX
PRCDIF_VAR
waers _mlccsextr waers Transaction Currency
PRCDIF_FIX_S
PRCDIF_VAR_S

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_R_AE_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_R_AE_V

CREATE VIEW FCML_CCS_R_AE_DDL AS
SELECT
  _mlccsextr.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,
  _mlccsextr.elesmhk AS elesmhk,
  _mlccsextr.element AS element,
  _mlccsextr.svrel AS svrel,
  cast ( 'V' as ml4h_mlcct preserving type ) AS MLCCT,
  _mlccsextr.keart AS keart,
  _mlccsextr.curtp AS curtp,
  _mlccsextr.rldnr AS rldnr,
  cast ( sum (_mlccsextr.PRCDIF_FIX) as fcml_ccsvalf ) AS PRCDIF_FIX,
  cast ( sum (_mlccsextr.PRCDIF_VAR) as fcml_ccsvalv ) AS PRCDIF_VAR,
  _mlccsextr.waers AS waers,
  cast ( sum (_mlccsextr.PRCDIF_FIX_S) as fcml_ccsvalf_s ) AS PRCDIF_FIX_S,
  cast ( sum (_mlccsextr.PRCDIF_VAR_S) as fcml_ccsvalv_s ) AS PRCDIF_VAR_S
FROM fcml_act_perds_v AS periods
LEFT OUTER JOIN FCMLCCS_EX_MAT_DDL AS _mlccsextr ON /* condition not available in parsed metadata */  -- association [1..*]
-- UNION ALL with additional select branch(es): fcml_act_perds_v
;

Learn More