SAP Purchase Order Tables: Main PO tables in SAP MM – SAP PO Tables

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

Was this article helpful?

Related Articles

Leave A Comment?

You must be logged in to post a comment.