I_MaterialDocumentItem
Material Document Item
I_MaterialDocumentItem 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 120 fields with key fields MaterialDocumentYear, MaterialDocument, MaterialDocumentItem. It has 4 associations to related views. Part of development package MM_IM_VDM_STOCK.
Data Sources (1)
| Source | Alias | Join Type |
|---|---|---|
| I_MaterialDocumentRecord | I_MaterialDocumentRecord | from |
Associations (4)
| Cardinality | Target | Alias | Condition |
|---|---|---|---|
| [1..1] | I_MaterialDocumentYear | _MaterialDocumentYear | $projection.MaterialDocumentYear = _MaterialDocumentYear.MaterialDocumentYear |
| [1..1] | I_MaterialDocumentHeader | _MaterialDocumentHeader | $projection.MaterialDocumentYear = _MaterialDocumentHeader.MaterialDocumentYear and $projection.MaterialDocument = _MaterialDocumentHeader.MaterialDocument |
| [0..1] | I_MaterialDocumentHeader | _ReversedMatDoc | $projection.ReversedMaterialDocumentYear = _ReversedMatDoc.MaterialDocumentYear and $projection.ReversedMaterialDocument = _ReversedMatDoc.MaterialDocument |
| [0..1] | I_MaterialDocumentItem | _ReversedMatDocItem | $projection.ReversedMaterialDocumentYear = _ReversedMatDocItem.MaterialDocumentYear and $projection.ReversedMaterialDocument = _ReversedMatDocItem.MaterialDocument and $projection.ReversedMaterialDocumentItem = _ReversedMatDocItem.MaterialDocumentItem |
Annotations (16)
| Name | Value | Level | Field |
|---|---|---|---|
| EndUserText.label | Material Document Item | view | |
| AccessControl.authorizationCheck | #CHECK | 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 | |
| VDM.lifecycle.status | #DEPRECATED | view | |
| VDM.lifecycle.successor | I_MaterialDocumentItem_2 | view | |
| Analytics.dataCategory | #DIMENSION | view | |
| Analytics.technicalName | IMATDOCITEM | view | |
| Metadata.ignorePropagatedAnnotations | true | view | |
| Metadata.allowExtensions | true | view |
Fields (120)
| Key | Field | Source Table | Source Field | Description |
|---|---|---|---|---|
| KEY | MaterialDocumentYear | MaterialDocumentYear | ||
| KEY | MaterialDocument | MaterialDocument | ||
| KEY | MaterialDocumentItem | MaterialDocumentItem | ||
| Material | Material | |||
| Plant | Plant | |||
| StorageLocation | StorageLocation | |||
| StorageType | StorageType | |||
| StorageBin | StorageBin | |||
| Batch | Batch | |||
| ShelfLifeExpirationDate | ShelfLifeExpirationDate | |||
| ManufactureDate | ManufactureDate | |||
| Supplier | Supplier | |||
| SalesOrder | SalesOrder | |||
| SalesOrderItem | SalesOrderItem | |||
| SalesOrderScheduleLine | SalesOrderScheduleLine | |||
| WBSElementInternalID | WBSElementInternalID | |||
| Customer | Customer | |||
| InventorySpecialStockType | InventorySpecialStockType | |||
| InventoryStockType | InventoryStockType | |||
| StockOwner | StockOwner | |||
| GoodsMovementType | GoodsMovementType | |||
| DebitCreditCode | DebitCreditCode | |||
| InventoryUsabilityCode | InventoryUsabilityCode | |||
| QuantityInBaseUnit | QuantityInBaseUnit | |||
| MaterialBaseUnit | MaterialBaseUnit | |||
| QuantityInEntryUnit | QuantityInEntryUnit | |||
| EntryUnit | EntryUnit | |||
| PostingDate | PostingDate | |||
| DocumentDate | DocumentDate | |||
| TotalGoodsMvtAmtInCCCrcy | TotalGoodsMvtAmtInCCCrcy | |||
| CompanyCodeCurrency | CompanyCodeCurrency | |||
| InventoryValuationType | InventoryValuationType | |||
| ReservationIsFinallyIssued | ReservationIsFinallyIssued | |||
| PurchaseOrder | PurchaseOrder | |||
| PurchaseOrderItem | PurchaseOrderItem | |||
| ProjectNetwork | ProjectNetwork | |||
| OrderID | OrderID | |||
| OrderItem | OrderItem | |||
| Reservation | Reservation | |||
| ReservationItem | ReservationItem | |||
| DeliveryDocument | DeliveryDocument | |||
| DeliveryDocumentItem | DeliveryDocumentItem | |||
| ReversedMaterialDocumentYear | ReversedMaterialDocumentYear | |||
| ReversedMaterialDocument | ReversedMaterialDocument | |||
| ReversedMaterialDocumentItem | ReversedMaterialDocumentItem | |||
| RvslOfGoodsReceiptIsAllowed | RvslOfGoodsReceiptIsAllowed | |||
| GoodsRecipientName | GoodsRecipientName | |||
| UnloadingPointName | UnloadingPointName | |||
| CostCenter | CostCenter | |||
| GLAccount | GLAccount | |||
| ServicePerformer | ServicePerformer | |||
| EmploymentInternalID | EmploymentInternalID | |||
| PersonWorkAgreement | PersonWorkAgreement | |||
| AccountAssignmentCategory | AccountAssignmentCategory | |||
| WorkItem | WorkItem | |||
| ServicesRenderedDate | ServicesRenderedDate | |||
| IssgOrRcvgMaterial | IssgOrRcvgMaterial | |||
| IssuingOrReceivingPlant | IssuingOrReceivingPlant | |||
| IssuingOrReceivingStorageLoc | IssuingOrReceivingStorageLoc | |||
| IssgOrRcvgBatch | IssgOrRcvgBatch | |||
| IssgOrRcvgSpclStockInd | IssgOrRcvgSpclStockInd | |||
| CompanyCode | CompanyCode | |||
| BusinessArea | BusinessArea | |||
| ControllingArea | ControllingArea | |||
| FiscalYearPeriod | FiscalYearPeriod | |||
| FiscalYearVariant | FiscalYearVariant | |||
| GoodsMovementRefDocType | GoodsMovementRefDocType | |||
| IsCompletelyDelivered | IsCompletelyDelivered | |||
| MaterialDocumentItemText | MaterialDocumentItemText | |||
| IsAutomaticallyCreated | IsAutomaticallyCreated | |||
| GoodsReceiptType | GoodsReceiptType | |||
| ConsumptionPosting | ConsumptionPosting | |||
| MultiAcctAssgmtOriglMatlDocItm | MultiAcctAssgmtOriglMatlDocItm | |||
| HasMultipleAccountAssignment | HasMultipleAccountAssignment | |||
| _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 | |||
| _Employment | _Employment | |||
| _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 |
@EndUserText.label: 'Material Document Item'
@AccessControl.authorizationCheck: #CHECK
@ObjectModel: {
usageType: {
sizeCategory: #XXL,
serviceQuality: #C,
dataClass:#TRANSACTIONAL
},
representativeKey: 'MaterialDocumentItem',
semanticKey: ['MaterialDocumentYear', 'MaterialDocument', 'MaterialDocumentItem'],
modelingPattern: #ANALYTICAL_DIMENSION,
supportedCapabilities: [#ANALYTICAL_DIMENSION, #CDS_MODELING_ASSOCIATION_TARGET, #SQL_DATA_SOURCE, #CDS_MODELING_DATA_SOURCE]
}
@Search.searchable: true
@VDM: {
viewType: #COMPOSITE,
lifecycle.contract.type: #PUBLIC_LOCAL_API,
lifecycle.status: #DEPRECATED,
lifecycle.successor: 'I_MaterialDocumentItem_2'
}
@Analytics.dataCategory: #DIMENSION
@Analytics.technicalName: 'IMATDOCITEM'
@Metadata: {
ignorePropagatedAnnotations: true,
allowExtensions: true
}
define view entity I_MaterialDocumentItem
as select from I_MaterialDocumentRecord
association [1..1] to I_MaterialDocumentYear as _MaterialDocumentYear on $projection.MaterialDocumentYear = _MaterialDocumentYear.MaterialDocumentYear
association [1..1] to I_MaterialDocumentHeader as _MaterialDocumentHeader on $projection.MaterialDocumentYear = _MaterialDocumentHeader.MaterialDocumentYear
and $projection.MaterialDocument = _MaterialDocumentHeader.MaterialDocument
association [0..1] to I_MaterialDocumentHeader as _ReversedMatDoc on $projection.ReversedMaterialDocumentYear = _ReversedMatDoc.MaterialDocumentYear
and $projection.ReversedMaterialDocument = _ReversedMatDoc.MaterialDocument
association [0..1] to I_MaterialDocumentItem as _ReversedMatDocItem on $projection.ReversedMaterialDocumentYear = _ReversedMatDocItem.MaterialDocumentYear
and $projection.ReversedMaterialDocument = _ReversedMatDocItem.MaterialDocument
and $projection.ReversedMaterialDocumentItem = _ReversedMatDocItem.MaterialDocumentItem
{
@ObjectModel.foreignKey.association: '_MaterialDocumentYear'
key MaterialDocumentYear,
@Search.defaultSearchElement: true
@Search.fuzzinessThreshold: 0.9
@Search.ranking: #HIGH
@ObjectModel.foreignKey.association: '_MaterialDocumentHeader'
key MaterialDocument,
key MaterialDocumentItem,
@Search.defaultSearchElement: true
@Search.fuzzinessThreshold: 0.7
@Search.ranking: #HIGH
Material,
@Search.defaultSearchElement: true
@Search.fuzzinessThreshold: 0.9
@Search.ranking: #HIGH
Plant,
@Search.defaultSearchElement: true
@Search.fuzzinessThreshold: 0.9
@Search.ranking: #HIGH
StorageLocation,
StorageType,
StorageBin,
@Search.defaultSearchElement: true
@Search.fuzzinessThreshold: 0.8
@Search.ranking: #MEDIUM
Batch,
ShelfLifeExpirationDate,
ManufactureDate,
@Search.defaultSearchElement: true
@Search.fuzzinessThreshold: 0.8
@Search.ranking: #MEDIUM
Supplier,
@Search.defaultSearchElement: true
@Search.fuzzinessThreshold: 0.9
@Search.ranking: #MEDIUM
SalesOrder,
SalesOrderItem,
SalesOrderScheduleLine,
@Search.defaultSearchElement: true
@Search.fuzzinessThreshold: 0.9
@Search.ranking: #MEDIUM
WBSElementInternalID,
@Search.defaultSearchElement: true
@Search.fuzzinessThreshold: 0.8
@Search.ranking: #MEDIUM
Customer,
InventorySpecialStockType,
InventoryStockType,
@Search.defaultSearchElement: true
@Search.fuzzinessThreshold: 0.8
@Search.ranking: #MEDIUM
StockOwner,
GoodsMovementType,
DebitCreditCode,
InventoryUsabilityCode,
@Semantics.quantity.unitOfMeasure: 'MaterialBaseUnit'
@DefaultAggregation: #SUM
QuantityInBaseUnit,
MaterialBaseUnit,
@Semantics.quantity.unitOfMeasure: 'EntryUnit'
@DefaultAggregation: #SUM
QuantityInEntryUnit,
EntryUnit,
@Semantics.businessDate.at: true
PostingDate,
@Semantics.businessDate.at: true
DocumentDate,
@Semantics.amount.currencyCode: 'CompanyCodeCurrency'
@DefaultAggregation: #SUM
TotalGoodsMvtAmtInCCCrcy,
CompanyCodeCurrency,
InventoryValuationType,
ReservationIsFinallyIssued,
@Search.defaultSearchElement: true
@Search.fuzzinessThreshold: 0.9
@Search.ranking: #MEDIUM
PurchaseOrder,
PurchaseOrderItem,
@Search.defaultSearchElement: true
@Search.fuzzinessThreshold: 0.9
@Search.ranking: #MEDIUM
ProjectNetwork,
@Search.defaultSearchElement: true
@Search.fuzzinessThreshold: 0.9
@Search.ranking: #MEDIUM
OrderID,
OrderItem,
@Search.defaultSearchElement: true
@Search.fuzzinessThreshold: 0.9
@Search.ranking: #MEDIUM
Reservation,
ReservationItem,
@Search.defaultSearchElement: true
@Search.fuzzinessThreshold: 0.9
@Search.ranking: #MEDIUM
DeliveryDocument,
DeliveryDocumentItem,
ReversedMaterialDocumentYear,
@Search.defaultSearchElement: true
@Search.fuzzinessThreshold: 0.9
@Search.ranking: #MEDIUM
ReversedMaterialDocument,
ReversedMaterialDocumentItem,
RvslOfGoodsReceiptIsAllowed,
@Search.defaultSearchElement: true
@Search.fuzzinessThreshold: 0.7
@Search.ranking: #MEDIUM
GoodsRecipientName,
@Search.defaultSearchElement: true
@Search.fuzzinessThreshold: 0.7
@Search.ranking: #MEDIUM
UnloadingPointName,
CostCenter,
GLAccount,
ServicePerformer,
@VDM.lifecycle.status: #DEPRECATED
@VDM.lifecycle.successor: 'PersonWorkAgreement'
EmploymentInternalID,
PersonWorkAgreement,
AccountAssignmentCategory,
WorkItem,
ServicesRenderedDate,
IssgOrRcvgMaterial,
IssuingOrReceivingPlant,
IssuingOrReceivingStorageLoc,
IssgOrRcvgBatch,
IssgOrRcvgSpclStockInd,
CompanyCode,
BusinessArea,
ControllingArea,
@Semantics.fiscal.yearPeriod: true
FiscalYearPeriod,
@Semantics.fiscal.yearVariant: true
FiscalYearVariant,
GoodsMovementRefDocType,
IsCompletelyDelivered,
MaterialDocumentItemText,
IsAutomaticallyCreated,
@Consumption.hidden: true
GoodsReceiptType,
@Consumption.hidden: true
ConsumptionPosting,
@Consumption.hidden: true
MultiAcctAssgmtOriglMatlDocItm,
@Consumption.hidden: true
HasMultipleAccountAssignment,
_MaterialDocumentYear,
@ObjectModel.association.type:[#TO_COMPOSITION_ROOT, #TO_COMPOSITION_PARENT]
_MaterialDocumentHeader,
_Material,
_IssgOrRcvgMaterial,
//search model
_Plant,
_IssuingOrReceivingPlant,
_StorageLocation,
_IssuingOrReceivingStorageLoc,
_Supplier,
_Customer,
@Consumption.hidden: true
_SupplierCompanyByPlant,
@Consumption.hidden: true
_CustomerCompanyByPlant,
_BPStockOwner,
_InventorySpecialStockType,
_IssgOrRcvgSpclStockInd,
_InventoryStockType,
_InventoryValuationType,
_GoodsMovementType,
_DebitCreditCode,
@API.element.releaseState: #DEPRECATED
@API.element.successor: '_StockType_2'
@VDM.lifecycle.status: #DEPRECATED
@VDM.lifecycle.successor: '_StockType_2'
_StockType,
_StockType_2,
_MaterialBaseUnit,
_EntryUnit,
_GLAccount,
_CostCenter,
_BusinessPartner,
@VDM.lifecycle.status: #DEPRECATED
@VDM.lifecycle.successor: '_PersonWorkAgreement'
_Employment,
_PersonWorkAgreement,
_AccountAssignmentCategory,
_WorkItem,
_CompanyCode,
_BusinessArea,
_ControllingArea,
_SalesOrder,
_SalesOrderItem,
_SalesOrderScheduleLine,
_WBSElement,
_PurchaseOrder,
_PurchaseOrderItem,
_ProjectNetwork,
_LogisticsOrder,
_DeliveryDocument,
_DeliveryDocumentItem,
_ReversedMatDoc,
_ReversedMatDocItem,
_GoodsMvtTypeBySpclStkIndT
}
where
MaterialDocumentRecordType = 'MDOC'
Learn More
- What Is a CDS View in SAP S/4HANA?
- Types of CDS Views: Basic, Composite, Consumption, and Transactional
- SAP Tables vs CDS Views — Key Differences
- Understanding Data Lineage in SAP S/4HANA
- VDM (Virtual Data Model) in SAP S/4HANA Explained
- CDS View Annotations — A Complete Guide
- CDS View Field Mapping and Associations
- Understanding the SAP S/4HANA Data Model
- CDS View Extensions and Custom Fields in SAP S/4HANA
- Released APIs and Stability Contracts in SAP S/4HANA