Vendor Quality Scorecard and Rejection Rate (PPM) Report
Short answer: 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 million (PPM), the quality notifications raised against the vendor and the decisions of the latest lots on one line. Purchasing and quality teams get a scorecard ready for the vendor review meeting.
- Estimated effort
- M · 4–6 working days
- System
- ECC and S/4HANA
- Tables
- 6
- Scope
- Global
- Built by
- NeKuDos Teknoloji
- Last updated
Why is the standard not enough?
QA33 lists lots with a usage decision one by one and QM11 shows notifications separately. Standard quality evaluations depend on info structures and their updates, and they do not give the rejected quantity in PPM together with the notification count and the decision sequence of the latest lots on one line. Vendor scorecards are therefore usually built by hand in Excel.
Who uses it? Supplier quality engineers, purchasing managers and quality managers.
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 |
|---|---|---|---|
| QAVEUsage Decision | Usage decision: code, valuation (accept/reject) and date (driving table) | — | ECC + S/4 |
| QALSInspection Lot Record | Lot origin, vendor, material, lot quantity and stock posting quantities | QALS-PRUEFLOS = QAVE-PRUEFLOS | ECC + S/4 |
| QMELNotification Header | Quality notifications raised against the vendor | QMEL-LIFNUM = QALS-LIFNR AND QMEL-MATNR = QALS-MATNR | ECC + S/4 |
| LFA1Vendor Master (General Section) | Vendor name | LFA1-LIFNR = QALS-LIFNR | ECC + S/4 |
| MAKTMaterial Descriptions | Material description | MAKT-MATNR = QALS-MATNR AND MAKT-SPRAS = SY-LANGU | ECC + S/4 |
| I_InspLotUsageDecisionUsage Decision for Inspection Lot | In S/4HANA it can replace QAVE with a clean core approach | InspectionLot = QALS-PRUEFLOS | S/4HANA only |
Selection screen parameters
| Parameter | Description | Type | Reference field | Required | Example |
|---|---|---|---|---|---|
| S_WERK | Plant | Range / multiple | QALS-WERK | Yes | 1000 |
| S_LIFNR | Vendor | Range / multiple | QALS-LIFNR | No | 100512 |
| S_MATNR | Material | Range / multiple | QALS-MATNR | No | RM-3105 |
| S_VDAT | Usage decision date | Range / multiple | QAVE-VDATUM | Yes | 01.01.2026 – 31.10.2026 |
| S_QMART | Vendor complaint notification type | Range / multiple | QMEL-QMART | No | Q2 |
| P_LASTN | Number of latest lots to show | Single value | — | No | 10 |
| R_VEND | Summary per vendor | Radio button | — | No | X |
| R_MAT | Per vendor and material | Radio button | — | No | — |
Output columns
| # | Column | Source |
|---|---|---|
| 1 | Vendor | QALS-LIFNR |
| 2 | Vendor name | LFA1-NAME1 |
| 3 | Material | QALS-MATNR |
| 4 | Material description | MAKT-MAKTX |
| 5 | Lots | Calculated Number of goods receipt lots with a usage decision in the period |
| 6 | Rejected lots | Calculated Number of lots with QAVE-VBEWERTUNG = R |
| 7 | Lot rejection % | Calculated Rejected lots ÷ lots × 100 |
| 8 | Received qty | Calculated Sum of QALS-LOSMENGE |
| 9 | Rejected qty | Calculated Sum of QALS-LMENGE04 + LMENGE02 + LMENGE07 |
| 10 | Unit | QALS-MENGENEINH |
| 11 | PPM | Calculated Rejected qty ÷ received qty × 1,000,000 |
| 12 | Quality notifications | Calculated Number of QMEL notifications raised against the vendor in the period |
| 13 | Latest lot decisions | Calculated QAVE-VBEWERTUNG of the last N lots in date order |
Sample output
| Vendor | Vendor name | Material | Material description | Lots | Rejected lots | Lot rejection % | Received qty | Rejected qty | Unit | PPM | Quality notifications | Latest lot decisions |
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 100512 | Ege Kimya | RM-3105 | Solvent-based paint | 18 | 3 | 16.70 | 7,200 | 540 | L | 75,000 | 3 | A A R A A R A A A R |
| 100245 | Atlas Ambalaj | RM-1001 | Carton box 40x30 | 42 | 1 | 2.40 | 210,000 | 1,200 | PC | 5,714 | 1 | A A A A A A R A A A |
| 100387 | Delta Metal | RM-2040 | Steel sheet 2 mm | 25 | 0 | 0 | 19,500 | 0 | KG | 0 | 0 | A A A A A A A A A A |
How does the report work?
- Goods receipt inspection lots (QALS-HERKUNFT = 01) whose usage decision date (QAVE-VDATUM) is in the selected range are read with the plant, vendor and material filters.
- The lot decision comes from QAVE-VBEWERTUNG: A accepted, R rejected. Lot rejection rate = rejected lots ÷ all lots × 100.
- Rejected quantity = sum of the quantities posted to blocked stock (LMENGE04), scrap (LMENGE02) and return to vendor (LMENGE07). PPM = rejected quantity ÷ sum of lot quantity (LOSMENGE) × 1,000,000.
- Quality notifications raised against the vendor are counted from QMEL (LIFNUM, selected notification types, same period).
- For each vendor and material, the decisions of the last N lots are joined in date order into one text (e.g. A A R A). The result is summarized at vendor or material level.
Performance notes
Read QAVE by decision date and join QALS once with the lot list. For yearly scorecards, run the report in the background at month end.
Features
- ALV list (sort, filter, subtotals)
- User-specific layout variants
- Double-click drill-down to the document Double-clicking a vendor line shows its lots; double-clicking a lot opens QA03.
- Export to Excel
- Runs as a background job
- Send the result by email The monthly scorecard can be sent to the purchasing and quality managers.
Authorization objects
- Q_INSPTYPEInspection lot authorization by inspection type
- Q_QMELQuality notification display authorization by notification type
Frequently asked questions
How is PPM calculated?
The quantities posted to blocked stock, scrap and return to vendor on the period's goods receipt lots are summed, divided by the total lot quantity and multiplied by one million. For example, 540 litres rejected out of 7,200 litres is 75,000 PPM.
Can a vendor score be calculated?
Yes. If weights are defined for rejection rate, PPM and notification count, a single quality score column can be added; the weights follow the company's vendor evaluation rules.
Does the report work on S/4HANA?
Yes. The QM tables used are the same in S/4HANA; for clean core, I_InspectionLot and I_InspLotUsageDecision can be used.
Packages that include this solution
Quality Management Control Pack
A five-report pack for the weekly quality meeting: inspection lots awaiting a usage decision, decisions made before all results were recorded, blocked …
Supplier Quality Management Pack
A four-component pack that follows supplier quality from approval to evaluation: quality info record release and certificate validity, lots skipped by …
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 …
Blocked Stock Left from Rejected Usage Decisions Report
A custom ALV report that lists the quantities rejected at the usage decision and posted to blocked stock that are still sitting in blocked stock, with …
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.