I_MaterialDocumentItem_2

DDL: I_MATERIALDOCUMENTITEM_2 Type: view COMPOSITE
123 Fields 1 Data Sources 4 Associations

Material Document Item

I_MaterialDocumentItem_2 (Composite)

Package: Explore, extend and adapt the SAP S/4HANA Cloud Private Edition with built-in and side-by-side extension capabilities.

Supply Chain

I_MaterialDocumentItem_2 is a Composite CDS View (Dimension) that provides data about "Material Document Item" in SAP S/4HANA. It reads from 1 data source (I_MaterialDocumentRecord) and exposes 123 fields with key fields MaterialDocumentYear, MaterialDocument, MaterialDocumentItem. It has 4 associations to related views.

SAP API Hub

StateC1
Line of BusinessSupply Chain
Application ComponentMM-IM-VDM-SGM
CapabilitiesAssociation Target for Defining CDS Entities, Analytical Dimension, Data Source for Defining CDS Entities, Data Source in SQL Select
PackageSupply Chain for SAP S/4HANA Cloud Private Edition
Description <p>This view is the successor view for I_MaterialDocumentItem.</p> <p>This CDS view provides the prerequisites for answering the following business question:</p> <ul> <li><p>What are the line items of posted material documents?</p></li> </ul>

Documentation

Data Sources (1)

SourceAliasJoin Type
I_MaterialDocumentRecord I_MaterialDocumentRecord from

Associations (4)

CardinalityTargetAliasCondition
[1..1] I_MaterialDocumentYear _MaterialDocumentYear $projection.MaterialDocumentYear = _MaterialDocumentYear.MaterialDocumentYear
[1..1] I_MaterialDocumentHeader_2 _MaterialDocumentHeader $projection.MaterialDocumentYear = _MaterialDocumentHeader.MaterialDocumentYear and $projection.MaterialDocument = _MaterialDocumentHeader.MaterialDocument
[0..1] I_MaterialDocumentHeader_2 _ReversedMatDoc $projection.ReversedMaterialDocumentYear = _ReversedMatDoc.MaterialDocumentYear and $projection.ReversedMaterialDocument = _ReversedMatDoc.MaterialDocument
[0..1] I_MaterialDocumentItem_2 _ReversedMatDocItem $projection.ReversedMaterialDocumentYear = _ReversedMatDocItem.MaterialDocumentYear and $projection.ReversedMaterialDocument = _ReversedMatDocItem.MaterialDocument and $projection.ReversedMaterialDocumentItem = _ReversedMatDocItem.MaterialDocumentItem

Annotations (19)

NameValueLevelField
AbapCatalog.sqlViewName IMATDOCITEM2 view
AbapCatalog.preserveKey true view
AbapCatalog.compiler.compareFilter true view
EndUserText.label Material Document Item view
AccessControl.authorizationCheck #CHECK view
AccessControl.personalData.blocking #NOT_REQUIRED view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.usageType.sizeCategory #XXL view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.representativeKey MaterialDocumentItem view
ObjectModel.modelingPattern #ANALYTICAL_DIMENSION view
Search.searchable true view
VDM.viewType #COMPOSITE view
VDM.lifecycle.contract.type #PUBLIC_LOCAL_API view
Analytics.dataCategory #DIMENSION view
Analytics.internalName #LOCAL view
Metadata.ignorePropagatedAnnotations true view
Metadata.allowExtensions true view

Fields (123)

