Materials Management MM

Top Tables for the Materials Management Module MM in SAP©
View table content with transaction SE16, SE16N or SE16H (with HANA-Database) and tablestructure with SE11


TableTable - NameS/4HANA -Table and general Notes
MAEX Material Master: Legal Control
MAKT Material Descriptions In Logical Databases MMIMRKPFRESB S1L S2L. Field ‘Material description in upper case’ (MAKTG) for the search.
MAKV Material Cost Distribution
MAKZ Material cost distribution equivalence numbers
MAPEMaterial Master: Export Control File
MAPL Assignment of Task Lists to Materials In Logical Databases PNM PNM_OLD.
MARC Plant Data for Material In Logical Databases /SAPSLL/CUSMSM S1L.
MARD Storage Location Data for Material In Logical Databases /SAPSLL/CUSMSM MSM.
MARM Units of Measure for Material In Logical Database MSM.
MARV Material Control Record Current MM-Period
MAST Material to BOM Link In Logical Databases CKA CSR.
MBEW Material Valuation In Logical Databases /SAPSLL/CUSMSM BMM CKA.
MDFD MRP firming date
MDIPMaterial: MRP Profiles (Field Contents)
MKAL Production Versions of Material
MLAN Tax Classification for Material
MLGN Material Data for Each Warehouse Number In Logical Databases MSM S1L.
MLGT Material Data for Each Storage Type In Logical Database MSM.
MPGD_MASS Planning Data
MPOP Forecast Parameters
MSPR Project Stock
MSSA Total Customer Orders on Hand
MSSL Total Special Stocks with Vendor
MVER Material Consumption
MVKE Sales Data for Material In Logical Database MSM.
PROP Forecast parameters
QMAT Inspection type - material parameters
STXH STXD SAPscript text file header In Logical Databases AAV AKV ALV ARV BBM ERM ILM.
STXL STXD SAPscript text file lines In Logical Databases AAV AKV ALV ARV BBM ERM ILM.
T179 Materials: Product Hierarchies


TableTable - NameS/4HANA -Table and general Notes
CHVW Table CHVW for Batch Where-Used List
MCH1 Batches (if Batch Management Cross-Plant)
MCHA Batches
MCHB Batch Stocks In Logical Databases /SAPSLL/CUSMSM MSM.

Dispatch data    

TableTable - NameS/4HANA -Table and general Notes
DBVMPlanning File Entry, MRP Area
DVERMaterial Consumption for MRP Area
MAPR Material Index for Forecast
MDMAMRP Area for Material


TableTable - NameS/4HANA -Table and general Notes
MOFFOutstanding Material Master Records
MSTAMaterial Master Status

Historical data    

TableTable - NameS/4HANA -Table and general Notes
MARCHMaterial Master C Segment: History
MARDHMaterial Master Storage Location Segment: History
MBEWHMaterial Valuation: History
MCHBHBatch Stocks: History
MKOLHSpecial Stocks from Vendor: History
MSCAHSales Order Stock at Vendor: History
MSKAHSales Order Stock: History
MSKUHSpecial Stocks at Customer: History
MSLBHSpecial Stocks at Vendor: History
MSPRHProject Stock: History
MSSAHTotal Sales Order Stocks: History
MSSQHTotal Project Stocks: History

Material Ledger    Mandatory in S/4

TableTable - NameS/4HANA -Table and general Notes
CKMLCRMaterial Ledger: Period Totals Records Values
CKMLKEPHMaterial Ledger: Cost Component Split (Elements)
CKMLPPMaterial Ledger Period Totals Records Quantity
CKMLPPWIPMaterial-Ledger: Period Records WIP (Quantities)
MLCDMaterial Ledger: Summarization Record (from Documents)
MLCRMaterial Ledger Document: Currencies and Values
MLCRFMaterial Ledger Document: Field Groups (Currencies)
MLHDMaterial Ledger Document: Header
MLITMaterial Ledger Document: Items
MLPPMaterial Ledger Document: Posting Periods and Quantities
MLPPFMaterial Ledger Document: Field Groups (Posting Periods)

Material documents    

TableTable - NameS/4HANA -Table and general Notes
MKPF Header: Material Document In Logical Databases BMM LMM LNM MRM PGQ.
MSEG Document Segment: Material In Logical Databases BMM L1M LMM LNM MRM PGQ.

Material documents in S/4    

TableTable - NameS/4HANA -Table and general Notes
MLDOCMaterial Ledger Document
MLDOCCCSMaterial Ledger Document Cost Component Split


TableTable - NameS/4HANA -Table and general Notes
IKPFHeader: Physical Inventory Document
ISEGPhysical Inventory Document Items


TableTable - NameS/4HANA -Table and general Notes
RESB Reservation/dependent requirements In Logical Databases BBM ERM MEPOLDB MMIMRKPFRESB ODC OFC OHC OPC POH RMM RNM.
RKPF Document Header: Reservation In Logical Databases MMIMRKPFRESB RKM RNM.

Enterprise Structure    Part of the Customizing

TableTable - NameS/4HANA -Table and general Notes
T001KValuation area
T001LStorage Locations
T001W Plants/Branches
T024Purchasing Groups
T024EPurchasing Organizations
T024WValid Purchasing Organizations for Plant
T024ZPurchasing Organizations
TSPAOrganizational Unit: Sales Divisions


TableTable - NameS/4HANA -Table and general Notes
MDLGCustomizing: MRP Area Storage Location
MDLLCustomizing: MRP Area Subcontractor
MDLVCustomizing MRP Area
MDLWCustomizing: MRP Area Plants
NRIV Number Range Intervals Object=MATERIALNR for materials
T025T Valuation Class Descriptions
T030 Standard Accounts Table FI-Accounting determination in MM. Edit with transaction OBYC or OMWB
T137Industries for materials
T156Movement Type
T156MPosting String: Quantity
T156SYMvt Type: Qty/Value Update: System Table; Rel. 4.6A
T156TMovement Type Text
T156WPosting string values
T157HHelp Texts for Movement Types

Additional tables for the following modules:

FI    FI-GL    FI-AR    FI-AP    FI-BL    FI-AA    CO    CO-OM-CEL    CO-OM-CCA    CO-OM-OPA    CO-PC    RE-FX    RE-FX-LA     SD    MM-PUR    QM    PM    PP    PP-PI    PS    PA    

Book recommendations    

Logistics with SAP S/4HANA