SAP Purchase Order tables



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

About the Author se80