KeyFieldSource TableSource FieldDescription
KEY MaterialDocumentYear MaterialDocumentYear Material Document Year
KEY MaterialDocument MaterialDocument Number of Material Document
KEY MaterialDocumentItem MaterialDocumentItem Material Document Item
Material Material Material Number
Plant Plant Valuation Area
StorageLocation StorageLocation Storage Location
StorageType StorageType Storage Type
StorageBin StorageBin Storage Bin
Batch Batch Batch Number
ShelfLifeExpirationDate ShelfLifeExpirationDate Shelf Life Expiration or Best-Before Date
ManufactureDate ManufactureDate Date of Manufacture
Supplier Supplier Supplier's Account Number
SalesOrder SalesOrder Sales Order Number
SalesOrderItem SalesOrderItem Sales Order Item
SalesOrderScheduleLine SalesOrderScheduleLine Sales Order Schedule
WBSElementInternalID Valuated Sales Order Stock WBS Element
Customer Customer Account Number of Customer
InventorySpecialStockType InventorySpecialStockType Special Stock Type
InventoryStockType InventoryStockType Stock Type of Goods Movement (Stock Identifier)
StockOwner StockOwner Additional Supplier for Special Stock
GoodsMovementType GoodsMovementType Movement Type (Inventory Management)
DebitCreditCode DebitCreditCode Debit/Credit Indicator
InventoryUsabilityCode InventoryUsabilityCode Posting Control Stock Type
QuantityInBaseUnit QuantityInBaseUnit Quantity
MaterialBaseUnit MaterialBaseUnit Base Unit of Measure
QuantityInEntryUnit QuantityInEntryUnit Quantity in Unit of Entry
EntryUnit EntryUnit Unit of Entry
PostingDate PostingDate Posting Date in the Document
DocumentDate DocumentDate Document Date in Document
TotalGoodsMvtAmtInCCCrcy TotalGoodsMvtAmtInCCCrcy Amount in Local Currency
CompanyCodeCurrency CompanyCodeCurrency Company Code Currency
InventoryValuationType InventoryValuationType Valuation Type
ReservationIsFinallyIssued ReservationIsFinallyIssued Final Issue for Reservation
PurchaseOrder PurchaseOrder Purchase Order Number
PurchaseOrderItem PurchaseOrderItem Item Number of Purchasing Document
ProjectNetwork ProjectNetwork Network Number for Account Assignment
OrderID OrderID Order Number
OrderItem OrderItem Order Item
MaintOrderRoutingNumber MaintOrderRoutingNumber Routing Number of Operations in the Order
MaintOrderOperationCounter MaintOrderOperationCounter Internal Counter
Reservation Reservation Number of Reservation/Dependent Requirements
ReservationItem ReservationItem Item Number of Reservation / Dependent Requirements
DeliveryDocument DeliveryDocument Outbound Delivery
DeliveryDocumentItem DeliveryDocumentItem Delivery Document Item
ReversedMaterialDocumentYear ReversedMaterialDocumentYear Reversed Material Document Year
ReversedMaterialDocument ReversedMaterialDocument Reversed Material Document
ReversedMaterialDocumentItem ReversedMaterialDocumentItem Reversed Material Document Item
RvslOfGoodsReceiptIsAllowed RvslOfGoodsReceiptIsAllowed Reversal of GR allowed for GR-based IV despite invoice
GoodsRecipientName GoodsRecipientName Goods Recipient
UnloadingPointName UnloadingPointName Unloading Point Name
CostCenter CostCenter Cost Center
GLAccount GLAccount G/L Account Number
ServicePerformer ServicePerformer Service Performer
PersonWorkAgreement PersonWorkAgreement Personnel Number
AccountAssignmentCategory AccountAssignmentCategory Account Assignment Category
WorkItem WorkItem Work Item ID
ServicesRenderedDate ServicesRenderedDate Date on which Services were Provided
IssgOrRcvgMaterial IssgOrRcvgMaterial Transfer Material
IssuingOrReceivingPlant IssuingOrReceivingPlant Transfer Plant
IssuingOrReceivingStorageLoc IssuingOrReceivingStorageLoc Receiving/Issuing Storage Location
IssgOrRcvgBatch IssgOrRcvgBatch Transfer Batch
IssgOrRcvgSpclStockInd IssgOrRcvgSpclStockInd Special Stock Indicator
CompanyCode CompanyCode Receiver Company Code
BusinessArea BusinessArea Business Area
ControllingArea ControllingArea Controlling Area
FiscalYearPeriod FiscalYearPeriod Period/Year
FiscalYearVariant FiscalYearVariant Fiscal Year Variant
GoodsMovementRefDocType GoodsMovementRefDocType Goods Movement Reference Document Type
IsCompletelyDelivered IsCompletelyDelivered "Delivery Completed" Indicator
MaterialDocumentItemText MaterialDocumentItemText Item Text
IsAutomaticallyCreated IsAutomaticallyCreated Item Automatically Created Indicator
GoodsReceiptType GoodsReceiptType Receipt Indicator
ConsumptionPosting ConsumptionPosting Consumption Posting
MultiAcctAssgmtOriglMatlDocItm MultiAcctAssgmtOriglMatlDocItm Original Line for Account Assignment Item in Material Doc.
MultipleAccountAssignmentCode MultipleAccountAssignmentCode Multiple Account Assignment Code
GoodsMovementIsCancelled GoodsMovementIsCancelled Item has been Cancelled
IssuingOrReceivingStockType IssuingOrReceivingStockType Transfer Stock Type
_MaterialDocumentYear _MaterialDocumentYear
_MaterialDocumentHeader _MaterialDocumentHeader
_Material _Material
_IssgOrRcvgMaterial _IssgOrRcvgMaterial
_Plant _Plant
_IssuingOrReceivingPlant _IssuingOrReceivingPlant
_StorageLocation _StorageLocation
_IssuingOrReceivingStorageLoc _IssuingOrReceivingStorageLoc
_Supplier _Supplier
_Customer _Customer
_SupplierCompanyByPlant _SupplierCompanyByPlant
_CustomerCompanyByPlant _CustomerCompanyByPlant
_BPStockOwner _BPStockOwner
_InventorySpecialStockType _InventorySpecialStockType
_IssgOrRcvgSpclStockInd _IssgOrRcvgSpclStockInd
_InventoryStockType _InventoryStockType
_InventoryValuationType _InventoryValuationType
_GoodsMovementType _GoodsMovementType
_DebitCreditCode _DebitCreditCode
_StockType _StockType
_StockType_2 _StockType_2
_MaterialBaseUnit _MaterialBaseUnit
_EntryUnit _EntryUnit
_GLAccount _GLAccount
_CostCenter _CostCenter
_BusinessPartner _BusinessPartner
_PersonWorkAgreement _PersonWorkAgreement
_AccountAssignmentCategory _AccountAssignmentCategory
_WorkItem _WorkItem
_CompanyCode _CompanyCode
_BusinessArea _BusinessArea
_ControllingArea _ControllingArea
_SalesOrder _SalesOrder
_SalesOrderItem _SalesOrderItem
_SalesOrderScheduleLine _SalesOrderScheduleLine
_WBSElement _WBSElement
_PurchaseOrder _PurchaseOrder
_PurchaseOrderItem _PurchaseOrderItem
_ProjectNetwork _ProjectNetwork
_LogisticsOrder _LogisticsOrder
_DeliveryDocument _DeliveryDocument
_DeliveryDocumentItem _DeliveryDocumentItem
_ReversedMatDoc _ReversedMatDoc
_ReversedMatDocItem _ReversedMatDocItem
_GoodsMvtTypeBySpclStkIndT _GoodsMvtTypeBySpclStkIndT
_Currency _Currency

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_MaterialDocumentItem_2.
-- 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_MaterialDocumentItem_2 AS
SELECT
  MaterialDocumentYear,
  MaterialDocument,
  MaterialDocumentItem,
  Material,
  Plant,
  StorageLocation,
  StorageType,
  StorageBin,
  Batch,
  ShelfLifeExpirationDate,
  ManufactureDate,
  Supplier,
  SalesOrder,
  SalesOrderItem,
  SalesOrderScheduleLine,
  cast(WBSElementInternalID as nsdm_wbselement_internal_id preserving type) AS WBSElementInternalID,
  Customer,
  InventorySpecialStockType,
  InventoryStockType,
  StockOwner,
  GoodsMovementType,
  DebitCreditCode,
  InventoryUsabilityCode,
  QuantityInBaseUnit,
  MaterialBaseUnit,
  QuantityInEntryUnit,
  EntryUnit,
  PostingDate,
  DocumentDate,
  TotalGoodsMvtAmtInCCCrcy,
  CompanyCodeCurrency,
  InventoryValuationType,
  ReservationIsFinallyIssued,
  PurchaseOrder,
  PurchaseOrderItem,
  ProjectNetwork,
  OrderID,
  OrderItem,
  MaintOrderRoutingNumber,
  MaintOrderOperationCounter,
  Reservation,
  ReservationItem,
  DeliveryDocument,
  DeliveryDocumentItem,
  ReversedMaterialDocumentYear,
  ReversedMaterialDocument,
  ReversedMaterialDocumentItem,
  RvslOfGoodsReceiptIsAllowed,
  GoodsRecipientName,
  UnloadingPointName,
  CostCenter,
  GLAccount,
  ServicePerformer,
  PersonWorkAgreement,
  AccountAssignmentCategory,
  WorkItem,
  ServicesRenderedDate,
  IssgOrRcvgMaterial,
  IssuingOrReceivingPlant,
  IssuingOrReceivingStorageLoc,
  IssgOrRcvgBatch,
  IssgOrRcvgSpclStockInd,
  CompanyCode,
  BusinessArea,
  ControllingArea,
  FiscalYearPeriod,
  FiscalYearVariant,
  GoodsMovementRefDocType,
  IsCompletelyDelivered,
  MaterialDocumentItemText,
  IsAutomaticallyCreated,
  GoodsReceiptType,
  ConsumptionPosting,
  MultiAcctAssgmtOriglMatlDocItm,
  MultipleAccountAssignmentCode,
  GoodsMovementIsCancelled,
  IssuingOrReceivingStockType
FROM I_MaterialDocumentRecord
LEFT OUTER JOIN I_MaterialDocumentYear AS _MaterialDocumentYear ON MaterialDocumentYear = _MaterialDocumentYear.MaterialDocumentYear  -- association [1..1]
LEFT OUTER JOIN I_MaterialDocumentHeader_2 AS _MaterialDocumentHeader ON MaterialDocumentYear = _MaterialDocumentHeader.MaterialDocumentYear AND MaterialDocument = _MaterialDocumentHeader.MaterialDocument  -- association [1..1]
LEFT OUTER JOIN I_MaterialDocumentHeader_2 AS _ReversedMatDoc ON ReversedMaterialDocumentYear = _ReversedMatDoc.MaterialDocumentYear AND ReversedMaterialDocument = _ReversedMatDoc.MaterialDocument  -- association [0..1]
LEFT OUTER JOIN I_MaterialDocumentItem_2 AS _ReversedMatDocItem ON ReversedMaterialDocumentYear = _ReversedMatDocItem.MaterialDocumentYear AND ReversedMaterialDocument = _ReversedMatDocItem.MaterialDocument AND ReversedMaterialDocumentItem = _ReversedMatDocItem.MaterialDocumentItem  -- association [0..1]
;

Learn More