F_Mmim_Mdoc_It_Counter

DDL: F_MMIM_MDOC_IT_COUNTER SQL: FMMIMMDOCITCT Type: view
6 Fields 1 Data Sources

Material Documents Item Counter

F_Mmim_Mdoc_It_Counter is a CDS View that provides data about "Material Documents Item Counter" in SAP S/4HANA. It reads from 1 data source (matdoc) and exposes 6 fields.

Data Sources (1)

SourceAliasJoin Type
matdoc matdoc from

Annotations (9)

NameValueLevelField
AbapCatalog.preserveKey true view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.sqlViewName FMMIMMDOCITCT view
EndUserText.label Material Documents Item Counter view
AccessControl.authorizationCheck #NOT_REQUIRED view
ObjectModel.usageType.sizeCategory #XXL view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.dataClass #MIXED view
ClientHandling.algorithm #SESSION_VARIABLE view

Fields (6)

KeyFieldSource TableSource FieldDescription
MaterialDocument mblnr Material Doc.
MaterialDocumentYear mjahr Mat. Doc. Year
MaterialDocumentItem zeile Mat. Doc.Item
IsCancelled cancelled Item Discarded
dec40endasNumberOfItemsInMaterialDoc
dec40endasNumberOfRvsdItemsInMaterialDoc

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 F_Mmim_Mdoc_It_Counter.
-- 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: FMMIMMDOCITCT

CREATE VIEW F_Mmim_Mdoc_It_Counter AS
SELECT
  mblnr AS MaterialDocument,
  mjahr AS MaterialDocumentYear,
  zeile AS MaterialDocumentItem,
  cancelled AS IsCancelled,
  case when xmacc = '' then cast( 1 as abap.dec(4, 0) ) when xmacc <> '' and urzei = maa_urzei then cast( 1 as abap.dec(4, 0) ) else cast( 0 as abap.dec(4, 0) ) end as NumberOfItemsInMaterialDoc AS dec40endasNumberOfItemsInMaterialDoc,
  case when cancelled <> '' and xmacc = '' then cast( 1 as abap.dec(4, 0) ) when cancelled <> '' and xmacc <> '' and urzei = maa_urzei then cast( 1 as abap.dec(4, 0) ) else cast( 0 as abap.dec(4, 0) ) end as NumberOfRvsdItemsInMaterialDoc AS dec40endasNumberOfRvsdItemsInMaterialDoc
FROM matdoc
;

Learn More