SAP MM Tables (MOST COMMON)

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.

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.

sap-mm-tables

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:

    1. 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:

SE16N - MAKT - SAP MM Tables (MOST COMMON)

SE16N MAKT Table

2. Select the Execute button , and enter

SE16N-MAKT - SAP MM Tables (MOST COMMON)

SE16N MAKT Material Description

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.

Omar Olwan

Related posts

0 Comments

Pin It on Pinterest

Share This