FCMLDOC_EX_MAT_DDL

DDL: FCML_DOC_EX_MAT_V SQL: FCMLDOC_EX_MAT_V Type: view
8 Fields 2 Data Sources

Materials from MLDOC_EXTRACT

FCMLDOC_EX_MAT_DDL is a CDS View that provides data about "Materials from MLDOC_EXTRACT" in SAP S/4HANA. It reads from 2 data sources (mldoc_extract, ckmlhd) and exposes 8 fields with key fields kalnr_mat, jahrper, curtp, rldnr.

Data Sources (2)

SourceAliasJoin Type
mldoc_extract doc_ex from
ckmlhd hd inner

Annotations (10)

NameValueLevelField
AbapCatalog.sqlViewName FCMLDOC_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_EXTRACT view

Fields (8)

KeyFieldSource TableSource FieldDescription
KEY kalnr_mat
KEY jahrper mldoc_extract jahrper Year / Period
KEY curtp mldoc_extract curtp Valuation Area
KEY rldnr mldoc_extract rldnr Ledger (Compat.)
lbkum
meins
salk3
waers mldoc_extract waers Transaction Currency

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 FCMLDOC_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: FCMLDOC_EX_MAT_V

CREATE VIEW FCMLDOC_EX_MAT_DDL AS
SELECT
  cast ( doc_ex.kalnr as ck_kalnr preserving type ) AS kalnr_mat,
  doc_ex.jahrper AS jahrper,
  doc_ex.curtp AS curtp,
  doc_ex.rldnr AS rldnr,
  cast ( sum (doc_ex.quant) as ck_lbkum ) AS lbkum,
  cast ( doc_ex.meins as meins preserving type ) AS meins,
  cast ( sum (doc_ex.stval) as ck_salk3_1 ) AS salk3,
  doc_ex.waers AS waers
FROM mldoc_extract AS doc_ex
INNER JOIN ckmlhd AS hd ON /* join condition not captured in parsed metadata */
;

Learn More