When you are working on the procurement process, understanding the EKKP table & EKPO table in SAP helps you generate the PO reports, working with PO enhancement & custom reports development.
The purchase order is one of the important documents of SAP MM (Material Management ) module issued to a supplier/vendor for procurements of goods/services. The purchase order (PO) primarily stores the data in two tables i.e.
- EKKP Table (PO Header Details)
- EKPO Table (PO Item details).
These two PO tables in SAP are used to manage the procurement process, tracking of Purchase order and integration with other SAP modules such as financial accounting(FI) and controlling (CO).
EKKO Table in SAP – PO Header Table
The EKKO table contains the header details of the purchase order (PO). Each PO in SAP contains a single entry header table which holds the information about the PO number, document type, organizational data, partners, and vendor details.
EKKP Table – Key Fields
The important fields in EKKO table are as follows
Field Name | Description |
EBELN | Purchase document number |
BUKRS | Company Code |
BSTYP | Purchase document category |
BSART | Purchase document type |
STATU | Status of purchasing document |
EKORG | Purchasing organization |
EKGRP | Purchasing Group |
BEDAT | Purchasing document date |
AEDAT | The date on which the record was created |
FRGKE | Release indicator |
FRGZU | Release Status |
ERNAM | Name of the person who created the Purchase order |
LIFNR | Vendor account number |
EKKP Table in SAP – PO Line Items Table
The EKKP table contains the line item details of the Purchase Order. Each PO can have multiple line items and each line item of PO contains details of document number, item no, material code, quantity, price, and delivery details.
EKKP Table Fields
The key fields in the PO line item table are:
Field Name | Description |
EBELN | Purchasing document number |
EBELP | Item number of purchasing document |
MATNR | Material Number |
BUKRS | Company Code |
MENGE | Purchase Order Quantity |
MEINS | Purchase order unit of measure |
NETWR | Net order value in PO currency |
BPRME | Order price unit |
PEINH | Price unit |
WERKS | Plant |
LGORT | Storage Location |
ELIKZ | Delivery indicator |
LOEKZ | Deletion indicator. |