Open Purchase Orders by Vendor Report
Short answer: 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.
- Estimated effort
- S · 2–4 working days
- System
- ECC and S/4HANA
- Tables
- 5
- Scope
- Global
- Built by
- NeKuDos Teknoloji
- Last updated
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.
Who uses it? Buyers, purchasing managers and supply chain planners.
Closest standard alternatives
Tables used
The tables the report reads and their join fields. ECC and S/4HANA differences are marked separately.
| Table | Role | Join | System |
|---|---|---|---|
| EKKOPurchasing Document Header | Vendor, company code, purchasing organization and currency (driving table) | — | ECC + S/4 |
| EKPOPurchasing Document Item | Material, plant and price; deleted and completed items are excluded | EKPO-EBELN = EKKO-EBELN | ECC + S/4 |
| EKETPurchasing Schedule Lines | Delivery date, scheduled and delivered quantity | EKET-EBELN = EKPO-EBELN AND EKET-EBELP = EKPO-EBELP | ECC + S/4 |
| LFA1Vendor Master (General Section) | Vendor name | LFA1-LIFNR = EKKO-LIFNR | ECC + S/4 |
| I_PurchaseOrderItemAPI01Purchase Order Item (CDS) | In S/4HANA it can replace EKPO with a clean core approach | PurchaseOrder = EKKO-EBELN | S/4HANA only |
Selection screen parameters
| Parameter | Description | Type | Reference field | Required | Example |
|---|---|---|---|---|---|
| S_BUKRS | Company code | Range / multiple | EKKO-BUKRS | Yes | 1000 |
| S_EKORG | Purchasing organization | Range / multiple | EKKO-EKORG | No | 1000 |
| S_EKGRP | Purchasing group | Range / multiple | EKKO-EKGRP | No | 001 |
| S_LIFNR | Vendor | Range / multiple | EKKO-LIFNR | No | 100245 |
| S_WERKS | Plant | Range / multiple | EKPO-WERKS | No | 1000 |
| S_MATNR | Material | Range / multiple | EKPO-MATNR | No | RM-1001 |
| S_EINDT | Delivery date range | Range / multiple | EKET-EINDT | No | 01.10.2026 – 30.11.2026 |
| P_KEYDT | Key date for delay calculation (default: today) | Single value | SY-DATUM | Yes | 16.11.2026 |
| P_OVERDU | Overdue only | Checkbox | — | No | X |
Output columns
| # | Column | Source |
|---|---|---|
| 1 | Purchase order | EKKO-EBELN |
| 2 | Item | EKPO-EBELP |
| 3 | Vendor | EKKO-LIFNR |
| 4 | Vendor name | LFA1-NAME1 |
| 5 | Material | EKPO-MATNR |
| 6 | Short text | EKPO-TXZ01 |
| 7 | Plant | EKPO-WERKS |
| 8 | Delivery date | EKET-EINDT |
| 9 | Scheduled qty | EKET-MENGE |
| 10 | Received qty | EKET-WEMNG |
| 11 | Open qty | Calculated EKET-MENGE − EKET-WEMNG |
| 12 | Unit | EKPO-MEINS |
| 13 | Open value | Calculated Open qty × EKPO-NETPR ÷ EKPO-PEINH |
| 14 | Currency | EKKO-WAERS |
| 15 | Days late | Calculated Key date − EKET-EINDT (negative value: days until due) |
Sample output
| Purchase order | Item | Vendor | Vendor name | Material | Short text | Plant | Delivery date | Scheduled qty | Received qty | Open qty | Unit | Open value | Currency | Days late |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 4500012345 | 00010 | 100245 | Atlas Ambalaj | RM-1001 | Carton box 40x30 | 1000 | 10/20/2026 | 5,000 | 3,000 | 2,000 | PC | 8,500 | TRY | 27 |
| 4500012345 | 00020 | 100245 | Atlas Ambalaj | RM-1002 | Stretch film 50 cm | 1000 | 11/05/2026 | 1,200 | 0 | 1,200 | KG | 46,200 | TRY | 11 |
| 4500012398 | 00010 | 100387 | Delta Metal | RM-2040 | Steel sheet 2 mm | 2000 | 11/28/2026 | 800 | 0 | 800 | KG | 48,960 | TRY | -12 |
| 4500012410 | 00010 | 100512 | Ege Kimya | RM-3105 | Solvent-based paint | 1000 | 10/02/2026 | 300 | 120 | 180 | L | 25,560 | TRY | 45 |
How does the report work?
- EKKO and EKPO are read with the selection-screen criteria; items with a deletion indicator (LOEKZ) or the delivery completed flag (ELIKZ) are skipped.
- The EKET schedule lines of each item are read. Open quantity = scheduled quantity (MENGE) − quantity delivered (WEMNG). Lines with zero open quantity are skipped.
- Open value = open quantity × net price (NETPR) ÷ price unit (PEINH). If the order price unit differs from the order unit, a conversion is applied.
- Days late = key date − delivery date (EINDT). With “Overdue only” selected, only positive values remain.
- The vendor name is added from LFA1. The result is shown in ALV with subtotals per vendor.
Performance notes
Narrow the EKKO selection by company code and purchasing organization. Read EKET in a single JOIN or FOR ALL ENTRIES. On very large systems, run the report as a nightly background job.
Features
- ALV list (sort, filter, subtotals)
- User-specific layout variants
- Double-click drill-down to the document Double-clicking the order number opens ME23N.
- Export to Excel
- Runs as a background job
- Send the result by email Each purchasing group can receive its own delays weekly.
Authorization objects
- M_BEST_BSADisplay authorization by purchasing document type
- M_BEST_EKODisplay authorization by purchasing organization
- M_BEST_EKGDisplay authorization by purchasing group
- M_BEST_WRKDisplay 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.
Packages that include this solution
Purchasing and Payables Control Pack
A ready-made two-report pack that tracks open purchase orders per vendor and overdue payables to the same vendors with one shared vendor selection. …
Related reports
Vendor Open Items Aging Report
A custom ALV report that ages vendor open items by net due date and spreads the amounts into not-due, 0–30, 31–60, 61–90 and 90+ day buckets. The …
Stock Aging Report
A custom ALV report that shows how many days each material has been in stock since its last goods receipt and which age bucket (0–30, 31–90, 91–180, …
Let us build this report for your system
Briefly describe your system and expectations. We will clarify the scope and come back with an effort and price quote.