P_ValueChainMatDocItm

DDL: P_VALUECHAINMATDOCITM Type: view_entity COMPOSITE Package: ODATA_MM_IM_VCM
12 Fields 1 Data Sources

Material Document Item fields for VCM

P_ValueChainMatDocItm is a Composite CDS View that provides data about "Material Document Item fields for VCM" in SAP S/4HANA. It reads from 1 data source (I_MaterialDocumentItem) and exposes 12 fields with key fields BusinessObject, MaterialDocumentItem. Part of development package ODATA_MM_IM_VCM.

Data Sources (1)

SourceAliasJoin Type
I_MaterialDocumentItem I_MaterialDocumentItem from

Annotations (8)

NameValueLevelField
AccessControl.authorizationCheck #NOT_REQUIRED view
EndUserText.label Material Document Item fields for VCM view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #XXL view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
VDM.viewType #COMPOSITE view
VDM.private true view

Fields (12)

KeyFieldSource TableSource FieldDescription
KEY BusinessObject
KEY MaterialDocumentItem MaterialDocumentItem Material Document Item
MaterialDocument MaterialDocument Material Doc.
MaterialDocumentYear MaterialDocumentYear Material Document Year
Material Material Vehicle Model
MaterialName
Plant Plant Valuation Area
PlantName _Plant PlantName Plant Name
Batch Batch Lot No.
InventoryValuationType InventoryValuationType Valuation Type
QuantityInEntryUnit QuantityInEntryUnit Quantity in Unit of Entry
EntryUnit EntryUnit Unit of Entry

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 P_ValueChainMatDocItm.
-- 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.

CREATE VIEW P_ValueChainMatDocItm AS
SELECT
  concat(MaterialDocument, MaterialDocumentYear) AS BusinessObject,
  MaterialDocumentItem,
  MaterialDocument,
  MaterialDocumentYear,
  Material,
  _Material._Text[1: Language=$session.system_language].MaterialName AS MaterialName,
  Plant,
  _Plant.PlantName AS PlantName,
  Batch,
  InventoryValuationType,
  QuantityInEntryUnit,
  EntryUnit
FROM I_MaterialDocumentItem
;

Learn More