- Application Platform (AP)
- Basis Components (BC)
- Business Mobile (MOB)
- Business Network Solutions (BNS)
- Controlling (CO)
- Cross-Application Components (CA)
- Cross-Application Components (CA)
- Customer Relationship Management (CRM)
- Enterprise Contract Management (CM)
- Enterprise Controlling (EC)
- Enterprise information management solutions (EIM)
- Environment, Health, and Safety / Product Compliance (EHS)
- Financial Accounting (FI)
- Financial Services (FS)
- Global Trade Services (SLL)
- Investment Management (IM)
- LOD Components (LOD)
- Legal Content Management (LCM)
- Logistics - General (LO)
- Logistics Execution (LE)
- Materials Management (MM)
- Occasional Platform User (OPU)
- Payroll (PY)
- Personnel Management (PA)
- Plant Maintenance (PM)
- Portfolio and Project Management (PPM)
- Product Lifecycle Management (PLM)
- Production Planning and Control (PP)
- Project System (PS)
- Public Sector Management (PSM)
- Purchasing SAP Cloud (PUR)
- Quality Management (QM)
- Real Estate Management (RE)
- SAP Business Warehouse (BW)
- SAP Supplier Lifecycle Management (SLC)
- Sales and Distribution (SD)
- Service (SV)
- Supply Chain Management (SCM)
- Sustainability management (SUS)
- Transportation Management (TM)
F0_Mmim_Matstockquanvalbydate
Material Stock Quantity and Value by Key Date
| view: F0MMIM_MATSTVAL
| Extraction:
Not supported
| Component: Inventory Management
Tables used:
MATDOC, MATDOC, CKMLCR, FMLT_PRICE, CKMLCR, MATDOC_EXTRACT, ACDOCA, FMLT_PRICE, CKMLCR, CKMLCR, ACDOCA_M_EXTRACT, MARA, KNA1, LFA1, T001, T001K, T001W, MARC, MARC, MARD, MARA, MBEW, T001K, T001W, MARC, MCHA, MARC, MCHA, MCHB, MCH1, MCHA, T001, TKA02, TCURC, TCURX, TCURT, T148, T148T, FINSC_LEDGER, FINSC_LEDGER_T, CKMLHD, T001W, MARA, T023, T023T, MAKT, T001K, T001L, PRPS, EBEW, MBEW, MBEW, MBEW, OBEW, QBEW, MARD, MARC, FINSC_CURTYPE, FINSC_CURTYPET, FINSC_LEDGER, CKMLHD, CKMLHD, T001, T001K, FMLT_CURTP_ML, TCUCH, FINSC_ACTVE_APPL, FINSC_LEDGER_REP, FMLC_TOGGLE, FMLT_CURTP_ML, FINSC_LD_CMP, FINSC_PERIOD
| Column Name | Description | |
|---|---|---|
| SourceConstantId | General Field with Length 2, for Function Modules | |
| 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 | |
| InventorySpecialStockType | Special Stock Indicator | |
| CompanyCode | Company Code | |
| MaterialBaseUnit | Base Unit of Measure | |
| Currency FK | Currency Key | |
| DisplayCurrency | Display Currency | |
| InventoryValuationType | Valuation Type | |
| ValuationAreaType | Valuation area setting | Show values |
| Column Name | Description | |
|---|---|---|
| 💲 Currency Key (Currency): | ||
| CurrentStockValue | null | |
| QualityInspectionStockValue | null | |
| ReturnsBlockedStockValue | null | |
| TransferStockStorageLocValue | null | |
| TransferStockPlantValue | null | |
| StockInTransitValue | null | |
| BlockedStockValue | null | |
| RestrictedStockValue | null | |
| TiedEmptiesStockValue | null | |
| GoodsReceiptBlockedStockValue | null | |
| CurrentStockCurVal | null | |
| QualityInspectionStockCurVal | null | |
| ReturnsBlockedStockCurVal | null | |
| TransferStockStorageLocCurVal | null | |
| TransferStockPlantCurVal | null | |
| StockInTransitCurVal | null | |
| BlockedStockCurVal | null | |
| RestrictedStockCurVal | null | |
| TiedEmptiesStockCurVal | null | |
| GoodsReceiptBlockedStockCurVal | null | |
| 💲 Display Currency (DisplayCurrency): | ||
| CurrentStockValueInDC | Current Stock Currency Value in Display Currency | |
| QualityInspStockValueInDC | Quality Inspection Stock Currency Value in Display Currency | |
| ReturnsBlockedStockValueInDC | Returns Blocked Stock Currency Value in Display Currency | |
| TransferStockStorLocValueInDC | Transfer Stock Storage Location Currency Value in Disp. Cur. | |
| TransferStockPlantValueInDC | Transfer Stock Plant Currency Value in Display Currency | |
| StockInTransitValueInDC | Stock in Transit Currency Value in Display Currency | |
| BlockedStockValueInDC | Blocked Stock Currency Value in Display Currency | |
| RestrictedStockValueInDC | Restricted Stock Currency Value in Display Currency | |
| TiedEmptiesStockValueInDC | Tied Empties Stock Currency Value in Display Currency | |
| GRBlockedStockValueInDC | Goods Receipt Blocked Stock Currency Value in Display Cur. | |
| CurrentStockCurValInDC | Current Stock Currency Value in Display Currency | |
| QualityInspStockCurValInDC | Quality Inspection Stock Currency Value in Display Currency | |
| ReturnsBlockedStockCurValInDC | Returns Blocked Stock Currency Value in Display Currency | |
| TransferStockStorLocCurValInDC | Transfer Stock Storage Location Currency Value in Disp. Cur. | |
| TransferStockPlantCurValInDC | Transfer Stock Plant Currency Value in Display Currency | |
| StockInTransitCurValInDC | Stock in Transit Currency Value in Display Currency | |
| BlockedStockCurValInDC | Blocked Stock Currency Value in Display Currency | |
| RestrictedStockCurValInDC | Restricted Stock Currency Value in Display Currency | |
| TiedEmptiesStockCurValInDC | Tied Empties Stock Currency Value in Display Currency | |
| GRBlockedStockCurValInDC | Goods Receipt Blocked Stock Currency Value in Display Cur. | |
| Column Name | Description |
|---|
| Column Name | Description | |
|---|---|---|
| ShelfLifeExpirationDate | Shelf Life Expiration or Best-Before Date | |
| ManufactureDate | Date of Manufacture |
| Column Name | Description | |
|---|---|---|
| ValuationAreaType | Valuation area setting | Show values |
| MaterialIsMarkedForDeletion | Deletion Indicator | Show values |
| Column Name | Description | Domain name | |
|---|---|---|---|
| WBSElementExternalID | Work Breakdown Structure Element (WBS Element) Edited | PS_POSID_EDIT | |
| SegmentIsEmpty | null | ||
| WarehouseStorageBin | Storage Bin | CHAR10 | |
| MaterialName | Product Description | TEXT40 | |
| MaterialGroupName | Product Group Description | TEXT20 | |
| PlantName | Plant Name | TEXT30 | |
| StorageLocationName | Storage Location Name | TEXT16 | |
| InventorySpecialStockTypeName | Description of special stock | TEXT20 | |
| CustomerName | Name 1 | NAME | |
| SupplierName | Name 1 | NAME | |
| WBSDescription | WBS Element Name | TEXT40 | |
| CurrentStock | null | ||
| QualityInspectionStockQuantity | null | ||
| ReturnsBlockedStockQuantity | null | ||
| TransferStockStorageLocQty | null | ||
| TransferStockPlantQuantity | null | ||
| StockInTransitQuantity | null | ||
| BlockedStockQuantity | null | ||
| RestrictedStockQuantity | null | ||
| TiedEmptiesStockQuantity | null | ||
| GoodsReceiptBlockedStockQty | null | ||
| ProductCharacteristic1 | Characteristic Value for Colors of Variants | WRF_ATWRT | |
| ProductCharacteristic2 | Characteristic Value for Main Sizes of Variants | WRF_ATWRT | |
| ProductCharacteristic3 | Characteristic Value for Second Size for Variants | WRF_ATWRT | |
| StockSegment | Stock Segment | SGT_SRCA |
| Master Data Relations | Join Conditions |
|---|---|
Cross-Plant Configurable Product
| |
Currency Key
| |
Material Group
|