SAP S/4HANA MM Tables are your gateway to advanced Materials Management! Explore the critical role of SAP S/4HANA MM tables in streamlining your materials management processes in this comprehensive guide.
Table of Contents
What are SAP S/4HANA MM Tables
SAP S/4HANA MM Tables, standing for SAP Materials Management Tables. These are structured data formats within the SAP system that store and manage materials and inventory management information. These tables facilitate the organization, retrieval, and processing of data regarding procurement, inventory, vendor interactions, and other material-related activities. They serve as a database to support various business processes and decision-making in materials management.
Most Common SAP MM Tables
In our exploration of SAP MM tables, we find them organized into functional groups. Each serves specific aspects of materials management. This includes categories like Material Master and Vendor Master Tables, which focus on core data about materials and suppliers.
Additionally, tables dedicated to Purchasing, Planning, Shipping, and Inventory Management play pivotal roles in streamlining the procurement cycle and maintaining efficient operations. This structured organization ensures seamless integration and data flow across various business processes. Previously, I wrote about SE16N in my article Top 10 SAP Materials Management Transaction Codes here.
Viewing the SAP S/4HANA MM Tables
Exploring SAP S/4HANA MM tables can be a game changer if you’re a power user. These tables allow you to see more detailed information than what’s usually available. It is beneficial for in-depth reports. With SE16N or SE11, you can access more data and information about those fields. These will help you to understand materials management in greater depth.
Want to learn more? Keep reading to discover the most common SAP S/4HANA MM tables categorized into subdomains.
Purchasing Documents Tables
| Purchasing Documents Tables | Description |
| EBAN | Purchase Requisition |
| EBKN | Purchase Requisition Account Assignment |
| EBUB | Index for Stock Transport Requisitions for Material |
| EINA | Purchasing Info Record: General Data |
| EINE | Purchasing Info Record: Purchasing Organization Data |
| EIPA | Order Price History: Info Record |
| EKAB | Release Documentation |
| EKAN | Vendor Address: Purchasing Document |
| EKBE | History per Purchasing Document |
| EKEH | Scheduling Agreement Release Documentation |
| EKEK | Header Data for Scheduling Agreement Releases |
| EKES | Vendor Confirmations |
| EKET | Scheduling Agreement Schedule Lines |
| EKKN | Account Assignment in Purchasing Document |
| EKKO | Purchasing Document Header |
| EKPA | Partner Roles in Purchasing |
| EKPB | Material Provided” Item in Purchasing Document |
| EKPO | Purchasing Document Item |
| EKPV | Shipping Data For Stock Transfer of Purchasing Document Item |
| EKRS | ERS Procedure: Goods (Merchandise) Move to be Invoiced |
| EKRSDC | ERS Procedure: Planned Delivery Costs to be Invoiced |
| EKUB | Index for Stock Transport Orders for Material |
Material Master Tables
| Material Master Tables | Description |
| MAEX | Material Master: Legal Control |
| MAKT | Material Descriptions |
| MALG | Assignment of Layout Modules to Materials |
| MAMT | Material Master Texts per Unit of Measure and Text ID |
| MAPE | Material Master: Export Control File |
| MARA | General Material Data |
| MARC | Plant Data for Material |
| MARD | Storage Location Data for Material |
| MARE | Reference Fields of Material for Change Documents |
| MARM | Units of Measure for Material |
| MARV | Material Control Record |
| MAW1 | Material Master: Default Fields and Special Retail Fields |
| MBEW | Material Valuation |
| MFHM | Production Resource Tool (PRT) Fields in the Material Master |
| MKAL | Production Versions of Material |
| MLAN | Tax Classification for Material |
| MLGN | Material Data for Each Warehouse Number |
| MLGT | Material Data for Each Storage Type |
| MKOL | Special Stocks from Vendor |
| MKOP | Consignment Price Segment |
| MPOP | Forecast Parameters |
| MPRP | Forecast Profiles |
| MSKA | Sales Order Stock |
| MSKU | Special Stocks with Customer |
| MSLB | Special Stocks with Vendor |
| MSTA | Material Master Status |
| MVER | Material Consumption |
| MVKE | Sales Data for Material |
| MWLI | Listing (Retail) |
Vendor Master Tables
| Vendor Master Tables | Description |
| LFA1 | Vendor Master (General Section) |
| LFAS | Vendor Master (VAT Registration Numbers General Section) |
| LFAT | Vendor Master Record (Tax Groupings) |
| LFB1 | Vendor Master (Company Code) |
| LFB5 | Vendor Master (Dunning Data) |
| LFBK | Vendor Master (Bank Details) |
| LFBW | Vendor Master Record (Withholding Tax Types) X |
| LFC1 | Vendor Master (Transaction Figures) |
| LFC3 | Vendor Master (Special G/L Transaction Figures) |
| LFEI | Vendor Master: Preference for Import and Export |
| LFLR | Vendor Master Record: Supply Regions |
| LFM1 | Vendor Master Record Purchasing Organization Data |
| LFM2 | Vendor Master Record: Purchasing Data |
| LFMH | Vendor Hierarchy |
| LFZA | Permitted Alternative Payee |
| WYT1 | Vendor Subrange |
| WYT1T | Vendor Sub-Range Description |
| WYT3 | Partner Functions |
Purchasing Sourcing Data Tables
| Purchasing Sourcing Data Tables | Description |
| EINA | Purchasing Info Record: General Data |
| EINE | Purchasing Info Record: Purchasing Organization Data |
| EIPA | Order Price History: Info Record |
| KOMG | Allowed Fields for Condition Structures |
| KOMK | Communication Header for Pricing |
| KOMP | Communication Item for Pricing |
| EORD | Purchasing Source List |
| EQUK | Quota File: Header |
| EQUP | Quota File: Item |
Planning and Forecasting Tables
| Planning and Forecasting Tables | Description |
| MDKP | Header Data for MRP Document |
| MDRV | Generated Table for View |
| MDVM | Entry in MRP File |
| MKAL | Production Versions of Material |
| PLAF | Planned Order |
| PBED | Independent Requirements Data |
| PBHI | Independent Requirements History |
| PBIM | Independent Requirements for Material |
Forecasting Tables
| Forecasting Tables | Description |
| PROF | Forecast Errors |
| PRON | Post-Processing of Forecast Errors and Exception Messages |
| PROP | Forecast Parameters |
| PROW | Forecast Values |
| WBO1 | Log Header File for Simulative List for Load Building |
| WBO2 | Log item File for Simulative List for Load Building |
| WBO3 | Log File for Investment Buy |
| WBO4 | Log, Load Building, Restriction Profile Used |
| WBO5 | Calculated Actual Vendor Service Level |
Shipping Tables
| Shipping Tables | Description |
| Shipment Costing Tables | |
| Table | Description |
| LIKP | SD Document: Delivery Header Data |
| LIPS | SD Document: Delivery: Item Data |
| SHP_IDX_CRED | Outbound Deliveries in Credit Check: Blocked and Released |
| SHP_IDX_EXIB | Inbound Delivery: External Identification |
| SHP_IDX_EXOB | Outbound Delivery: External Identification |
| SHP_IDX_GDRC | Inbound Deliveries: Not Posted for Goods Receipt |
| SHP_IDX_GDSI | Outbound Deliveries: Not Posted for Goods Issue |
| SHP_IDX_PICK | Outbound Deliveries: Not Picked |
| SHP_IDX_PUTA | Inbound Deliveries: Not Putaway |
| SHP_IDX_ROGR | Rough Goods Receipts for Vendor |
| SHP_IDX_UNCH | Outbound Deliveries: Unchecked |
| VBFS | Error Log for Collective Processing |
| VFKK | Shipment Costs: Header Data |
| VFKN | Account Determination in Shipment Costs Item |
| VFKONV | (Freight) Conditions |
| VFKONX | Conditions: Dimension-Dependent Data |
| VFKP | Shipment Costs: Item Data |
| VFPA | Partner for Shipment Costs |
| VFSCAH | Scale Header |
| VFSCAHT | Descriptions for Scales |
| VFSCAID | Scale Item: Gross Weight |
| VFSCAIF | Scale Item: Gross Volume |
| VFSCAIF0 | Scale Item: Measuring |
| VFSCAIL0 | Scale Item: Postal Code |
| VFSCAIL2 | Scale Item: Tariff Zone |
| VFSCAIL4 | Scale Item: Transportation Zone |
| VFSCAIL6 | Scale Item: Region |
| VFSCAIR | Scale Item: Distance |
| VFSCAIS | Scale Item: Number of Shipping Units |
| VFSCAIS0 | Key Item: Shipping Material |
| VFSCAIS1 | Scale Item: Length of Loading Platform (Shipping Unit) |
| VFSCAIT0 | Scale Item: Duration (Idle Time, Travel Time, and so on) |
| VFSCAR1 | Freight Rates (One-Dimensional) |
| VFSCAR2 | Freight Rates (Two-Dimensional) |
| VFSCAR3 | Freight Rates (Three-Dimensional) |
| VFSI | Shipment Costs: Sub-Item Data |
| VFZP | Correct Original Assignment of Conditions |
Transportation Tables
| Transportation Tables | Description |
| VTDST | Status of Deliveries within Transportation Planning |
| VTFA | Shipment Document Flow |
| VTPA | Shipping Partner |
| VTRDI | Shipment Planning Index |
| VTSP | Stage of Transport/Item Allocation |
| VTTK | Shipment Header |
| VTTP | Shipment Item |
| VTTS | Stage of Shipment |
| TVKN | Routes: Transportation Connection Points |
| TVKNT | Routes: Transportation Connection Points: Texts |
| TVRAB | Route Stages |
| TVRO | Routes |
| TVROT | Routes: Texts |
| TVRSZ | Routes: Legs for Each Route |
| TVSR | Routes: Legs |
External Services Tables
| External Services Tables | Description |
| ASMD | Service Master: Basic Data |
| ASMDT | Service Short Texts |
| ESKL | Account Assignment Specification: Service Line |
| ESKN | Account Assignment in Service Package |
| ESLA | Service Type Editions |
| ESLB | Service Type Header of Standard Service Catalog |
| ESLH | Service Package Header Data |
| ESLL | Lines of Service Package |
| ESLP | Service Item |
| ESLT | Service Item Short Texts |
| ESLZ | Service Type Lines |
| ESSR | Service Entry Sheet Header Data |
| ESST | Service Item Short Texts |
| ESUC | Ext. Services Management: Unplanned Limits on Contract Item |
| ESUH | Ext. Services Management: Unplanned. Service Limits: Header Data |
| ESUP | Ext. Services Management: Unplanned Limits on Service Package |
| ESUS | Services Management: Unplanned Limits on Service Types |
Inventory Management Tables
| Inventory Management Tables | Description |
| CHVW | Table CHVW for Batch Where-Used List |
| IKPF | Header: Physical Inventory Document |
| ISEG | Physical Inventory Document Items |
| MCH1 | Batches (if Batch Management Cross-Plant) |
| MCHA | Batches |
| MCHB | Batch Stocks |
| MKPF | Header: Material Document |
| MSEG | Document Segment: Material |
| RESB | Reservation/Dependent Requirements |
| RKPF | Document Header: Reservation |
Invoice Verification Tables
| Invoice Verification Tables | Description |
| RBCO | Document Item, Incoming Invoice, Account Assignment |
| RBKP | Document Header: Invoice Receipt |
| RBKP_BLOCKED | Logistics Invoice Verification: Blocked Invoices |
| RBMA | Document Item: Incoming Invoice for Material |
| RBTX | Taxes: Incoming Invoice |
| RBVD | Invoice Document: Aggregation Data |
| RBVDMAT | Invoice Verification: Aggregation Data, Material |
| RBVS | Invoice Verification: Split Invoice Amount |
| RBWS | Withholding Tax Data, Incoming Invoice |
| RBWT | Withholding Tax Data, Incoming Invoice |
| RKWA | Consignment Withdrawals |
| RSEG | Document Item: Incoming Invoice |
| Table Name | Description |
| MLIT | Material Ledger Document: Items |
| MLCD | Material Ledger: Summarization Record (from Documents) |
| MLPP | Material Ledger Document: Posting Periods and Quantities |
| MLPPF | Material Ledger Document: Field Groups (Posting Periods) |
| CKMLPP | Material Ledger Period Totals Records Quantity |
| MLHD | Material Ledger Document: Header |
| MLCR | Material Ledger Document: Currencies and Values |
| CKMLCR | Material Ledger: Period Totals Records Values |
| CKMLKEPH | Material Ledger: Cost Component Split (Elements) |
| MLCRF | Material Ledger Document: Field Groups (Currencies) |
| CKMLPPWIP | Material-Ledger: Period Records WIP (Quantities) |
How to View Tables in SAP MM?
In SAP, any table can be viewed in the same way. To view a table in SAP, go to transaction SE16N (make sure you have access to it; if you are not a super user, you probably don’t have access) and insert the name of the table:
- Go to SE16N; in this example, we will use the MAKT table (Material Descriptions); use a material you want to look at 3112321, and enter:
2. Select the Execute button , and enter
3. You can see that the table is now complete, with the material number 3112321
Please let us know if you require further information or have any questions in the comments below. Don’t forget to subscribe to the Spend Wizard for regular updates from our blog.
References: The SAP Materials Management Handbook
Another option is to use SE11, which is the ABAP data dictionary.
Frequently Asked Questions
What are the tables in SAP S/4HANA MM?
Tables in SAP S/4HANA MM are structured formats storing material management data, like inventory, procurement, and vendor details.
How to use SAP S/4HANA tables?
You can use SAP S/4HANA tables by accessing them via transactions like SE16N or SE11 for data retrieval and analysis in materials management.
What are Material Master tables in SAP?
Material Master tables in SAP store comprehensive data about materials a company procures, stores, and sells.
What are Vendor Master tables in SAP?
Vendor Master tables in SAP hold detailed information about the suppliers, including their contact details, material provided, and transaction history.
Summary: A geek by day and night.
- Overview of the Material Master in SAP S/4HANA - January 2, 2024
- SAP FICO TRANSACTION CODES (MOST COMMON) - December 24, 2023
- Best SAP S/4HANA MM Books for Beginners and Advanced Learners - November 25, 2023
0 Comments