I_FldLogsRcptMatlDocItem

DDL: I_FLDLOGSRCPTMATLDOCITEM Type: view_entity COMPOSITE
27 Fields 1 Data Sources

Material Document Items

I_FldLogsRcptMatlDocItem is a Composite CDS View that provides data about "Material Document Items" in SAP S/4HANA. It reads from 1 data source (I_FldLogsMatlDocItems) and exposes 27 fields with key fields MaterialDocumentYear, MaterialDocument, MaterialDocumentItem.

Data Sources (1)

SourceAliasJoin Type
I_FldLogsMatlDocItems I_FldLogsMatlDocItems from

Annotations (7)

NameValueLevelField
EndUserText.label Material Document Items view
AccessControl.authorizationCheck #MANDATORY view
VDM.viewType #COMPOSITE view
ObjectModel.usageType.sizeCategory #XXL view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
AccessControl.personalData.blocking #REQUIRED view

Fields (27)

KeyFieldSource TableSource FieldDescription
KEY MaterialDocumentYear MaterialDocumentYear Material Document Year
KEY MaterialDocument MaterialDocument Material Doc.
KEY MaterialDocumentItem MaterialDocumentItem Material Document Item
Material Material Vehicle Model
Plant Plant Valuation Area
StorageLocation StorageLocation StorageLocation
Batch Batch Lot No.
ShelfLifeExpirationDate ShelfLifeExpirationDate SLED/BBD
ManufactureDate ManufactureDate Date of Manuf.
InventoryStockType InventoryStockType Stock Type
GoodsMovementType GoodsMovementType Movement Type
QuantityInBaseUnit QuantityInBaseUnit Quantity
MaterialBaseUnit MaterialBaseUnit Valuation Unit
PostingDate PostingDate Posting Date for GR
DocumentDate DocumentDate Journal Entry Date
InventoryValuationType InventoryValuationType Valuation Type
PurchaseOrder PurchaseOrder Purchasing Document
PurchaseOrderItem PurchaseOrderItem Purchasing Document Item
DeliveryDocument DeliveryDocument Outbound Delivery
DeliveryDocumentItem DeliveryDocumentItem Outb. Delivery Item
ReversedMaterialDocumentYear ReversedMaterialDocumentYear Reversed Doc Year
ReversedMaterialDocument ReversedMaterialDocument Reversed Mat Doc
ReversedMaterialDocumentItem ReversedMaterialDocumentItem Reversed Doc Item
QuantityInEntryUnit QuantityInEntryUnit Quantity in Unit of Entry
EntryUnit 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_FldLogsRcptMatlDocItem.
-- 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 I_FldLogsRcptMatlDocItem AS
SELECT
  MaterialDocumentYear,
  MaterialDocument,
  MaterialDocumentItem,
  Material,
  Plant,
  StorageLocation,
  Batch,
  ShelfLifeExpirationDate,
  ManufactureDate,
  InventoryStockType,
  GoodsMovementType,
  QuantityInBaseUnit,
  MaterialBaseUnit,
  PostingDate,
  DocumentDate,
  InventoryValuationType,
  PurchaseOrder,
  PurchaseOrderItem,
  DeliveryDocument,
  DeliveryDocumentItem,
  ReversedMaterialDocumentYear,
  ReversedMaterialDocument,
  ReversedMaterialDocumentItem,
  QuantityInEntryUnit,
  EntryUnit
FROM I_FldLogsMatlDocItems
;

Learn More