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.

  1. EKKP Table (PO Header Details)
  2. 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 NameDescription
EBELNPurchase document number
BUKRSCompany Code
BSTYPPurchase document category
BSARTPurchase document type
STATUStatus of purchasing document
EKORGPurchasing organization
EKGRPPurchasing Group
BEDATPurchasing document date
AEDATThe date on which the record was created
FRGKERelease indicator
FRGZURelease Status
ERNAMName of the person who created the Purchase order
LIFNRVendor account number

EKKO Table in SAP

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 NameDescription
EBELNPurchasing document number
EBELPItem number of purchasing document
MATNRMaterial Number
BUKRSCompany Code
MENGEPurchase Order Quantity
MEINSPurchase order unit of measure
NETWRNet order value in PO currency
BPRMEOrder price unit
PEINHPrice unit
WERKSPlant
LGORTStorage Location
ELIKZDelivery indicator
LOEKZDeletion indicator.

EKPO Table in SAP