Fb_Mmim_Matstockquanvalbydat3

Material Stock Quantity and Value by Key Date | view: FBMMIM_MATSTVAL3 | Extraction: Not supported | Component: Inventory Management
Tables used: MATDOCT001TKA02T001W
Column Name Description
Material Material in Respect of Which Stock is Managed
Plant Plant
StorageLocation Storage location
ResourceId Resource
Batch Batch Number
Supplier Supplier
SDDocument Sales order number of valuated sales order stock
SDDocumentItem Sales Order Item of Valuated Sales Order Stock
WBSElementInternalID Valuated Sales Order Stock WBS Element
Customer Customer Number
InventoryStockType Stock Type of Goods Movement (Stock Identifier) Show values
InventorySpecialStockType Special Stock Indicator
CompanyCode Company Code
CostEstimate Cost Estimate Number - Product Costing
ValuationArea FK Valuation area
InventoryValuationType Valuation Type
IsSupplierStockValuation Vendor Stock Valuation Indicator Show values
InventorySpecialStockValnType Valuation of Special Stock Show values
Currency FK Currency Key
MaterialBaseUnit Base Unit of Measure
Column Name Description
Column Name Description
📏 Base Unit of Measure (MaterialBaseUnit):
MatlWrhsStkQtyInMatlBaseUnit null
Column Name Description
Column Name Description
InventoryStockType Stock Type of Goods Movement (Stock Identifier) Show values
IsSupplierStockValuation Vendor Stock Valuation Indicator Show values
InventorySpecialStockValnType Valuation of Special Stock Show values
Column Name Description Domain name
Master Data Relations Join Conditions
Currency Key
  • Currency Key
  • Client
  • FB_MMIM_MATSTOCKQUANVALBYDAT3.CURRENCY == TCURC.WAERS
  • FB_MMIM_MATSTOCKQUANVALBYDAT3.MANDT == TCURC.MANDT
Valuation area
  • Valuation area
  • Client
  • FB_MMIM_MATSTOCKQUANVALBYDAT3.VALUATIONAREA == T001K.BWKEY
  • FB_MMIM_MATSTOCKQUANVALBYDAT3.MANDT == T001K.MANDT