If you work in SAP Materials Management, you constantly need to know which table stores what — for reports, debugging, data extraction, and interviews. This guide lists all the important SAP MM tables, grouped by business process, with descriptions and key fields.
Material Master Tables
The material master is the central record for every material. Data is split across views, each stored in its own table.
| Table | Description |
|---|---|
| MARA | General material data (material type, group, base UoM) |
| MAKT | Material descriptions (language-dependent) |
| MARC | Plant data for material (MRP, procurement type) |
| MARD | Storage location stock data |
| MARM | Units of measure and conversions |
| MBEW | Material valuation (price, price control) |
| MCHA | Batch master header |
| MCHB | Batch stocks per storage location |
| MLGN | Warehouse management stock per storage type |
| MLGT | Storage type data for material |
| MVKE | Sales data for material |
| MLAN | Tax classification for material |
| MAST | Material-to-BOM link |
Key fields: MATNR (material number), WERKS (plant), LGORT (storage location), BWKEY (valuation area).
Also Read: Profit Center Table in SAP
Vendor Master Tables
| Table | Description |
|---|---|
| LFA1 | Vendor general data (name, address) |
| LFB1 | Vendor company code data (payment terms, reconciliation account) |
| LFM1 | Vendor purchasing organization data |
Key fields: LIFNR (vendor number), BUKRS (company code), EKORG (purchasing organization).
Purchasing Tables
Purchasing documents flow: Purchase Requisition → Purchase Order → Goods Receipt → Invoice.
| Table | Description |
|---|---|
| EBAN | Purchase requisition header/item data |
| EBKN | PR account assignment |
| EKKO | Purchase order header |
| EKPO | Purchase order line items |
| EKKN | PO account assignment |
| EKET | Schedule lines (delivery dates/quantities) |
| EKBE | PO history (goods receipts + invoices per PO) |
| EKES | Vendor confirmations |
| EORD | Purchasing source list |
Key fields: EBELN (PO number), EBELP (PO item), BANFN (PR number), MATNR, MENGE (quantity), NETPR (net price).
Example: find all open POs for a material:
SELECT EBELN, EBELP, MATNR, MENGE
FROM EKPO
WHERE MATNR = '100-100'
AND ELIKZ = '';Purchasing Info Record Tables
| Table | Description |
|---|---|
| EINA | Info record general data (per material/vendor) |
| EINE | Info record purchasing organization data (prices, conditions) |
Inventory Management Tables
| Table | Description |
|---|---|
| MKPF | Material document header |
| MSEG | Material document line items |
| RESB | Reservations (dependent requirements) |
| RKPF | Reservation header |
Key fields: MBLNR (material document), MJAHR (year), BWART (movement type — e.g. 101 goods receipt, 261 goods issue, 311 transfer posting).
Example: stock movements for a plant in a month:
SELECT MBLNR, BWART, MATNR, MENGE
FROM MSEG
WHERE WERKS = '1000'
AND BUDAT_MKPF BETWEEN '20260101' AND '20260131';Invoice Verification Tables
| Table | Description |
|---|---|
| RBKP | Invoice document header |
| RSEG | Invoice document line items |
Posted via MIRO; matched against EKBE (PO history) during GR/IR clearing.
Important SAP MM TCodes
| TCode | Description |
|---|---|
| MM01 / MM02 / MM03 | Create / Change / Display material master |
| XK01 / XK02 / XK03 | Create / Change / Display vendor |
| ME51N | Create purchase requisition |
| ME21N | Create purchase order |
| ME2M / ME2N / ME2L | PO reporting by material / PO number / vendor |
| MIGO | Goods movement |
| MIRO | Invoice verification |
| MB52 | Warehouse stock list |
| MM60 | Material master list |
| MB5B | Stock on posting date |
| ME1M | Info records per material |
SAP MM Tables in S/4HANA
In S/4HANA, inventory tables are simplified: MKPF/MSEG post into the new MATDOC (material document) single table for high-volume analytics. The classic tables remain as compatibility views, but new CDS-based reporting reads MATDOC.
Key S/4HANA simplifications:
- MATDOC replaces MSEG/MKPF aggregates
- NSDM data model for inventory
- Vendor/customer masters merged into Business Partner (BP)
FAQ
Which is the most important SAP MM table?
MARA (material master general data) — almost every MM report starts here and joins plant (MARC), valuation (MBEW), or purchasing (EKKO/EKPO) data.
What is the difference between EKKO and EKPO?
EKKO stores the PO header (vendor, document type, dates); EKPO stores line items (material, quantity, price). They join on EBELN (PO number).
Which table stores purchase order history?
EKBE — every goods receipt and invoice posted against a PO is recorded here, making it the key table for GR/IR analysis.
Which movement types are most used?
101 (GR for PO), 261 (GI for order), 311 (transfer plant to plant), 201 (GI for cost center), 601 (GI for delivery).
Conclusion
Bookmark this list: MARA, MARC, MBEW for materials; EKKO, EKPO, EBAN for purchasing; MKPF, MSEG for inventory; LFA1 for vendors; RBKP for invoices. Knowing these ten tables covers most MM reporting, debugging, and interview questions. Pair this with our FI tables guide for the full procure-to-pay picture.