SAP ERP contains a wide range of tables for managing Supply Chain Management (SCM) and Inventory Management (IM) processes. Here’s a categorized list of the most commonly used tables in these modules:
1. Supply Chain Management Tables
Master Data Tables
1. Material Master (MM):
• MARA: General data about materials.
• MARC: Plant-specific material data.
• MARD: Storage location-specific stock data.
• MAKT: Material descriptions.
• MBEW: Material valuation data.
2. Vendor Master:
• LFA1: General vendor master data.
• LFB1: Vendor data specific to company codes.
• LFM1: Vendor data for purchasing organizations.
3. Customer Master:
• KNA1: General customer master data.
• KNVV: Sales area-specific customer data.
• KNVP: Partner functions for customers.
4. Bill of Materials (BOM):
• STKO: BOM header.
• STPO: BOM items.
5. Work Centers:
• CRHD: Work center header.
• CRCO: Assignment of work centers to cost centers.
Transaction Tables
1. Sales and Operations Planning (SOP):
• PGMI: Planning data for SOP.
• PGAN: Assignments in SOP.
2. Production Planning (PP):
• AFKO: Order header data for production orders.
• AFPO: Order item data for production orders.
3. Demand Planning:
• PBIM: Independent requirements by material.
• PBED: Planned requirements for materials.
4. Purchasing:
• EKKO: Purchasing document header (e.g., purchase orders).
• EKPO: Purchasing document items.
5. Supply Chain Execution:
• LIPS: Delivery document items.
• LIKP: Delivery document headers.
2. Inventory Management Tables
Stock Management
1. Stocks and Quantities:
• MKPF: Material document header.
• MSEG: Material document items (e.g., goods movement).
• MBEWH: Historical stock valuation.
2. Warehouse Management:
• LAGP: Storage bins.
• LQUA: Quants (specific stock quantities in bins).
• LTAP: Transfer order items.
• LTAK: Transfer order headers.
3. Batch Management:
• MCHB: Batch stocks.
• MCHA: Batch data.
• MCH1: Batch data for materials.
Physical Inventory
1. Physical Inventory Documents:
• ISEG: Physical inventory document items.
• IKPF: Physical inventory document header.
Goods Movements
1. Movement Types:
• T156: Movement type definitions.
• T157D: Stock type changes during movement.
2. Goods Issue/Receipt:
• RESB: Reservation items for goods movements.
• RKPF: Reservation headers.
3. Integration and Reporting Tables
SCM Reporting and Analytics
1. Logistics Information System (LIS):
• S001 - S999: Various structures for logistics reporting.
• MCBE: Inventory data for material movements.
2. Inventory Analytics:
• MCWBE: Historical stock data for warehouse reporting.
• MVER: Material consumption data for MRP.
Integration with Other Modules
1. Integration with Finance (FI):
• BKPF: Accounting document header (for goods movements).
• BSEG: Accounting document items.
2. Integration with Sales (SD):
• VBAP: Sales order items.
• VBEP: Schedule lines for sales documents.
Common Queries and Use Cases
1. Track Inventory Levels by Plant:
• Tables: MARD (storage location stock), MBEW (valuation).
• Query: “What is the current stock quantity for material X in plant Y?”
2. Analyze Purchase Orders by Vendor:
• Tables: EKKO, EKPO.
• Query: “What are the total purchase orders placed with vendor Z in 2024?”
3. Monitor Goods Movements:
• Tables: MKPF, MSEG.
• Query: “List all goods receipts for material A in warehouse W.”
4. Warehouse Performance Reporting:
• Tables: LQUA, LTAP, MCBE.
• Query: “What is the total number of items moved between bins in Q4 2024?”
Need Further Assistance?
Would you like detailed table relationships, an ER diagram, or SQL queries for specific use cases in SCM or Inventory?