In this post, you will find the main SAP Purchase Order Tables for header, item, and historical.
As well as, all relevant SAP tables related to Purchasing process.
First, we will explain the main Purchase Order SAP Tables, then we will list the main SAP Table for Purchase Document in SAP MM (Material Management).
Table of Contents
SAP Purchase Order Tables
The main SAP Purchase Order Tables or SAP PO Tables as commonly called are:
| PO Table | SAP MAIN PO TABLES |
|---|---|
| EKKO | Purchasing Document Header |
| EKPO | Purchasing Document Item |
| EKBE | History per Purchasing Document |
Check also this post for more detail about SAP Purchase Order Overview
EKKO Table in SAP
EKKO Table in SAP is the Purchasing Document Header.
The most important SAP Purchase Order Tables is EKKO. Each Purchase order is identified by EBELN (PO Number)
The main EKKO fields are:
| Field | EKKO MAIN FIELDS |
|---|---|
| EBELN | Purchasing Document Number |
| BUKRS | Company code |
| BSTYP | Purchasing Document Category |
| BSAKZ | Purchasing Document Type |
Read also
- SAP Purchase Order Process & Doc. Flow SAP SD / MM (Tcodes & Tables)
- Complete list of SAP Purchase Document ME21N Exit and BADI
- EDI 870: Order Status Report SAP ORDERS05 IDoc Explained
SAP PO EKPO Table in SAP
The lines of SAP PO (Purchase Order) can be found in EKPO table.
The main fields at EKPO are:
| Field | SAP EKPO MAIN FIELD |
|---|---|
| EBELN | Purchasing Document Number |
| EBELP | Item Number of Purchasing Document |
| MATNR | Material Number |
| BUKRS | Company Code |
| WERKS | Plant |
| LGORT | Storage Location |
| LIFNR | Vendor Account Number |
| IDNLF | Material Number Used by Vendor |
| KTMNG | Target Quantity |
| NETPR | Net Price in Purchasing Document (in Document Currency) |
EKBE Table is SAP
The Historical data for a SAP Purchase Order Tables is set on EKBE. The details are saved by items.
The main fields for EKBE are:
| Fields | EKBE MAIN FIELDS |
|---|---|
| EBELN | Purchasing Document Number |
| EBELP | Item Number of Purchasing Document |
| ZEKKN | Sequential Number of Account Assignment |
| VGABE | Transaction/event type & purchase order history |
| GJAHR | Material Document Year |
| BELNR | Number of Material Document |
| BUZEI | Item in Material Document |
Check this book Materials Management with SAP ERP: Functionality and Technical Configuration (SAP MM) (4th Edition) (SAP PRESS) 4th Edition
SAP Purchase Order Reference Tables
Purchasing Document Category BSTYP
The purchasing document category allows differentiation between the various kinds of purchasing documents (e.g. purchase order, scheduling agreement, contract).
The purchasing document category determines the applicable number range, for example, and the fields that are offered to you for maintenance.
The relevant document category is suggested by the system when you create a purchasing document.
Purchasing document categories can be further subdivided into Purchasing Document Types.
List of Purchasing Document Category Value
The Document Category (EKKO-BSTYP) values are set on Value Range for Domain EBSTYP.
The different Values of SAP Purchasing Document Category are:
| CATEGORY | DESCRIPTION |
|---|---|
| A | Request for Quotation |
| F | Purchase Order |
| K | Contract |
| L | Scheduling Agreement |
Purchasing Document Type BSART
The Document Type EKKO-BSART differentiates between the different kinds of requisition and purchases order in the SAP system.
The order type controls the number assignment for a purchase order, for example, and determines which fields you must maintain.
The reference table for Document Type isT161
The Document Type are a subdivision of Document Category. The keys for T161 are BSTYP and BSART.
Vendor Account Number
The vendor Master Data table in SAP is LFA1 for general information.
Full list of SAP MM Purchasing Tables
SAP Tables for PO (Purchase Order Tables in SAP)
The first list contains only PO Data Tables. The next part will list the customizing tables for purchase orders in SAP MM Purchasing.
SAP Purchase Order Tables are:
| Tables | SAP PURCHASE ORDER TABLES |
|---|---|
| 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 D |
| EIPA | Order Price History: Info Record |
| EKAB | Release Documentation |
| EKAN | Vendor Address: Purchasing Document |
| EKBE | History per Purchasing Document |
| EKBEH | Removed PO History Records |
| EKBZ | History per Purchasing Document: Delivery Costs |
| EKBZH | History per Purchasing Document: Delivery Costs |
| EKEH | Scheduling Agreement Release Documentation |
| EKEK | Header Data for Scheduling Agreement Releases |
| EKES | Vendor Confirmations |
| EKET | Scheduling Agreement Schedule Lines |
| EKETH | Scheduling Agreement Schedules: History Tables |
| EKKI | Purchasing Condition Index |
| 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-Specific Data on Stock Tfr. for Purch. D |
| EKRS | ERS Procedure Goods (Merchandise) Movements to b |
| EKUB | Index for Stock Transport Orders for Material |
| EORD | Purchasing Source List |
| EQUK | Quota File: Header |
| EQUP | Quota File: Item |
SAP Table for Purchase order history
The Purchase Order History can be found in the standard Table EKBE.
The Key fields for PO History Table are :
| Field | PURCHASE ORDER HISTORY |
|---|---|
| EBELN | Purchasing Document Number |
| EBELP | Item Number of Purchasing Document |
| ZEKKN | Sequential Number of Account Assignment |
| VGABE | Transaction/event type/ purchase order history |
| GJAHR | Material Document Year |
| BELNR | Number of Material Document |
| BUZEI | Item in Material Document |
There is also SAP Tables for Purchase Order Further History such as:
- EKBEH, Removed PO History Records
- EKBZ, History per Purchasing Document: Delivery Costs
- EKBZH, History per Purchasing Document: Delivery Costs
SAP Customizing Tables for PO
The main customizing for PO or Purchase Order can be found in the following Table.
SAP PO Customizing Table Part 1
(Note that some following SAP tables contain SAP PO related Master)
| SAP PO CUSTO | DESCRIPTION |
|---|---|
| T024 | Purchasing Groups |
| T024E | Purchasing Organizations |
| T024W | Valid Purchasing Organizations for Plant |
| T024Z | Purchasing Organizations |
| T027A | Shipping Instructions Purchasing |
| T027B | Texts: Shipping Instructions |
| T027C | Codes for Compliance with Shipping Instructions |
| T027D | Compliance with Shipping Instructions Texts |
| T069 | Certificate Categories |
| T069Q | Control Data for Source Determination and Checking |
| T069T | Certificate Categories: Text Description |
| T160 | SAP Transaction Control : Purchasing |
| T160B | SAP Transaction Control: List Displays/Purchasing |
| T160C | SAP Transaction Control for List Displays in CALL |
| T160D | Function Authorizations: Purchase Order |
| T160E | Function Authorizations: Purchasing: Descriptions |
| T160I | Control of Intrastat. Reports |
| T160J | Text Table for Intrastat. Reports |
| T160L | Scope of Purchasing Lists |
| T160M | Message Control: Purchasing (System Messages) |
| T160O | Description of Scope of List |
| T160P | Entities Table Routines |
| T160Q | Scope of List: Buyer’s Negotiation Sheet: Routine |
| T160R | Routines for Buyer’s Negotiation Sheet |
| T160S | Selection Parameters for Purchasing Lists |
| T160T | Description of Selection Parameters |
| T160V | Default Values for Purchasing |
| T160W | Description for Default Values for Purchasing Ope |
| T160X | Scope of List: Buyer’s Negotiation Sheet |
| T160Y | Scope of List: Buyer’s Negotiation Sheet: Description |
Read alsoÂList of Important SAP Material Types in SAP MM
T161* PO Customizing Table Part 2
The next list of Purchase Document SAP Customizing Tables starting with T161* are:
| SAP PO CUSTO. | DESCRIPTION |
|---|---|
| T161 | Purchasing Document Types |
| T161A | Linkage of Requisition Doc. Type to Purchasing Do |
| T161B | Default Business Transaction Type for Import |
| T161E | Release Codes |
| T161F | Release Point Assignment for Purchase Requisition |
| T161G | Release Prerequisite: Purchase Requisition |
| T161H | Fields for Release Procedure: Purchase Requisition |
| T161I | Determination of Release Strategy |
| T161M | Fine-Tuned Control: Message Types |
| T161N | Message Determination Schema: Assignment |
| T161P | Check of Document Type /Document Category:Item C |
| T161R | REORG Control: Purchasing |
| T161S | Release Indicator: Purchase Requisition |
| T161T | Texts for Purchasing Document Types |
| T161U | Texts for Release Indicator |
| T161V | Shipping-Specific Data for Stock Tfr. for Purch. |
| T161W | Order Types for Stock Transfer |
| T161Z | Additional Checks for Outline Agreements on Reorg |
T162* PO Customizing Table Part 3
Here the list of SAP Purchase Order Customizing Tables starting with T162*
| SAP PO CUSTO. TABLE | DESCRIPTION |
|---|---|
| T162 | Field Selection: Purchasing Document |
| T162K | Field Selection: Account Assignment Fields/Purch |
| T162T | Description of Field Selection Reference Key |
| T162X | Description of Field Groups from T162/T162K |
| T162Y | Groups: Field Selection |
T163* PO Customizing Table Part 4
Here the list of SAP Purchase Order Customizing Tables starting with T163*
| SAP PO TABLES | DESCRIPTION |
|---|---|
| T163 | Item Categories in Purchasing Document |
| T163A | Check Item Category/Account Assignment Category |
| T163B | Purchase Order History Categories |
| T163C | Texts for Purchase Order History Categories |
| T163D | Assignment Internal/External Confirmation Categories |
| T163E | Confirmation Categories |
| T163F | Confirmation Categories: Descriptions |
| T163G | Confirmation Control |
| T163I | Texts for Account Assignment Categories |
| T163K | Account Assignment Categories in Purchasing Document |
| T163KS | Assignment of Tax Indicator to Account Assignment |
| T163L | Confirmation Control Keys |
| T163M | Confirmation Control Keys: Description |
| T163P | Release Creation Profile |
| T163S | Description for Release Creation Profile |
| T163Y | Texts for Item Categories |
T165/T166* PO Customizing Table Part 5
Here the list of SAP Purchase Order Customizing Tables starting with T165/T166*
| SAP PO TABLES | DESCRIPTION |
|---|---|
| T165K | Copying Options: Header Texts |
| T165P | Copying Options: Item texts |
| T166A | Supplement Text in Purchasing Document Printouts |
| T166C | Print-Relevant Purchasing Document Changes |
| T166K | Header Texts in Purchasing Document Printouts |
| T166P | Item Texts in Purchasing Document Printouts |
| T166T | Change Texts in Purchasing Document Printouts |
| T166U | Headings in Purchasing Document Printout |
| T167 | Number Range Management for Purchasing Master Data |
| T167T | Transaction Description |
| T168 | Screen Control: Purchasing |
| T168F | Function Codes / Purchasing |
| T168T | Screen Titles |
Sap Purchase Order Tables: T16F* PO Customizing Table Part 6
Here the list of SAP Purchase Order Customizing Tables starting with T16F*
| SAP PO TABLES | DESCRIPTION |
|---|---|
| T16FB | Release Indicators: Purchasing Document |
| T16FC | Release Codes |
| T16FD | Description of Release Codes |
| T16FE | Descriptions of Release Indicators: Purchasing Do |
| T16FG | Release Groups |
| T16FH | Descriptions of Release Groups |
| T16FK | Release Statuses |
| T16FS | Release Strategies |
