EKPO
EKPO is a key SAP table in MM (Purchasing). It stores purchasing document items, the line-level data (materials, quantities, prices, plant) of purchase orders and related documents.
EKPO is where PO line detail lives, quantities, prices, plant, account assignment.
- The key is EBELN + EBELP, one row per PO line.
- EBELN, purchasing document (key).
- EBELP, item number (key).
- Watch out: Reading tables directly instead of using CDS/reports where appropriate.
What it stores
It stores purchasing document items, the line-level data (materials, quantities, prices, plant) of purchase orders and related documents.
Key fields
- EBELN, purchasing document (key).
- EBELP, item number (key).
- MATNR, material.
- MENGE, quantity; NETPR, net price.
- WERKS, plant.
Keys and relationships
The key is EBELN + EBELP, one row per PO line. It links back to the header (EKKO) via EBELN and to schedule lines (EKET) and history (EKBE).
Working with it
EKPO is where PO line detail lives, quantities, prices, plant, account assignment. It is one of the most-queried MM tables for procurement reporting. View its structure in SE11 and its data (with authorization) in SE16N.
Common pitfalls
- Reading tables directly instead of using CDS/reports where appropriate.
- Ignoring header/item relationships.
- Performance: querying large tables without indexed selection.