C_DeadStockMaterialQry

Dead Stock Material Query | view: CDEADSTOCKMATQ | TRAN | Extraction: Not supported | Component: Basic Functions
Column Name Description
Material Material Number
Plant Plant
StorageLocation Storage location
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
MaterialBaseUnit Base Unit of Measure
ValuationAreaType Valuation area setting Show values
Column Name Description
💲 Currency Key (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):
StockValueInDisplayCrcyStart Stock Value in Display Currency (Start Period)
StockValueInDisplayCurrencyEnd Stock Value in Display Currency (End Period)
StockValueIncrInDisplayCrcy Stock Value Increase in Display Currency
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
WBSElementExternalID Work Breakdown Structure Element (WBS Element) Edited PS_POSID_EDIT
WBSDescription WBS Element Name TEXT40
NumberOfDaysSinceLastCnsmpn Number of Days Since Last Consumption Posting
NumberOfDaysSinceLastMovement Number of Days Since Last Posting
AnalysisRelevanceFactor null
MaterialGroupName Material Group Description TEXT20
MaterialTypeName Description of Material Type TEXT25
MaterialName Material Description TEXT40
PlantName Plant Name TEXT30
StorageLocationName Storage Location Name TEXT16
Master Data Relations Join Conditions
Material Group
  • Material Group
  • Client
  • C_DEADSTOCKMATERIALQRY.MATERIALGROUP == T023.MATKL
  • C_DEADSTOCKMATERIALQRY.MANDT == T023.MANDT
Material type
  • Client
  • Material type
  • C_DEADSTOCKMATERIALQRY.MANDT == T134.MANDT
  • C_DEADSTOCKMATERIALQRY.MATERIALTYPE == T134.MTART