I_FldLogsMatlDocItems

DDL: I_FLDLOGSMATLDOCITEMS SQL: IFLMATDOCITMS Type: view COMPOSITE
27 Fields 2 Data Sources 2 Associations

Material Document Items

I_FldLogsMatlDocItems is a Composite CDS View that provides data about "Material Document Items" in SAP S/4HANA. It reads from 2 data sources (I_FieldLogisticsPlantAll, I_MaterialDocumentRecord) and exposes 27 fields with key fields MaterialDocumentYear, MaterialDocument, MaterialDocumentItem. It has 2 associations to related views.

Data Sources (2)

SourceAliasJoin Type
I_FieldLogisticsPlantAll _FldLogsAllPlants inner
I_MaterialDocumentRecord _MaterialDocumentRecord from

Associations (2)

CardinalityTargetAliasCondition
[1..1] I_MaterialDocumentHeader _MaterialDocumentHeader $projection.MaterialDocumentYear = _MaterialDocumentHeader.MaterialDocumentYear and $projection.MaterialDocument = _MaterialDocumentHeader.MaterialDocument
[0..1] I_FldLogsMatlDocItems _ReversedMatDocItem $projection.MaterialDocumentYear = _ReversedMatDocItem.ReversedMaterialDocumentYear and $projection.MaterialDocument = _ReversedMatDocItem.ReversedMaterialDocument and $projection.MaterialDocumentItem = _ReversedMatDocItem.ReversedMaterialDocumentItem

Annotations (11)

NameValueLevelField
AbapCatalog.sqlViewName IFLMATDOCITMS view
AbapCatalog.preserveKey true view
EndUserText.label Material Document Items view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #CHECK view
ClientHandling.algorithm #SESSION_VARIABLE view
VDM.viewType #COMPOSITE view
ObjectModel.usageType.sizeCategory #XXL view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.representativeKey MaterialDocumentItem view

Fields (27)

KeyFieldSource TableSource FieldDescription
KEY MaterialDocumentYear I_MaterialDocumentRecord MaterialDocumentYear Material Document Year
KEY MaterialDocument I_MaterialDocumentRecord MaterialDocument Material Doc.
KEY MaterialDocumentItem I_MaterialDocumentRecord MaterialDocumentItem Material Document Item
Material I_MaterialDocumentRecord Material Vehicle Model
Plant I_MaterialDocumentRecord Plant Valuation Area
StorageLocation I_MaterialDocumentRecord StorageLocation StorageLocation
Batch I_MaterialDocumentRecord Batch Lot No.
ShelfLifeExpirationDate I_MaterialDocumentRecord ShelfLifeExpirationDate SLED/BBD
ManufactureDate I_MaterialDocumentRecord ManufactureDate Date of Manuf.
InventoryStockType I_MaterialDocumentRecord InventoryStockType Stock Type
GoodsMovementType I_MaterialDocumentRecord GoodsMovementType Movement Type
QuantityInBaseUnit I_MaterialDocumentRecord QuantityInBaseUnit Quantity
MaterialBaseUnit I_MaterialDocumentRecord MaterialBaseUnit Valuation Unit
PostingDate I_MaterialDocumentRecord PostingDate Posting Date for GR
DocumentDate I_MaterialDocumentRecord DocumentDate Journal Entry Date
InventoryValuationType I_MaterialDocumentRecord InventoryValuationType Valuation Type
PurchaseOrder I_MaterialDocumentRecord PurchaseOrder Purchasing Document
PurchaseOrderItem I_MaterialDocumentRecord PurchaseOrderItem Purchasing Document Item
DeliveryDocument I_MaterialDocumentRecord DeliveryDocument Outbound Delivery
DeliveryDocumentItem I_MaterialDocumentRecord DeliveryDocumentItem Outb. Delivery Item
ReversedMaterialDocumentYear I_MaterialDocumentRecord ReversedMaterialDocumentYear Reversed Doc Year
ReversedMaterialDocument I_MaterialDocumentRecord ReversedMaterialDocument Reversed Mat Doc
ReversedMaterialDocumentItem I_MaterialDocumentRecord ReversedMaterialDocumentItem Reversed Doc Item
QuantityInEntryUnit I_MaterialDocumentRecord QuantityInEntryUnit Quantity in Unit of Entry
EntryUnit I_MaterialDocumentRecord EntryUnit Unit of Entry
_MaterialDocumentHeader _MaterialDocumentHeader
_ReversedMatDocItem _ReversedMatDocItem

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 I_FldLogsMatlDocItems.
-- 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: IFLMATDOCITMS

CREATE VIEW I_FldLogsMatlDocItems AS
SELECT
  _MaterialDocumentRecord.MaterialDocumentYear AS MaterialDocumentYear,
  _MaterialDocumentRecord.MaterialDocument AS MaterialDocument,
  _MaterialDocumentRecord.MaterialDocumentItem AS MaterialDocumentItem,
  _MaterialDocumentRecord.Material AS Material,
  _MaterialDocumentRecord.Plant AS Plant,
  _MaterialDocumentRecord.StorageLocation AS StorageLocation,
  _MaterialDocumentRecord.Batch AS Batch,
  _MaterialDocumentRecord.ShelfLifeExpirationDate AS ShelfLifeExpirationDate,
  _MaterialDocumentRecord.ManufactureDate AS ManufactureDate,
  _MaterialDocumentRecord.InventoryStockType AS InventoryStockType,
  _MaterialDocumentRecord.GoodsMovementType AS GoodsMovementType,
  _MaterialDocumentRecord.QuantityInBaseUnit AS QuantityInBaseUnit,
  _MaterialDocumentRecord.MaterialBaseUnit AS MaterialBaseUnit,
  _MaterialDocumentRecord.PostingDate AS PostingDate,
  _MaterialDocumentRecord.DocumentDate AS DocumentDate,
  _MaterialDocumentRecord.InventoryValuationType AS InventoryValuationType,
  _MaterialDocumentRecord.PurchaseOrder AS PurchaseOrder,
  _MaterialDocumentRecord.PurchaseOrderItem AS PurchaseOrderItem,
  _MaterialDocumentRecord.DeliveryDocument AS DeliveryDocument,
  _MaterialDocumentRecord.DeliveryDocumentItem AS DeliveryDocumentItem,
  _MaterialDocumentRecord.ReversedMaterialDocumentYear AS ReversedMaterialDocumentYear,
  _MaterialDocumentRecord.ReversedMaterialDocument AS ReversedMaterialDocument,
  _MaterialDocumentRecord.ReversedMaterialDocumentItem AS ReversedMaterialDocumentItem,
  _MaterialDocumentRecord.QuantityInEntryUnit AS QuantityInEntryUnit,
  _MaterialDocumentRecord.EntryUnit AS EntryUnit
FROM I_MaterialDocumentRecord AS _MaterialDocumentRecord
INNER JOIN I_FieldLogisticsPlantAll AS _FldLogsAllPlants ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_MaterialDocumentHeader AS _MaterialDocumentHeader ON MaterialDocumentYear = _MaterialDocumentHeader.MaterialDocumentYear AND MaterialDocument = _MaterialDocumentHeader.MaterialDocument  -- association [1..1]
LEFT OUTER JOIN I_FldLogsMatlDocItems AS _ReversedMatDocItem ON MaterialDocumentYear = _ReversedMatDocItem.ReversedMaterialDocumentYear AND MaterialDocument = _ReversedMatDocItem.ReversedMaterialDocument AND MaterialDocumentItem = _ReversedMatDocItem.ReversedMaterialDocumentItem  -- association [0..1]
;

Learn More