Periodic Vendor Evaluation and Scoring Report by Price, Delivery, Quantity and Quality
Short answer: A custom ALV report that scores every vendor from 0 to 100 for the selected period on price compliance, on-time delivery, quantity reliability and quality (acceptance rate), combines the criteria with weights set by the company and gives a total score and an A/B/C class. Purchasing gets a scorecard with a traceable calculation, ready for vendor meetings and the yearly supplier selection, compared with the previous period.
- Estimated effort
- M · 6–9 working days
- System
- ECC and S/4HANA
- Tables
- 9
- Scope
- Global
- Built by
- NeKuDos Teknoloji
- Last updated
Why is the standard not enough?
The standard vendor evaluation (ME61, ME63, ME64, ME65) requires main criteria, subcriteria and weights to be configured and scores to be recalculated periodically. Scores are stored as the value of the last calculation rather than per period, and it is hard to see which orders a score came from; the quality criterion is not meaningful without QM integration. The custom report calculates the scores directly from the order, goods receipt and inspection data of the selected period, shows each criterion in its own column and compares with the previous period.
Who uses it? Purchasing managers, buyers, supplier quality and supply chain teams.
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 |
|---|---|---|---|
| EKBEPurchasing Document History | Goods receipts and returns in the period (driving table) | — | ECC + S/4 |
| EKKOPurchasing Document Header | Order header: vendor, purchasing organization | EKKO-EBELN = EKBE-EBELN | ECC + S/4 |
| EKPOPurchasing Document Item | Order item: net price, quantity, material group | EKPO-EBELN = EKBE-EBELN AND EKPO-EBELP = EKBE-EBELP | ECC + S/4 |
| EKETPurchasing Schedule Lines | Planned delivery date and quantity | EKET-EBELN = EKPO-EBELN AND EKET-EBELP = EKPO-EBELP | ECC + S/4 |
| EINEPurchasing Info Record: Purchasing Organization Data | Info record price (price score comparison) | EINE-INFNR = EKPO-INFNR AND EINE-EKORG = EKKO-EKORG | ECC + S/4 |
| QALSInspection Lot Record | Goods receipt inspection lots (origin 01) | QALS-EBELN = EKPO-EBELN AND QALS-EBELP = EKPO-EBELP | ECC + S/4 |
| QAVEUsage Decision | Usage decision and valuation (accept/reject) | QAVE-PRUEFLOS = QALS-PRUEFLOS | ECC + S/4 |
| LFA1Vendor Master (General Section) | Vendor name | LFA1-LIFNR = EKKO-LIFNR | ECC + S/4 |
| I_PurchaseOrderHistoryAPI01Purchase Order History (API) | In S/4HANA it can replace EKBE with a clean core approach | PurchaseOrder = EKBE-EBELN | S/4HANA only |
Selection screen parameters
| Parameter | Description | Type | Reference field | Required | Example |
|---|---|---|---|---|---|
| S_EKORG | Purchasing organization | Range / multiple | EKKO-EKORG | Yes | 1000 |
| S_LIFNR | Vendor | Range / multiple | EKKO-LIFNR | No | 100245 |
| S_MATKL | Material group | Range / multiple | EKPO-MATKL | No | HAMMADDE |
| S_BUDAT | Evaluation period (goods receipt date) | Range / multiple | EKBE-BUDAT | Yes | 01.07.2026 – 31.10.2026 |
| P_TOLD | Delivery tolerance (days) | Single value | — | No | 3 |
| P_WPRC | Price weight (%) | Single value | — | No | 30 |
| P_WDEL | Delivery weight (%) | Single value | — | No | 30 |
| P_WQTY | Quantity weight (%) | Single value | — | No | 10 |
| P_WQUA | Quality weight (%) | Single value | — | No | 30 |
| P_PREV | Compare with previous period | Checkbox | — | No | X |
Output columns
| # | Column | Source |
|---|---|---|
| 1 | Vendor | EKKO-LIFNR |
| 2 | Vendor name | LFA1-NAME1 |
| 3 | Goods receipts | Calculated Number of EKBE goods receipt lines in the period |
| 4 | Purchase volume | Calculated Σ EKBE-DMBTR (goods receipts) |
| 5 | Price score | Calculated 100 − (% above info record × deduction factor) |
| 6 | Delivery score | Calculated On-time receipts / all receipts × 100 |
| 7 | Quantity score | Calculated Receipts within tolerance / all receipts × 100 |
| 8 | Quality score | Calculated Accepted lots / lots with decision × 100 |
| 9 | Total score | Calculated Σ (criterion score × weight) |
| 10 | Class | Calculated A ≥ 85, B 70–84, C < 70 |
| 11 | Previous period score | Calculated Same calculation for the previous period of equal length |
| 12 | Change | Calculated Total score − previous period score |
Sample output
| Vendor | Vendor name | Goods receipts | Purchase volume | Price score | Delivery score | Quantity score | Quality score | Total score | Class | Previous period score | Change |
|---|---|---|---|---|---|---|---|---|---|---|---|
| 100245 | Atlas Ambalaj | 48 | 2,185,000 | 92 | 88 | 97 | 95 | 92.20 | A | 89.10 | 3.10 |
| 100387 | Delta Metal | 31 | 1,460,000 | 78 | 65 | 90 | 88 | 78.30 | B | 81 | -2.70 |
| 100512 | Ege Kimya | 22 | 640,000 | 85 | 94 | 100 | 70 | 84.70 | B | 84.10 | 0.60 |
| 100733 | Kuzey Plastik | 15 | 312,000 | 60 | 52 | 80 | 75 | 64.10 | C | 70.40 | -6.30 |
How does the report work?
- Goods receipts of the period are read from EKBE (movement types 101 and 122, transaction type goods receipt) by purchasing organization, vendor and material group; order data comes from EKKO/EKPO.
- Price score: the order net price is compared with the valid info record price (EINE-NETPR) for the same material and purchasing organization; a price at or below the info record earns full points and an adjustable number of points is deducted for every 1% above it.
- Delivery score: the goods receipt date is compared with the delivery date in EKET; receipts within the tolerance days count as on time. Score = on-time receipts / all receipts × 100.
- Quantity score: the ratio of received to planned quantity; under- or over-deliveries outside the tolerance and returns (122) lower the score.
- Quality score: the vendor’s goods receipt inspection lots are read from QALS (origin 01) and usage decisions from QAVE. Score = accepted lots / lots with a decision × 100. If QM is not used, the return rate is used instead.
- The total score uses the criterion weights (default price 30%, delivery 30%, quantity 10%, quality 30%); 85 and above is class A, 70–84 B, below that C. The same calculation is run for the previous period of equal length and the change is shown.
Performance notes
Restrict EKBE by posting date and transaction type; read QALS with origin 01 and the selected vendor list. Do the previous-period comparison with two date ranges in the same read instead of a second run. For large purchasing organizations run the report in the background at month end and keep the result.
Features
- ALV list (sort, filter, subtotals)
- User-specific layout variants
- Double-click drill-down to the document From the vendor line you can drill down to the goods receipts and inspection lots behind the score.
- Export to Excel
- Runs as a background job
- Send the result by email At period end the scorecard can be emailed to the purchasing groups.
Authorization objects
- M_BEST_EKODisplay authorization by purchasing organization
- M_BEST_EKGDisplay authorization by purchasing group
Frequently asked questions
Can the criterion weights be changed?
Yes. Weights are entered on the selection screen and can be saved as variants per material group; for example quality can weigh more for chemicals and price more for packaging. The report warns if the weights do not add up to 100.
Does it change the standard vendor evaluation?
No. The report only reads; it does not touch the scores maintained with ME61. If wanted, the standard scores can be shown in an extra column for comparison.
Does it work on S/4HANA?
Yes. EKBE, EKET, QALS and QAVE are the same in S/4HANA. If clean core is preferred, the order history is read from I_PurchaseOrderHistoryAPI01 and inspection lots from I_InspectionLot.
Related reports
Purchase Price Variance (PPV) Report by Vendor and Material Group
A custom ALV report that compares the unit price on purchase orders with the material's standard or moving average price, the price in the purchasing …
Vendor On-Time Delivery Performance Report
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 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.