# Periodic Vendor Evaluation and Scoring Report by Price, Delivery, Quantity and Quality

> 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.

- Type: Report, Custom development, ALV report
- Module: MM
- Estimated effort: M (6–9 working days)
- Last updated: 2026-11-17
- URL: https://nekuhub.com/en/reports/periodic-vendor-evaluation-and-scoring-report/


## 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.

### Closest standard alternatives

- ME65: Ranks vendors by score; scores must be calculated beforehand with ME61/ME63 and there is no period comparison.
- ME64: Compares the scores of selected vendors; the documents behind a score are not shown.

## Tables used

| Table | Role | Access | Join | System |
|---|---|---|---|---|
| EKBE | Goods receipts and returns in the period (driving table) | Read | - | ECC + S/4 |
| EKKO | Order header: vendor, purchasing organization | Read | EKKO-EBELN = EKBE-EBELN | ECC + S/4 |
| EKPO | Order item: net price, quantity, material group | Read | EKPO-EBELN = EKBE-EBELN AND EKPO-EBELP = EKBE-EBELP | ECC + S/4 |
| EKET | Planned delivery date and quantity | Read | EKET-EBELN = EKPO-EBELN AND EKET-EBELP = EKPO-EBELP | ECC + S/4 |
| EINE | Info record price (price score comparison) | Read | EINE-INFNR = EKPO-INFNR AND EINE-EKORG = EKKO-EKORG | ECC + S/4 |
| QALS | Goods receipt inspection lots (origin 01) | Read | QALS-EBELN = EKPO-EBELN AND QALS-EBELP = EKPO-EBELP | ECC + S/4 |
| QAVE | Usage decision and valuation (accept/reject) | Read | QAVE-PRUEFLOS = QALS-PRUEFLOS | ECC + S/4 |
| LFA1 | Vendor name | Read | LFA1-LIFNR = EKKO-LIFNR | ECC + S/4 |
| I_PurchaseOrderHistoryAPI01 | In S/4HANA it can replace EKBE with a clean core approach | Read | PurchaseOrder = EKBE-EBELN | S/4HANA only |

## Selection screen parameters

| Parameter | Description | Type | Reference field | Required |
|---|---|---|---|---|
| S_EKORG | Purchasing organization | Range / multiple | EKKO-EKORG | Yes |
| S_LIFNR | Vendor | Range / multiple | EKKO-LIFNR | No |
| S_MATKL | Material group | Range / multiple | EKPO-MATKL | No |
| S_BUDAT | Evaluation period (goods receipt date) | Range / multiple | EKBE-BUDAT | Yes |
| P_TOLD | Delivery tolerance (days) | Single value | - | No |
| P_WPRC | Price weight (%) | Single value | - | No |
| P_WDEL | Delivery weight (%) | Single value | - | No |
| P_WQTY | Quantity weight (%) | Single value | - | No |
| P_WQUA | Quality weight (%) | Single value | - | No |
| P_PREV | Compare with previous period | Checkbox | - | No |

## Output columns

| Column | Source |
|---|---|
| Vendor | EKKO-LIFNR |
| Vendor name | LFA1-NAME1 |
| Goods receipts | Calculated: Number of EKBE goods receipt lines in the period |
| Purchase volume | Calculated: Σ EKBE-DMBTR (goods receipts) |
| Price score | Calculated: 100 − (% above info record × deduction factor) |
| Delivery score | Calculated: On-time receipts / all receipts × 100 |
| Quantity score | Calculated: Receipts within tolerance / all receipts × 100 |
| Quality score | Calculated: Accepted lots / lots with decision × 100 |
| Total score | Calculated: Σ (criterion score × weight) |
| Class | Calculated: A ≥ 85, B 70–84, C < 70 |
| Previous period score | Calculated: Same calculation for the previous period of equal length |
| Change | Calculated: Total score − previous period score |

## How does the report work?

1. 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.
2. 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.
3. 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.
4. Quantity score: the ratio of received to planned quantity; under- or over-deliveries outside the tolerance and returns (122) lower the score.
5. 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.
6. 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.

## Authorization objects

- M_BEST_EKO: Display authorization by purchasing organization
- M_BEST_EKG: Display 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.

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