I_DeadStockMaterialCube

Dead Stock Material | view: IDEADSTOCKMATQ | TRAN | Extraction: Not supported | Component: Basic Functions
Column Name Description
Material Material in Respect of Which Stock is Managed
Plant Plant
StorageLocation Storage location
MaterialBaseUnit Base Unit of Measure
StockIdentifyingBatch Batch Number (Stock Identifier)
SpecialStockIdfgSupplier Supplier for Special Stock
SpecialStockIdfgSalesOrder Sales order number of valuated sales order stock
SpecialStockIdfgSalesOrderItem Sales Order Item of Valuated Sales Order Stock
SpecialStockIdfgWBSElement Valuated Sales Order Stock WBS Element
SpecialStockIdfgCustomer Customer for Special Stock
SpecialStockIdfgStockOwner Add. Supplier for Special Stock
InventorySpecialStockType Special Stock Type
InventoryStockType Stock Type of Goods Movement (Stock Identifier) Show values
ValuationAreaType Valuation area setting Show values
Column Name Description
💲 null (Currency):
StockValueInCCCrcyStart Stock Value in Company Code Currency (Start Period)
StockValueInCCCrcyEnd Stock Value in Company Code Currency (End Period)
StockValueIncrInCCCrcy Stock Value Increase in Company Code Currency
💲 Display Currency (DisplayCurrency):
StockValueIncrInDisplayCrcy Stock Value Increase in Display Currency
StockValueInDisplayCurrencyEnd Stock Value in Display Currency (End Period)
StockValueInDisplayCrcyStart Stock Value in Display Currency (Start Period)
Column Name Description
📏 Base Unit of Measure (MaterialBaseUnit):
MatlWrhsStkQtyOnStartDate Stock Quantity in Base Unit of Measure (Start Period)
MatlWrhsStkQtyOnEndDate Stock Quantity in Base Unit of Measure (End Period)
SafetyStockQtyInMatlBaseUnit Safety Stock
Column Name Description
CnsmpnLatestPostgDate Date of Last Consumption Posting
MatlDocLatestPostgDate Date of Last Posting
Column Name Description
InventoryStockType Stock Type of Goods Movement (Stock Identifier) Show values
ValuationAreaType Valuation area setting Show values
Column Name Description Domain name
NumberOfDaysSinceLastCnsmpn Number of Days Since Last Consumption Posting
NumberOfDaysSinceLastMovement Number of Days Since Last Posting
MaterialGroupName Material Group Description TEXT20
MaterialTypeName Description of Material Type TEXT25
MaterialName Material Description TEXT40
PlantName Plant Name TEXT30
Master Data Relations Join Conditions
Material Group
  • Client
  • Material Group
  • I_DEADSTOCKMATERIALCUBE.MANDT == T023.MANDT
  • I_DEADSTOCKMATERIALCUBE.MATERIALGROUP == T023.MATKL
Material type
  • Client
  • Material type
  • I_DEADSTOCKMATERIALCUBE.MANDT == T134.MANDT
  • I_DEADSTOCKMATERIALCUBE.MATERIALTYPE == T134.MTART