# SAP open purchase orders report: ME2N, ME2M, ME2L and the underlying tables

> Source: https://netray.co/erp-help/sap-open-purchase-orders-report-me2n-ekbe-how-to
> Publisher: Netray (netray.co), AI and integration engineering for ERP and manufacturing systems.
> Section: ERP Help

## Short answer

Use ME2N for a flexible open PO list, ME2M by material and ME2L by vendor, with the selection parameter Still to be delivered. The open quantity is the scheduled quantity in EKET minus goods received in EKBE, excluding deleted and delivery-completed items. For custom reports, read EKKO, EKPO, EKET and EKBE.

## Kind

how-to

## System

sap

## Erp

SAP ECC / S/4HANA

## Module

MM Purchasing / PO Reporting

## Query

SAP open purchase orders report ME2N, how to list open PO quantity by vendor and material

## Alternate Queries

- SAP ME2N open purchase orders still to be delivered
- SAP EKKO EKPO EKET EKBE open quantity query
- SAP ME2M ME2L open PO report

## Applies To

SAP ECC 6.0 and S/4HANA (ME2N, ME2M, ME2L; ME80FN in newer releases)

## Steps

### List open POs and compute open quantity

**Items:**

- Run ME2N (Purchase Orders by PO Number). In the selection parameters tab, set Selection Parameter to WE101 (Still to be delivered) to restrict to items with open goods receipt quantity.
- Restrict by purchasing organization, plant, vendor, material or document date. Set the scope of list to a layout showing scheduled quantity, quantity delivered and still to be delivered.
- Use ME2M for a list by material and ME2L by vendor if you prefer those grouping views. ME2N is the most flexible since it takes any combination.
- Check Status of the item: deleted items (EKPO-LOEKZ) and items with the delivery completed flag (ELIKZ) should not count as open, and the report parameters normally exclude them.
- For a custom report, join EKKO and EKPO on EBELN, then EKET for the delivery schedule and EKBE for the history. Open quantity per schedule line is EKET-MENGE minus EKET-WEMNG.
- For items without schedule lines, use EKPO-MENGE minus the sum of goods receipt quantities from EKBE where VGABE is 1.
- Save the layout and variant in ME2N, and schedule a spool or export if buyers need a regular open-order list.

## Sections

### Which tables hold what

**Body:**

EKKO is the PO header: vendor (LIFNR), document type (BSART), purchasing organization (EKORG), group (EKGRP), currency and release fields. EKPO holds the items: material (MATNR), plant (WERKS), ordered quantity (MENGE), net price, deletion flag (LOEKZ), delivery completed (ELIKZ), final invoice (EREKZ) and account assignment category (KNTTP).

EKET holds the schedule lines with delivery date (EINDT), scheduled quantity (MENGE) and goods receipt quantity (WEMNG). EKBE is the PO history: one row per goods receipt, invoice receipt or other follow-on document, with the movement type, quantity and amount. In S/4HANA the tables still exist, and CDS views such as the purchase order item API sit on top.

Remember that ME2N derives its numbers from the same sources, so a custom query that agrees with ME2N is the best test of your logic.

**Code:**

- -- Open quantity per schedule line (HANA / ABAP SQL style)
- SELECT h.EBELN, i.EBELP, h.LIFNR, i.MATNR, i.WERKS,
-        s.EINDT, s.MENGE, s.WEMNG,
-        (s.MENGE - s.WEMNG) AS open_qty
- FROM EKKO h
- JOIN EKPO i ON i.EBELN = h.EBELN
- JOIN EKET s ON s.EBELN = i.EBELN AND s.EBELP = i.EBELP
- WHERE i.LOEKZ = ' ' AND i.ELIKZ = ' '
-   AND s.MENGE > s.WEMNG;

### Subtleties that change the answer

**Body:**

Returns and reversals: a goods receipt reversal appears in EKBE with the shkzg indicator S or H flipping the sign. If you sum quantities without respecting the debit/credit indicator, returns inflate your delivered quantity. Use the sign field or the signed quantity in the history rather than raw MENGE.

Overdelivery and underdelivery tolerances (EKPO-UEBTO, UNTTO) mean a line can be treated as complete with less than the ordered quantity. The delivery completed flag is the system's final word on whether more is expected.

Subcontracting, stock transport orders and scheduling agreements follow similar tables but with their own document types and, for scheduling agreements, the EKET lines with agreed cumulative quantities. Report them separately unless you know the combined view is meant.

### Reporting for buyers and planners

**Body:**

For expediting, add the confirmation data from vendor confirmations (EKES) and the requested delivery date. Open lines with a delivery date before today, and no confirmation, are the real overdue list. Open lines with an overdue date but a confirmed new date are tracked differently.

For finance, the open PO commitment is value-based: open quantity multiplied by the net price per unit, with the price unit (PEINH) taken into account. Do not multiply by the price without the unit divisor or values will be wrong by a factor of 100 or 1,000.

## Pitfalls

- Summing EKBE quantities without respecting debit/credit, so reversals count as deliveries.
- Ignoring the delivery completed flag and showing lines as open that the buyer has closed.
- Multiplying open quantity by net price without dividing by the price unit.
- Including deleted items or blocked POs in an open commitment report.
- Comparing a custom query with ME2N without matching selection settings such as release status.

## Ai Angle

A grounded assistant lets a buyer ask for open lines by vendor, plant or due date in plain language, and answers from EKKO, EKPO, EKET and EKBE with the query visible. The same logic handles the signed quantities and delivery completed flag consistently each time, which is where custom reports usually go wrong. It is read-only, and expediting emails or changes still need a person.

## Faq

### Which transaction shows open purchase orders in SAP?

**Answer:** ME2N is the most flexible: set the selection parameter to WE101 to show items still to be delivered. ME2M lists by material and ME2L by vendor. In newer releases ME80FN provides an ALV-based analysis of purchasing documents with similar selections and more layout options.

### How do I calculate open quantity in SQL?

**Answer:** For items with schedule lines, use EKET-MENGE minus EKET-WEMNG for lines where the item is not deleted (LOEKZ) and not delivery completed (ELIKZ). For items without schedule lines, subtract the net goods receipts in EKBE from the ordered quantity in EKPO, using the debit/credit indicator for reversals.

### Why does my custom report differ from ME2N?

**Answer:** Common reasons are reversals counted as deliveries, deleted or delivery-completed items included, different release status handling, and unit conversions. Align the selection parameters with ME2N first, then compare a single PO item to find the line where the numbers diverge.

### Can I get open PO value as well as quantity?

**Answer:** Yes, multiply open quantity by the net price and divide by the price unit (EKPO-PEINH), then apply the conversion between order price unit and order unit if they differ. Convert to a single currency using the exchange rate if the PO currencies vary and finance wants a total.

## Search terms

SAP open purchase orders report, SAP ME2N still to be delivered, SAP ME2M ME2L, SAP EKKO EKPO EKET EKBE, SAP open PO quantity query, SAP WE101 selection parameter, SAP PO history EKBE, SAP ME80FN

---
Talk to an engineer: https://netray.co/contact?intent=erp_ai | Machine catalog: https://netray.co/agent/catalog.json