C_DspDocFlwMatlDocVH

DDL: C_DSPDOCFLWMATLDOCVH SQL: CDDFMATLDOCVH Type: view CONSUMPTION
7 Fields 1 Data Sources

Material Document

C_DspDocFlwMatlDocVH is a Consumption CDS View that provides data about "Material Document" in SAP S/4HANA. It reads from 1 data source (I_MaterialDocumentHeaderStdVH) and exposes 7 fields with key fields MaterialDocument, MaterialDocumentYear.

Data Sources (1)

SourceAliasJoin Type
I_MaterialDocumentHeaderStdVH I_MaterialDocumentHeaderStdVH from

Annotations (15)

NameValueLevelField
AbapCatalog.sqlViewName CDDFMATLDOCVH view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
ClientHandling.algorithm #SESSION_VARIABLE view
AccessControl.authorizationCheck #CHECK view
AccessControl.personalData.blocking #BLOCKED_DATA_EXCLUDED view
ObjectModel.dataCategory #VALUE_HELP view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.serviceQuality #B view
ObjectModel.usageType.sizeCategory #XXL view
VDM.viewType #CONSUMPTION view
Metadata.ignorePropagatedAnnotations true view
EndUserText.label Material Document view
Search.searchable true view
Consumption.ranked true view

Fields (7)

KeyFieldSource TableSource FieldDescription
KEY MaterialDocument MaterialDocument Material Doc.
KEY MaterialDocumentYear MaterialDocumentYear Material Document Year
DocumentIsArchived
AnchorDocument Material Doc.
ReferenceDocumentType
_MaterialDocumentYear _MaterialDocumentYear
_MaterialDocumentItem _MaterialDocumentItem

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 C_DspDocFlwMatlDocVH.
-- 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: CDDFMATLDOCVH

CREATE VIEW C_DspDocFlwMatlDocVH AS
SELECT
  MaterialDocument,
  MaterialDocumentYear,
  cast('' as xarch) AS DocumentIsArchived,
  cast( MaterialDocument as fac_ddf_anchor_document ) AS AnchorDocument,
  cast( 'MKPF' as swo_objtyp) AS ReferenceDocumentType
FROM I_MaterialDocumentHeaderStdVH
;

Learn More