All The Tables In SAP MM Purchasing

If you're working with the SAP MM (Materials Management) module, especially in Purchasing (MM-PUR), knowing the relevant database tables is essential. These tables form the backbone of procurement processes—tracking requisitions, purchase orders, scheduling agreements, and account assignments.

Key SAP MM Purchasing Tables – Categorized List

1. Purchase Requisition Tables

Table Description
EBAN Purchase Requisition
EBKN Purchase Requisition Account Assignment
EBUB Index for Stock Transport Requisitions

2. Purchasing Info Record Tables

Table Description
EINA Info Record: General Data
EINE Info Record: Purchasing Org. Data
EIPA Order Price History: Info Record

3. Purchasing Document History Tables

Table Description
EKBE History per Purchasing Document
EKBEH Removed PO History Records
EKBZ Delivery Costs History
EKBZH Historical Delivery Costs

4. Scheduling Agreements and Release Documentation

Table Description
EKEH Scheduling Agreement Release Docs
EKEK Header Data for SA Releases
EKES Vendor Confirmations
EKET Schedule Lines
EKETH History of Schedule Lines

5. Purchasing Documents Core

Table Description
EKKO Purchasing Document Header
EKPO Purchasing Document Item
EKKN Account Assignment in PO
EKAN Vendor Address in PO
EKPA Partner Roles
EKPB Material Provided
EKPV Shipping-Specific Data for STO
EKRS ERS Procedure Goods Movements
EKUB STO Index for Material

6. Source List and Quota Arrangements

Table Description
EORD Source List
EQUK Quota File: Header
EQUP Quota File: Item

7. Purchasing Organization and Groups

Table Description
T024 Purchasing Groups
T024E Purchasing Organizations
T024W Org Validity by Plant
T024Z Texts for Purchasing Orgs

8. Shipping Instructions and Certificates

Table Description
T027A - T027D Shipping Instructions and Texts
T069, T069Q, T069T Certificate Categories & Texts

9. Purchasing Document Control Tables

Configure document behavior with tables from T160 to T160Y.

10. Document Type and Release Strategy

Manage document flows and approvals using tables from T161 to T161Z and T16FB to T16FS.

11. Field Selections & Item Categories

Customize forms and field visibility using T162 to T162Y and T163 to T163Y.

12. Text Management for Documents

Handle texts in printouts and forms with T165K, T165P, T166A to T166U.

13. Screen Control and Functions

Adjust screen layouts using T168, T168F, and T168T.

14. Number Range and Transaction Descriptions

Maintain number ranges using T167 and T167T.

Frequently Asked Questions (FAQs)

1. What is the difference between EKKO and EKPO in SAP MM?

EKKO stores header-level data of purchase documents, while EKPO stores item-level data.

2. What is EBAN used for in SAP?

EBAN stores details of purchase requisitions like item, quantity, and delivery date.

3. Which table contains purchase order history?

The EKBE table holds historical information related to purchasing documents.

4. What are quota arrangements in SAP MM?

Quota arrangements (EQUK, EQUP) allocate sourcing quantity percentages among vendors.

5. How are release strategies controlled in SAP MM?

Using tables like T16FB, T16FG, and T16FS for strategy configuration.

6. Where are purchasing text descriptions stored?

In tables like T166T, T165K, and T165P, depending on the document layer.

SAP MM Tips

 


See Also
Common Tables used by SAP MM

Get help for your SAP MM problems
SAP MM Forums - Do you have a SAP MM Question?

SAP Material Management Books
SAP MM Books - Certification, Interview Questions and Configuration

SAP Materials Management Tips
SAP MM Configuration Tips and Materials Management Discussion Forum

Best regards,
SAP Basis, ABAP Programming and Other IMG Stuff
http://www.erpgreat.com

All the site contents are Copyright © www.erpgreat.com and the content authors. All rights reserved.
All product names are trademarks of their respective companies.  The site www.erpgreat.com is in no way affiliated with SAP AG. 
Every effort is made to ensure the content integrity.  Information used on this site is at your own risk. 
 The content on this site may not be reproduced or redistributed without the express written permission of 
www.erpgreat.com or the content authors.