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).

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

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

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

SAP Purchase Order Reference Tables

Purchasing Document Category BSTYP

The purchasing document category allows differentiation between the various kinds of purchasing document (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 purchase 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.

Vendor Account Number

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 order 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

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