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 common called are:

SAP MAINPO TABLESDESCRIPTION
EKKOPurchasing Document Header
EKPOPurchasing Document Item
EKBEHistory 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 within SAP Purchase Order Tables is EKKO.
Each Purchase order is identified by EBELN ( PO Number )

The main EKKO fields are:

EKKO MAIN FIELDSDESCRIPTION
EBELNPurchasing Document Number
BUKRSCompany code
BSTYPPurchasing Document Category
BSAKZPurchasing Document Type

Read also

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:

EKPO MAIN FIELDSDESCRIPTION
EBELNPurchasing Document Number
EBELPItem Number of Purchasing Document
MATNRMaterial Number
BUKRSCompany Code
WERKSPlant
LGORTStorage Location
LIFNRVendor Account Number
IDNLFMaterial Number Used by Vendor
KTMNGTarget Quantity
NETPRNet 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:

EKBE MAIN FIELDSDESCRIPTION
EBELNPurchasing Document Number
EBELPItem Number of Purchasing Document
ZEKKNSequential Number of Account Assignment
VGABETransaction/event type & purchase order history
GJAHRMaterial Document Year
BELNRNumber of Material Document
BUZEIItem 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 Categoryare:

CATEGORYDESCRIPTION
ARequest for Quotation
FPurchase Order
KContract
LScheduling 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. So 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:

SAP PURCHASE ORDER TABLESDESCRIPTION
EBANPurchase Requisition
EBKNPurchase Requisition Account Assignment
EBUBIndex for Stock Transport Requisitions for Material
EINAPurchasing Info Record: General Data
EINEPurchasing Info Record: Purchasing Organization D
EIPAOrder Price History: Info Record
EKABRelease Documentation
EKANVendor Address: Purchasing Document
EKBEHistory per Purchasing Document
EKBEHRemoved PO History Records
EKBZHistory per Purchasing Document: Delivery Costs
EKBZHHistory per Purchasing Document: Delivery Costs
EKEHScheduling Agreement Release Documentation
EKEKHeader Data for Scheduling Agreement Releases
EKESVendor Confirmations
EKETScheduling Agreement Schedule Lines
EKETHScheduling Agreement Schedules: History Tables
EKKIPurchasing Condition Index
EKKNAccount Assignment in Purchasing Document
EKKOPurchasing Document Header
EKPAPartner Roles in Purchasing
EKPBMaterial Provided” Item in Purchasing Document
EKPOPurchasing Document Item
EKPVShipping-Specific Data on Stock Tfr. for Purch. D
EKRSERS Procedure Goods (Merchandise) Movements to b
EKUBIndex for Stock Transport Orders for Material
EORDPurchasing Source List
EQUKQuota File: Header
EQUPQuota 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:

PURCHASE ORDER HISTORYFIELD DESCRIPTION
EBELNPurchasing Document Number
EBELPItem Number of Purchasing Document
ZEKKNSequential Number of Account Assignment
VGABETransaction/event type/ purchase order history
GJAHRMaterial Document Year
BELNRNumber of Material Document
BUZEIItem 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 of the following SAP tables contain SAP PO related Master)

SAP PO CUSTODESCRIPTION
T024Purchasing Groups
T024EPurchasing Organizations
T024WValid Purchasing Organizations for Plant
T024ZPurchasing Organizations
T027AShipping Instructions Purchasing
T027BTexts: Shipping Instructions
T027CCodes for Compliance with Shipping Instructions
T027DCompliance with Shipping Instructions Texts
T069Certificate Categories
T069QControl Data for Source Determination and Checking
T069TCertificate Categories: Text Description
T160SAP Transaction Control : Purchasing
T160BSAP Transaction Control: List Displays/Purchasing
T160CSAP Transaction Control for List Displays in CALL
T160DFunction Authorizations: Purchase Order
T160EFunction Authorizations: Purchasing: Descriptions
T160IControl of Intrastat. Reports
T160JText Table for Intrastat. Reports
T160LScope of Purchasing Lists
T160MMessage Control: Purchasing (System Messages)
T160ODescription of Scope of List
T160PEntities Table Routines
T160QScope of List: Buyer’s Negotiation Sheet: Routine
T160RRoutines for Buyer’s Negotiation Sheet
T160SSelection Parameters for Purchasing Lists
T160TDescription of Selection Parameters
T160VDefault Values for Purchasing
T160WDescription for Default Values for Purchasing Ope
T160XScope of List: Buyer’s Negotiation Sheet
T160YScope 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
T161Purchasing Document Types
T161ALinkage of Requisition Doc. Type to Purchasing Do
T161BDefault Business Transaction Type for Import
T161ERelease Codes
T161FRelease Point Assignment for Purchase Requisition
T161GRelease Prerequisite: Purchase Requisition
T161HFields for Release Procedure: Purchase Requisition
T161IDetermination of Release Strategy
T161MFine-Tuned Control: Message Types
T161NMessage Determination Schema: Assignment
T161PCheck of Document Type /Document Category:Item C
T161RREORG Control: Purchasing
T161SRelease Indicator: Purchase Requisition
T161TTexts for Purchasing Document Types
T161UTexts for Release Indicator
T161VShipping-Specific Data for Stock Tfr. for Purch.
T161WOrder Types for Stock Transfer
T161ZAdditional 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. TABLEDESCRIPTION
T162Field Selection: Purchasing Document
T162KField Selection: Account Assignment Fields/Purch
T162TDescription of Field Selection Reference Key
T162XDescription of Field Groups from T162/T162K
T162YGroups: Field Selection

T163* PO Customizing Table Part 4

Here the list of SAP Purchase Order Customizing Tables starting with T163*

SAP PO TABLESDESCRIPTION
T163Item Categories in Purchasing Document
T163ACheck Item Category/Account Assignment Category
T163BPurchase Order History Categories
T163CTexts for Purchase Order History Categories
T163DAssignment Internal/External Confirmation Categories
T163EConfirmation Categories
T163FConfirmation Categories: Descriptions
T163GConfirmation Control
T163ITexts for Account Assignment Categories
T163KAccount Assignment Categories in Purchasing Document
T163KSAssignment of Tax Indicator to Account Assignment
T163LConfirmation Control Keys
T163MConfirmation Control Keys: Description
T163PRelease Creation Profile
T163SDescription for Release Creation Profile
T163YTexts 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 TABLESDESCRIPTION
T165KCopying Options: Header Texts
T165PCopying Options: Item texts
T166ASupplement Text in Purchasing Document Printouts
T166CPrint-Relevant Purchasing Document Changes
T166KHeader Texts in Purchasing Document Printouts
T166PItem Texts in Purchasing Document Printouts
T166TChange Texts in Purchasing Document Printouts
T166UHeadings in Purchasing Document Printout
T167Number Range Management for Purchasing Master Data
T167TTransaction Description
T168Screen Control: Purchasing
T168FFunction Codes / Purchasing
T168TScreen 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 TABLESDESCRIPTION
T16FBRelease Indicators: Purchasing Document
T16FCRelease Codes
T16FDDescription of Release Codes
T16FEDescriptions of Release Indicators: Purchasing Do
T16FGRelease Groups
T16FHDescriptions of Release Groups
T16FKRelease Statuses
T16FSRelease Strategies