Vendor On-Time Delivery Performance Report
Short answer: A custom ALV report that compares every goods receipt posted in the selected period with the delivery date of the purchase order and shows, per vendor, the number of on-time, early and late receipts, the on-time rate, the average and maximum delay and the in-full rate. It gives a measurable delivery scorecard in one list for vendor evaluation and supplier meetings.
- Estimated effort
- M · 4–6 working days
- System
- ECC and S/4HANA
- Tables
- 5
- Scope
- Global
- Built by
- NeKuDos Teknoloji
- Last updated
Why is the standard not enough?
ME2N and ME80FN show the order history item by item; they do not calculate the difference between the goods receipt date and the delivery date and give no rate per vendor. Standard vendor evaluation (the ME61–ME65 family) needs scoring criteria to be set up and periodic evaluation runs, and does not show tolerance days, early delivery and the in-full rate separately. Companies therefore match MB51 and ME2N output in Excel and build the monthly scorecard by hand.
Who uses it? Purchasing managers, supplier development and quality teams, 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 | Order header: vendor, purchasing organization, document type (driving table) | — | ECC + S/4 |
| EKPOPurchasing Document Item | Order item: material, plant, material group | EKPO-EBELN = EKKO-EBELN | ECC + S/4 |
| EKETPurchasing Schedule Lines | Schedule line: delivery date, statistical date, scheduled quantity | EKET-EBELN = EKPO-EBELN AND EKET-EBELP = EKPO-EBELP | ECC + S/4 |
| EKBEPurchasing Document History | Order history: goods receipt date, quantity and value | EKBE-EBELN = EKPO-EBELN AND EKBE-EBELP = EKPO-EBELP | ECC + S/4 |
| LFA1Vendor Master (General Section) | Vendor name | LFA1-LIFNR = EKKO-LIFNR | ECC + S/4 |
Selection screen parameters
| Parameter | Description | Type | Reference field | Required | Example |
|---|---|---|---|---|---|
| S_EKORG | Purchasing organization | Range / multiple | EKKO-EKORG | Yes | 1000 |
| S_WERKS | Plant | Range / multiple | EKPO-WERKS | No | 1100 |
| S_LIFNR | Vendor | Range / multiple | EKKO-LIFNR | No | 100387 |
| S_BUDAT | Goods receipt posting date | Range / multiple | EKBE-BUDAT | Yes | 01.01.2026 – 31.10.2026 |
| S_MATKL | Material group | Range / multiple | EKPO-MATKL | No | 01 |
| S_BSART | Order document type | Range / multiple | EKKO-BSART | No | NB |
| P_EARLY | Early delivery tolerance (days) | Single value | — | No | 3 |
| P_LATE | Late delivery tolerance (days) | Single value | — | No | 2 |
| R_EINDT | Compare with delivery date (otherwise statistical date) | Radio button | — | No | X |
Output columns
| # | Column | Source |
|---|---|---|
| 1 | Vendor | EKKO-LIFNR |
| 2 | Vendor name | LFA1-NAME1 |
| 3 | Purchasing org. | EKKO-EKORG |
| 4 | Plant | EKPO-WERKS |
| 5 | Receipts | Calculated Goods receipt lines counted in the period (net of reversals) |
| 6 | On time | Calculated Receipts whose delay is within the tolerance window |
| 7 | Early | Calculated Delay < −early tolerance |
| 8 | Late | Calculated Delay > late tolerance |
| 9 | On-time rate (%) | Calculated On time ÷ receipts × 100 |
| 10 | Avg. delay (days) | Calculated Average delay of late receipts (EKBE-BUDAT − EKET-EINDT) |
| 11 | Max. delay | Calculated Largest delay in days among late receipts |
| 12 | In-full rate (%) | Calculated Schedule lines received in full within tolerance ÷ schedule lines due × 100 |
| 13 | Received value | Calculated Σ EKBE-DMBTR (VGABE = 1, reversals negative) |
| 14 | Currency | EKBE-HSWAE |
| 15 | Grade | Calculated On-time rate ≥ 95% A, ≥ 85% B, otherwise C |
Sample output
| Vendor | Vendor name | Purchasing org. | Plant | Receipts | On time | Early | Late | On-time rate (%) | Avg. delay (days) | Max. delay | In-full rate (%) | Received value | Currency | Grade |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 100245 | Atlas Ambalaj | 1000 | 1100 | 142 | 136 | 2 | 4 | 95.80 | 3.50 | 6 | 98.60 | 1,845,200 | TRY | A |
| 100387 | Delta Metal | 1000 | 1100 | 88 | 71 | 5 | 12 | 80.70 | 9.20 | 27 | 91 | 2,410,750 | TRY | C |
| 100512 | Ege Kimya | 1000 | 1200 | 64 | 57 | 3 | 4 | 89.10 | 4.80 | 9 | 100 | 356,900 | TRY | B |
| 100618 | Marmara Kablo | 1000 | 1100 | 37 | 33 | 0 | 4 | 89.20 | 2.30 | 5 | 94.60 | 512,300 | TRY | B |
How does the report work?
- EKKO and EKPO are read by purchasing organization, document type, vendor, plant and material group; deleted items (LOEKZ) and items without goods receipt are excluded.
- Goods receipts in the period (VGABE = 1) are read from EKBE; reversals (SHKZG = H) are deducted from the quantity of the receipt they cancel.
- Each receipt quantity is allocated in date order (FIFO) to the first EKET schedule line not yet covered. The reference date is EKET-EINDT (delivery date) or EKET-SLFDT (statistical delivery date), depending on the radio button.
- Delay = EKBE-BUDAT − reference date. If the delay lies between −early tolerance and +late tolerance the receipt is on time, below it early, above it late. A schedule line counts as in full when its quantity was received completely within the late tolerance.
- Results are summed by vendor, purchasing organization and plant; an on-time rate of ≥ 95% gives grade A, ≥ 85% grade B and below that grade C (thresholds are set during installation). The vendor line drills down to item detail.
Performance notes
Restrict EKBE by period and order list first, and read EKET for the same order list in one go. Even for a year of data the report usually runs in under a minute; the monthly scorecard can be prepared by a background job and sent by email.
Features
- ALV list (sort, filter, subtotals)
- User-specific layout variants
- Double-click drill-down to the document The vendor line opens the item-level receipt list, the order number opens ME23N and the material document opens MIGO display.
- Export to Excel
- Runs as a background job
- Send the result by email The monthly scorecard can be emailed to each purchasing group or vendor owner.
Authorization objects
- M_BEST_EKOPurchase order display authorization by purchasing organization
- M_BEST_WRKPurchase order display authorization by plant
Frequently asked questions
How is the delay calculated when an order item is split into several schedule lines?
Goods receipts are allocated to schedule lines in date order. The first delivery is compared with the date of the first schedule line and the next delivery with the next line, so partial deliveries put the delay on the right line.
Which date is used when the delivery date was changed?
If the delivery date was postponed later, EKET-EINDT carries the new date. To measure the vendor against the originally agreed date, the statistical delivery date (EKET-SLFDT) can be chosen; it stays the same when the date is moved.
Does the report work on S/4HANA?
Yes. EKKO, EKPO, EKET and EKBE keep the same structure in S/4HANA. The Fiori supplier evaluation apps use a different scoring logic; this report applies tolerance days as the company defines them.
Related reports
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 …
Automatic Vendor Reminder Email for Overdue Purchase Orders
A custom program that runs every morning in the background, collects overdue open purchase order lines per vendor and sends each vendor one email with …
Vendor Quality Scorecard and Rejection Rate (PPM) Report
A custom ALV report that shows, per vendor and material, the lot rejection rate from goods receipt inspection lots, the rejected quantity in parts per …
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.