Introduction to SAP MM Tables
The SAP Materials Management (MM) module plays a vital role in the logistics area of SAP. It ensures that materials are available in the right quantity at the right time. This is achieved through efficient procurement, storage, and inventory management processes. To manage this data effectively, SAP MM relies on a comprehensive set of database tables. These Common Tables used by SAP MM help store and retrieve structured data efficiently for every business process within the MM module.Purchasing Tables in SAP MM
- EINA: Purchasing Info Record – General Data
- EINE: Purchasing Info Record – Purchasing Organization Data
- EBAN: Purchase Requisition
- EBKN: Purchase Requisition Account Assignment
- EKAB: Release Documentation
- EKBE: History per Purchasing Document
- EKET: Scheduling Agreement Schedule Lines
- EKKN: Account Assignment in Purchasing Document
- EKKO: Purchasing Document Header
- EKPO: Purchasing Document Item
Vendor Master Tables
- LFA1: Vendor Master (General section)
- LFB1: Vendor Master (Company Code)
Material Master Data Tables
- MARA: General Material Data
- MAKT: Material Descriptions
- MARC: Plant Data for Material
- MARD: Storage Location Data
- MBEW: Material Valuation
- MVKE: Sales Data for Materials
- MLAN: Tax Classification Data
- MARM: Unit of Measure Conversion
Material Description & Group Tables
- MAKT: Material Descriptions
- T023: Material Groups
Inventory Management Tables
- MSEG: Material Document Segment
- MKPF: Material Document Header
- MARD: Material stock at storage location
- MBEW: Valuation Data
- MSKA: Sales Order Stock
- EKUB: Index for Stock Transport Orders
- MDUB: View for Stock Transport Orders
- MKOL: Special Stock (Vendor consignment)
Valuation & Stock Tables
- MCHB: Batch Stocks
- MLGN: Warehouse Management Inventory
- MLGT: Warehouse Type Data
Bill of Materials and Forecasting
- MAST: Material to BOM Link
- MCHA: Batches
- MVER: Material Consumption
- MAPR: Forecast Data
Physical Inventory Tables
- IKPF: Physical Inventory Document Header
- ISEG: Physical Inventory Document Items
Movement Type & Reservation Tables
- T156: Movement Type
- T157H: Help Text for Movement Types
- RKPF: Reservation Document Header
- RESB: Reservation Items
Scheduling & Requisition Tables
- EKET: Scheduling Agreement Schedule Lines
- EBAN: Purchase Requisition
- EBKN: Purchase Requisition Account Assignment
Purchasing Groups and Organizations
- T024: Purchasing Groups
- EINE: Purchasing Info by Organization
Help and Text Tables
- T156: Movement Type Descriptions
- T157H: Help Text for Movement Types
- T161T: Texts for Purchasing Document Types
Number Ranges and Metadata Tables
- NRIV: Number Range Intervals
- MOFF: Views Not Created for Material Master
Special Stock & Sales Order Tables
- MKOL: Special Stocks
- MSKA: Sales Order Stock
Plant and Storage Data Tables
- MARC: Plant Data
- MARD: Storage Location Data
- A501: Plant/Material Info
SAP MM Table Summary by Category
| Category | Key Tables |
|---|---|
| Purchasing | EKKO, EKPO, EKET, EINA, EINE |
| Material Master | MARA, MAKT, MARC, MARD, MBEW |
| Vendor Master | LFA1, LFB1 |
| Inventory Management | MSEG, MKPF, MARD, MBEW |
| Bill of Materials & Forecast | MAST, MCHA, MVER, MAPR |
| Physical Inventory | IKPF, ISEG |
| Movement Types | T156, T157H |
| Scheduling & Requisition | EBAN, EBKN, EKET |
| Number Range | NRIV |
Best Practices for Using SAP MM Tables
- Always use SE11 or SE16N for table browsing.
- Use joins for combining header/item tables (e.g., EKKO and EKPO).
- Consider performance when querying large datasets.
- Use field catalogs for metadata lookup and descriptions.
FAQs on SAP MM Tables
Q1: What is the main table for material master data in SAP MM?The primary table is MARA, which stores general material data.
Q2: How do I find purchase order details in SAP MM?
Use tables EKKO (header) and EKPO (item) for purchase order information.
Q3: Which tables track goods movements?
MKPF stores header data and MSEG stores line-item level data.
Q4: Where is vendor data stored?
Vendor information is stored in LFA1 and LFB1 tables.
Q5: How can I view material stock levels?
Use MARD for stock at storage location and MBEW for valuation data.
Q6: What tools are used to query SAP tables?
You can use SE16N, SQVI, or SAP Query tools for querying.
Conclusion
Mastering the Common Tables used by SAP MM is essential for anyone working in procurement, inventory, or SAP data management. These tables form the backbone of all MM processes, from purchasing to inventory control. Knowing how and when to use them not only improves efficiency but also enhances the accuracy of your reports and operations.