F1_Mmim_Matstockquanvalbydat3

Material Stock Quantity and Value by Key Date | view: F1MMIM_MATSTVAL3 | Extraction: Not supported | Component: Inventory Management
Column Name Description
Column Name Description
💲 Currency Key (Currency):
CurrentStockValue Current Stock Currency Value
QualityInspectionStockValue Quality Inspection Stock Currency Value
ReturnsBlockedStockValue Returns Blocked Stock Currency Value
TransferStockStorageLocValue Transfer Stock Storage Location Currency Value
TransferStockPlantValue Transfer Stock Plant Currency Value
StockInTransitValue Stock in Transit Currency Value
BlockedStockValue Blocked Stock Currency Value
RestrictedStockValue Restricted Stock Currency Value
TiedEmptiesStockValue Tied Empties Stock Currency Value
GoodsReceiptBlockedStockValue Goods Receipt Blocked Stock Currency Value
CurrentStockCurVal Current Stock Currency Value
QualityInspectionStockCurVal Quality Inspection Stock Currency Value
ReturnsBlockedStockCurVal Returns Blocked Stock Currency Value
TransferStockStorageLocCurVal Transfer Stock Storage Location Currency Value
TransferStockPlantCurVal Transfer Stock Plant Currency Value
StockInTransitCurVal Stock in Transit Currency Value
BlockedStockCurVal Blocked Stock Currency Value
RestrictedStockCurVal Restricted Stock Currency Value
TiedEmptiesStockCurVal Tied Empties Stock Currency Value
GoodsReceiptBlockedStockCurVal Goods Receipt Blocked Stock Currency Value
Column Name Description
Column Name Description
Column Name Description
Column Name Description Domain name
SourceConstantId General Field with Length 2, for Function Modules CHAR2
Material Material in Respect of Which Stock is Managed MATNR
Plant Plant WERKS
StorageLocation Storage location LGORT
ResourceId Resource NSDM_RESOURCENAME
Batch Batch Number CHARG
Supplier Supplier LIFNR
SDDocument Sales order number of valuated sales order stock VBELN
SDDocumentItem Sales Order Item of Valuated Sales Order Stock NUM06
WBSElementInternalID Valuated Sales Order Stock WBS Element PS_POSNR
Customer Customer Number KUNNR
InventorySpecialStockType Special Stock Indicator SOBKZ
CompanyCode Company Code BUKRS
InventoryValuationType Valuation Type BWTAR
CurrentStock null
QualityInspectionStockQuantity null
ReturnsBlockedStockQuantity null
TransferStockStorageLocQty null
TransferStockPlantQuantity null
StockInTransitQuantity null
BlockedStockQuantity null
RestrictedStockQuantity null
TiedEmptiesStockQuantity null
GoodsReceiptBlockedStockQty null
Master Data Relations Join Conditions
Currency Key
  • Client
  • Currency Key
  • F1_MMIM_MATSTOCKQUANVALBYDAT3.MANDT == TCURC.MANDT
  • F1_MMIM_MATSTOCKQUANVALBYDAT3.CURRENCY == TCURC.WAERS