SAP Purchasing Tables - PO EKKO EKPO

SAP Purchase order tables and relationships EKKO PO Header EKPO items








Below is a list of Purchase order related SAP database tables, details of the data they store and how they are related to each other. Also click on the table name for full details of all fields incluing which make up the table key.

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 relationships 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 be 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