FCMLCCS_EX_MAT_DDL

DDL: FCML_CCS_EX_MAT_V SQL: FCMLCCS_EX_MAT_V Type: view Package: FCML4H_DISPLAY
11 Fields 2 Data Sources

Materials from MLDOC_CCS_EXTRACT

FCMLCCS_EX_MAT_DDL is a CDS View that provides data about "Materials from MLDOC_CCS_EXTRACT" in SAP S/4HANA. It reads from 2 data sources (mldocccs_extract, ckmlhd) and exposes 11 fields with key fields kalnr_mat, jahrper, elesmhk, element, curtp. Part of development package FCML4H_DISPLAY.

Data Sources (2)

SourceAliasJoin Type
mldocccs_extract ccs_ex from
ckmlhd hd inner

Annotations (10)

NameValueLevelField
AbapCatalog.sqlViewName FCMLCCS_EX_MAT_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
AbapCatalog.preserveKey true view
EndUserText.label Materials from MLDOC_CCS_EXTRACT view

Fields (11)

KeyFieldSource TableSource FieldDescription
KEY kalnr_mat
KEY jahrper mldocccs_extract jahrper Year / Period
KEY elesmhk mldocccs_extract elesmhk Cost Comp. Str.
KEY element mldocccs_extract element Target identifier
KEY curtp mldocccs_extract curtp Valuation Area
KEY rldnr mldocccs_extract rldnr Ledger (Compat.)
PRCDIF_FIX
fixasfcml_ccsvalvasPRCDIF_VAR
waers mldocccs_extract waers Transaction Currency
PRCDIF_FIX_S
fixllasfcml_ccsvalv_sasPRCDIF_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 FCMLCCS_EX_MAT_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: FCMLCCS_EX_MAT_V

CREATE VIEW FCMLCCS_EX_MAT_DDL AS
SELECT
  cast ( ccs_ex.kalnr as ck_kalnr preserving type ) AS kalnr_mat,
  ccs_ex.jahrper AS jahrper,
  ccs_ex.elesmhk AS elesmhk,
  ccs_ex.element AS element,
  ccs_ex.curtp AS curtp,
  ccs_ex.rldnr AS rldnr,
  cast ( sum (ccs_ex.fix) as fcml_ccsvalf ) AS PRCDIF_FIX,
  cast ( sum (ccs_ex.tot) as fcml_ccsvalv ) - cast (sum (ccs_ex.fix) as fcml_ccsvalv ) as PRCDIF_VAR AS fixasfcml_ccsvalvasPRCDIF_VAR,
  ccs_ex.waers AS waers,
  cast ( sum (ccs_ex.fixll) as fcml_ccsvalf_s ) AS PRCDIF_FIX_S,
  cast ( sum (ccs_ex.totll) as fcml_ccsvalv_s ) - cast (sum (ccs_ex.fixll) as fcml_ccsvalv_s ) as PRCDIF_VAR_S AS fixllasfcml_ccsvalv_sasPRCDIF_VAR_S
FROM mldocccs_extract AS ccs_ex
INNER JOIN ckmlhd AS hd ON /* join condition not captured in parsed metadata */
;

Learn More