Materials Management MM

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





General    

TableTable - NameS/4HANA -Table and general Notes
MAEX Material Master: Legal Control
MAKT Material Descriptions Field ‘Material description in upper case’ (MAKTG) for the search. In Logical Database MMIMRKPFRESB S1L S2L.
MAKV Material Cost Distribution
MAKZ Material cost distribution equivalence numbers
MAPEMaterial Master: Export Control File
MAPL Assignment of Task Lists to Materials In Logical Database PNM PNM_OLD.
MARA General Material Data In Logical Database /SAPSLL/CUSMSM BAM BKM BMM CKM EBM ECM ENM ESM IFM S1L WTY.
MARC Plant Data for Material S/4: Master data without stock aggregates. In Logical Database /SAPSLL/CUSMSM S1L.
MARD Storage Location Data for Material S/4: Master data without stock aggregates. In Logical Database /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 Database CKA CSR.
MBEW Material Valuation In Logical Database /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 Database 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 Inspection type.
STXH STXD SAPscript text file header In Logical Database AAV AKV ALV ARV BBM ERM ILM.
STXL STXD SAPscript text file lines In Logical Database AAV AKV ALV ARV BBM ERM ILM.
T179 Materials: Product Hierarchies

Inventory    

TableTable - NameS/4HANA -Table and general Notes
MCHB Batch Stocks In Logical Database /SAPSLL/CUSMSM MSM.
MKOL Special Stocks from Vendor In Logical Database MSM.
MSKASales Order Stock
MSKUSpecial Stocks with Customer
MSLBSpecial Stocks with Supplier
MSPR Project Stock
MSSA Total Customer Orders on Hand
MSSQProject Stock Total
MSTBStock in Transit
MSTEStock in Transit to Sales and Distribution Document
MSTQStock in Transit for Project

Production    

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 Database /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

Status    

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
MSTBHStock in Transit - History
MSTEHSiT to Sales and Distribution Document - History
MSTQHStock in Transit for Project - 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 Database BMM LMM LNM MRM PGQ.
MSEG Document Segment: Material In Logical Database BMM L1M LMM LNM MRM PGQ.

New Material documents - tables in S/4    

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

Inventory    

TableTable - NameS/4HANA -Table and general Notes
IKPFHeader: Physical Inventory DocumentIn Logical Database IMM INM IRM.
ISEGPhysical Inventory Document ItemsIn Logical Database IMM INM IRM.

Reservation    

TableTable - NameS/4HANA -Table and general Notes
RESB Reservation/dependent requirements In Logical Database BBM ERM MEPOLDB MMIMRKPFRESB ODC OFC OHC OPC POH RMM RNM.
RKPF Document Header: Reservation In Logical Database 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
T499SLocation
TSPAOrganizational Unit: Sales Divisions

Customizing    

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 Edit with transaction SNUM. Object=MATERIALNR for materials
T025T Valuation Class Descriptions
T030 Standard Accounts Table FI-Accounting determination in MM. Edit with transaction OBYC or OMWB.
T030HAcct Determ.for Open Item Exch.Rate Differences
T137Industries for materials
T156Movement Type
T156MPosting String: Quantity
T156SYMvt Type: Qty/Value Update: System Table; Rel. 4.6A
T156TMovement Type TextIn Logical Database MMIMRKPFRESB.
T156WPosting string values
T157HHelp Texts for Movement Types

Report a missing table...


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          EC-PCA          RE-FX          RE-FX-LA           SD          MM-PUR          QM          PM          PP          PP-PI          PS          PA          ABAP          Basis          Cross Module          Business Partner