Skip to content
IT Canvass
SAP tables · Lesson

EKPO

Quick answer

EKPO is where PO line detail lives, quantities, prices, plant, account assignment.

Key takeaways

  • 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).

  • EKKO, purchasing header.
  • EKET, schedule lines.
  • EKBE, PO history.
  • MARA/MAKT, material data/text.

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.

Want to learn this properly?

Our live, instructor-led SAP Training covers this hands-on, with real projects and a certification path.

Check your understanding

  1. Which statement is true of EKPO?

    • A. SAP Cloud Integration (CPI), part of the Integration Suite, is the cloud middleware for integrating SAP and…
    • B. Asset Accounting (AA) is the FI sub-ledger for managing fixed assets, from acquisition through depreciation…
    • C. It links back to the header (EKKO) via EBELN and to schedule lines (EKET) and history (EKBE).
    Show answer

    C. It links back to the header (EKKO) via EBELN and to schedule lines (EKET) and history (EKBE).

    Covered in the “Keys and relationships” section of this lesson.

  2. Which of these also applies to EKPO?

    • A. Misconfigured conditions, wrong docs caught or missed.
    • B. Learning features, not the end-to-end process.
    • C. It is one of the most-queried MM tables for procurement reporting.
    Show answer

    C. It is one of the most-queried MM tables for procurement reporting.

    Covered in the “Working with it” section of this lesson.

  3. Which part of the Learn SAP curriculum covers EKPO?

    • A. SAP tables
    • B. SAP best practices
    • C. SAP reference
    Show answer

    A. SAP tables

    This lesson sits in the SAP tables section of the Learn SAP course.

Frequently asked questions

What does EKPO stand for in SAP?

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.

Which fields matter most in EKPO?

The key is EBELN + EBELP, one row per PO line.

What is worth remembering about EKPO in practice?

EKPO is where PO line detail lives, quantities, prices, plant, account assignment.

What tends to go wrong with EKPO?

Reading tables directly instead of using CDS/reports where appropriate. Ignoring header/item relationships. Performance: querying large tables without indexed selection.
CallWhatsAppEnquire