Below is a list of Purchase order related SAP database tables, what data they store and how they are related to each other. Also, click on the table name for full details of its fields including which make up the table key along with other information such as check tables, text tables…
Purchasing Documents
This is a list of the main SAP PO tables which store the Purchasing information including the header and item details of each Purchase Order.
EKKO – Purchasing Document Header
EKPO – Purchasing Document Item
MARA – General Material Data
EKET – Scheduling Agreement Schedule Lines
EKKN – Account Assignment in Purchasing Document
EKBE – Purchasing Document History
Accounting Documents
Accounting forms a big part of the purchase process so there are a number of direct relationships between the PO tables and the accounting tables such as BKPF and BSEG.
BKPF – Accounting Document Header
BSET – Tax Data Document Segment
BSEG – Accounting Document Segment
BSEC – One-Time Account Data Document Segment
EKKO – Purchasing Document Header
EKPO – Purchasing Document Item
EKBE – Purchasing Document History
Purchasing Activities per Requirement Tracking No.
Also see relationship with purchase requision tables EBAN and EBKN.
EKDY – Dummy Table for Database EBM
EKKO – Purchasing Document Header
EKPO – Purchasing Document Item
EKET – Scheduling Agreement Schedule Lines
MARA – General Material Data
EKKN – Account Assignment in Purchasing Document
EKBE – History per Purchasing Document
EBAN – Purchase Requisition
EBKN – Purchase Requisition Account Assignment
Archiving of Purchasing Documents
As you can imagine an SAP system can process a large amount of purchasing data via many thousands of
PO documents. This data therefor needs to periodically archived and there are a number of standard SAP tables related to this archiving process, see below for list
including the relationship to the main Purchase order tables.
EKKO – Purchasing Document Header
EKPO – Purchasing Document Item
EKBE – History per Purchasing Document
EKBZ – History per Purchasing Document: Delivery Costs
EKAB – Release (Order) Documentation
EKKN – Account Assignment in Purchasing Document
EKET – Scheduling Agreement Schedule Lines
ESSR – Service Entry Sheet Header Data
ESKN – Account Assignment in Service Package
A019 – Contract Header
A016 – Contract Item
A068 – Outline Agreement Item: Plant-Dependent
KONM – Conditions (1-Dimensional Quantity Scale)
KONW – Conditions (1-Dimensional Value Scale)
KONP – Conditions (Item)
KONH – Conditions (Header)
KONV – Conditions (Transaction Data)
STXH – STXD SAPscript Text File Header
STXL – STXD SAPscript Text File Lines
CDHDR – Change Document Header
CDPOS – Change Document Items
EIKP – Foreign Trade: Export/Import: Header Data
EIPO – Foreign Trade: Export/Import: Item Data
NAST – Message Status
EKUB – Index for Stock Transport Orders for Material
EKPV – SD-Specific Data f. Stock Transfer for Purch. Doc.
RESB – Reservation/Dependent Requirements
EKES – Vendor Confirmations
EKPA – Partner Roles in Purchasing
EKBEH – Order History, Scheduling Agreement (Reorganized)
EKBZH – Delivery Costs History, Sched. Agreement (Reorg)
EKETH – Scheduling Agreement Schedule Lines (Reorganized)
EKEK – Scheduling Agreement Release History, Header
EKEH – Scheduling Agreement Release History, Sched. Lines
Purch. Order Tables and there relationship including Scheduling Agreement Releases
Details of how the Scheduling Agreement Releases tables EKEK and EKEH are related to PO data as well as the PRPS Project Structure Plan table.
EKKO – Purchasing Document Header
EKPO – Purchasing Document Item
EKKN – Account Assignment in Purchasing Document
EKES – Vendor Confirmations
EKAB – Release Documentation
EKBZ – History per Purchasing Document: Delivery Costs
EKBE – History per Purchasing Document
EKEK – Header Data for Scheduling Agreement Releases
EKEH – Scheduling Agreement Release Documentation
EKET – Scheduling Agreement Schedule Lines
T160T – Description of Selection Parameters
RESB – Reservation/Dependent Requirements
PRPS – PSP (Project Structure Plan) Element Master Data
