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

- Type: Report, Custom development, ALV report
- Module: QM
- Estimated effort: M (4–6 working days)
- Last updated: 2026-11-17
- URL: https://nekuhub.com/en/reports/vendor-quality-scorecard-rejection-rate-ppm-report/


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

### Closest standard alternatives

- QA33: Lists lots with a usage decision; does not calculate rejection rate or PPM per vendor.
- QM11: Lists quality notification items; does not combine them with inspection lot results.

## Tables used

| Table | Role | Access | Join | System |
|---|---|---|---|---|
| QAVE | Usage decision: code, valuation (accept/reject) and date (driving table) | Read | - | ECC + S/4 |
| QALS | Lot origin, vendor, material, lot quantity and stock posting quantities | Read | QALS-PRUEFLOS = QAVE-PRUEFLOS | ECC + S/4 |
| QMEL | Quality notifications raised against the vendor | Read | QMEL-LIFNUM = QALS-LIFNR AND QMEL-MATNR = QALS-MATNR | ECC + S/4 |
| LFA1 | Vendor name | Read | LFA1-LIFNR = QALS-LIFNR | ECC + S/4 |
| MAKT | Material description | Read | MAKT-MATNR = QALS-MATNR AND MAKT-SPRAS = SY-LANGU | ECC + S/4 |
| I_InspLotUsageDecision | In S/4HANA it can replace QAVE with a clean core approach | Read | InspectionLot = QALS-PRUEFLOS | S/4HANA only |

## Selection screen parameters

| Parameter | Description | Type | Reference field | Required |
|---|---|---|---|---|
| S_WERK | Plant | Range / multiple | QALS-WERK | Yes |
| S_LIFNR | Vendor | Range / multiple | QALS-LIFNR | No |
| S_MATNR | Material | Range / multiple | QALS-MATNR | No |
| S_VDAT | Usage decision date | Range / multiple | QAVE-VDATUM | Yes |
| S_QMART | Vendor complaint notification type | Range / multiple | QMEL-QMART | No |
| P_LASTN | Number of latest lots to show | Single value | - | No |
| R_VEND | Summary per vendor | Radio button | - | No |
| R_MAT | Per vendor and material | Radio button | - | No |

## Output columns

| Column | Source |
|---|---|
| Vendor | QALS-LIFNR |
| Vendor name | LFA1-NAME1 |
| Material | QALS-MATNR |
| Material description | MAKT-MAKTX |
| Lots | Calculated: Number of goods receipt lots with a usage decision in the period |
| Rejected lots | Calculated: Number of lots with QAVE-VBEWERTUNG = R |
| Lot rejection % | Calculated: Rejected lots ÷ lots × 100 |
| Received qty | Calculated: Sum of QALS-LOSMENGE |
| Rejected qty | Calculated: Sum of QALS-LMENGE04 + LMENGE02 + LMENGE07 |
| Unit | QALS-MENGENEINH |
| PPM | Calculated: Rejected qty ÷ received qty × 1,000,000 |
| Quality notifications | Calculated: Number of QMEL notifications raised against the vendor in the period |
| Latest lot decisions | Calculated: QAVE-VBEWERTUNG of the last N lots in date order |

## How does the report work?

1. 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.
2. The lot decision comes from QAVE-VBEWERTUNG: A accepted, R rejected. Lot rejection rate = rejected lots ÷ all lots × 100.
3. 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.
4. Quality notifications raised against the vendor are counted from QMEL (LIFNUM, selected notification types, same period).
5. 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.

## Authorization objects

- Q_INSPTYPE: Inspection lot authorization by inspection type
- Q_QMEL: Quality 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.

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