# Open Purchase Orders by Vendor Report

> A custom ALV report that shows, per vendor, the quantity not yet received, the open order value and the days of delay since the delivery date in a single list. Purchasing teams see which vendor is late on which item, and by how many days, without stitching data together in Excel.

- Type: Report, Custom development, ALV report
- Module: MM
- Estimated effort: S (2–4 working days)
- Last updated: 2026-11-16
- URL: https://nekuhub.com/en/reports/open-purchase-orders-by-vendor-report/


## Why is the standard not enough?

ME2L and ME2N list open orders, but they do not show the total open value per vendor, the number of days late and the open quantity per schedule line on one screen. Teams usually build this by merging several lists in Excel. The custom report does it in one run and can email it weekly to each purchasing group.

### Closest standard alternatives

- ME2L: Lists open orders per vendor with scope of list WE101; no days late and no total open value per vendor.
- ME2N: Open quantity and value can be added in ALV, but it does not calculate delay per schedule line.

## Tables used

| Table | Role | Access | Join | System |
|---|---|---|---|---|
| EKKO | Vendor, company code, purchasing organization and currency (driving table) | Read | - | ECC + S/4 |
| EKPO | Material, plant and price; deleted and completed items are excluded | Read | EKPO-EBELN = EKKO-EBELN | ECC + S/4 |
| EKET | Delivery date, scheduled and delivered quantity | Read | EKET-EBELN = EKPO-EBELN AND EKET-EBELP = EKPO-EBELP | ECC + S/4 |
| LFA1 | Vendor name | Read | LFA1-LIFNR = EKKO-LIFNR | ECC + S/4 |
| I_PurchaseOrderItemAPI01 | In S/4HANA it can replace EKPO with a clean core approach | Read | PurchaseOrder = EKKO-EBELN | S/4HANA only |

## Selection screen parameters

| Parameter | Description | Type | Reference field | Required |
|---|---|---|---|---|
| S_BUKRS | Company code | Range / multiple | EKKO-BUKRS | Yes |
| S_EKORG | Purchasing organization | Range / multiple | EKKO-EKORG | No |
| S_EKGRP | Purchasing group | Range / multiple | EKKO-EKGRP | No |
| S_LIFNR | Vendor | Range / multiple | EKKO-LIFNR | No |
| S_WERKS | Plant | Range / multiple | EKPO-WERKS | No |
| S_MATNR | Material | Range / multiple | EKPO-MATNR | No |
| S_EINDT | Delivery date range | Range / multiple | EKET-EINDT | No |
| P_KEYDT | Key date for delay calculation (default: today) | Single value | SY-DATUM | Yes |
| P_OVERDU | Overdue only | Checkbox | - | No |

## Output columns

| Column | Source |
|---|---|
| Purchase order | EKKO-EBELN |
| Item | EKPO-EBELP |
| Vendor | EKKO-LIFNR |
| Vendor name | LFA1-NAME1 |
| Material | EKPO-MATNR |
| Short text | EKPO-TXZ01 |
| Plant | EKPO-WERKS |
| Delivery date | EKET-EINDT |
| Scheduled qty | EKET-MENGE |
| Received qty | EKET-WEMNG |
| Open qty | Calculated: EKET-MENGE − EKET-WEMNG |
| Unit | EKPO-MEINS |
| Open value | Calculated: Open qty × EKPO-NETPR ÷ EKPO-PEINH |
| Currency | EKKO-WAERS |
| Days late | Calculated: Key date − EKET-EINDT (negative value: days until due) |

## How does the report work?

1. EKKO and EKPO are read with the selection-screen criteria; items with a deletion indicator (LOEKZ) or the delivery completed flag (ELIKZ) are skipped.
2. The EKET schedule lines of each item are read. Open quantity = scheduled quantity (MENGE) − quantity delivered (WEMNG). Lines with zero open quantity are skipped.
3. Open value = open quantity × net price (NETPR) ÷ price unit (PEINH). If the order price unit differs from the order unit, a conversion is applied.
4. Days late = key date − delivery date (EINDT). With "Overdue only" selected, only positive values remain.
5. The vendor name is added from LFA1. The result is shown in ALV with subtotals per vendor.

## Authorization objects

- M_BEST_BSA: Display authorization by purchasing document type
- M_BEST_EKO: Display authorization by purchasing organization
- M_BEST_EKG: Display authorization by purchasing group
- M_BEST_WRK: Display authorization by plant

## Frequently asked questions

### How is the open order quantity calculated?

For each schedule line, EKET-MENGE (scheduled quantity) minus EKET-WEMNG (quantity delivered). Items flagged as delivery completed (EKPO-ELIKZ) are not treated as open.

### Does this report work on S/4HANA?

Yes. EKKO, EKPO and EKET keep the same structure in S/4HANA. For a clean core approach, the I_PurchaseOrderItemAPI01 CDS view can replace EKPO.

### Why build a custom report when ME2L exists?

ME2L gives the order list; it does not give days late, total open value per vendor and schedule-line detail on the same screen. The custom report combines them and can distribute the result by email.

---
Let us build this report for your system: https://nekuhub.com/en/request-a-quote/?report=mm-open-po-by-vendor
