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
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 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
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) |
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
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.
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 |
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 is T161
The Document Type are a subdivision of Document Category. The keys for T161 are BSTYP and BSART.
The vendor Master Data table in SAP is LFA1 for general information.
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 |
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:
The main customizing for PO or Purchase Order can be found in the following Table.
(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
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 |
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 |
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 |
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 |
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 |
SAP ISU Tables for Technical master data, for Billing Master Data, Billing and invoicing Tables?…
SAP Fiori 3 UX and Design of SAP Fiori Apps for SAP S/4HANA, SAP TechEd…
Dunning is the business practice of informing a customer of past due payment. Dunning letters…
SAP AP Tcodes & SAP AR Tcodes: House Banks Tcodes, Advance Payments or Down Payments,…
What are the main SAP Payment Terms Tables ? What are the related Tables in…
Work center consists of master data related to routing of products. It contains data related…