MM Report Custom development ALV report

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

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

Tables used

The tables the report reads and their join fields. ECC and S/4HANA differences are marked separately.

TableRoleJoinSystem
EKBEPurchasing Document HistoryGoods receipts and returns in the period (driving table)—ECC + S/4
EKKOPurchasing Document HeaderOrder header: vendor, purchasing organizationEKKO-EBELN = EKBE-EBELNECC + S/4
EKPOPurchasing Document ItemOrder item: net price, quantity, material groupEKPO-EBELN = EKBE-EBELN AND EKPO-EBELP = EKBE-EBELPECC + S/4
EKETPurchasing Schedule LinesPlanned delivery date and quantityEKET-EBELN = EKPO-EBELN AND EKET-EBELP = EKPO-EBELPECC + S/4
EINEPurchasing Info Record: Purchasing Organization DataInfo record price (price score comparison)EINE-INFNR = EKPO-INFNR AND EINE-EKORG = EKKO-EKORGECC + S/4
QALSInspection Lot RecordGoods receipt inspection lots (origin 01)QALS-EBELN = EKPO-EBELN AND QALS-EBELP = EKPO-EBELPECC + S/4
QAVEUsage DecisionUsage decision and valuation (accept/reject)QAVE-PRUEFLOS = QALS-PRUEFLOSECC + S/4
LFA1Vendor Master (General Section)Vendor nameLFA1-LIFNR = EKKO-LIFNRECC + S/4
I_PurchaseOrderHistoryAPI01Purchase Order History (API)In S/4HANA it can replace EKBE with a clean core approachPurchaseOrder = EKBE-EBELNS/4HANA only

Selection screen parameters

ParameterDescriptionTypeReference fieldRequiredExample
S_EKORGPurchasing organizationRange / multipleEKKO-EKORGYes1000
S_LIFNRVendorRange / multipleEKKO-LIFNRNo100245
S_MATKLMaterial groupRange / multipleEKPO-MATKLNoHAMMADDE
S_BUDATEvaluation period (goods receipt date)Range / multipleEKBE-BUDATYes01.07.2026 – 31.10.2026
P_TOLDDelivery tolerance (days)Single value—No3
P_WPRCPrice weight (%)Single value—No30
P_WDELDelivery weight (%)Single value—No30
P_WQTYQuantity weight (%)Single value—No10
P_WQUAQuality weight (%)Single value—No30
P_PREVCompare with previous periodCheckbox—NoX

Output columns

#ColumnSource
1VendorEKKO-LIFNR
2Vendor nameLFA1-NAME1
3Goods receiptsCalculated Number of EKBE goods receipt lines in the period
4Purchase volumeCalculated Σ EKBE-DMBTR (goods receipts)
5Price scoreCalculated 100 − (% above info record × deduction factor)
6Delivery scoreCalculated On-time receipts / all receipts × 100
7Quantity scoreCalculated Receipts within tolerance / all receipts × 100
8Quality scoreCalculated Accepted lots / lots with decision × 100
9Total scoreCalculated Σ (criterion score × weight)
10ClassCalculated A ≥ 85, B 70–84, C < 70
11Previous period scoreCalculated Same calculation for the previous period of equal length
12ChangeCalculated Total score − previous period score

Sample output

VendorVendor nameGoods receiptsPurchase volumePrice scoreDelivery scoreQuantity scoreQuality scoreTotal scoreClassPrevious period scoreChange
100245Atlas Ambalaj482,185,0009288979592.20A89.103.10
100387Delta Metal311,460,0007865908878.30B81-2.70
100512Ege Kimya22640,00085941007084.70B84.100.60
100733Kuzey Plastik15312,0006052807564.10C70.40-6.30
A view built with fictional sample data; not real system data.

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.

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

MM Report Custom ALV report

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 …

EKKO · EKPO · EKET · EKBE

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.

Related report: Periodic Vendor Evaluation and Scoring Report by Price, Delivery, Quantity and Quality