QM Report Custom development ALV report

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

  • QA33 Display Data for Inspection Lot. Lists lots with a usage decision; does not calculate rejection rate or PPM per vendor.
  • QM11 Display List of Quality Notifications. Lists quality notification items; does not combine them with inspection lot results.

Tables used

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

TableRoleJoinSystem
QAVEUsage DecisionUsage decision: code, valuation (accept/reject) and date (driving table)—ECC + S/4
QALSInspection Lot RecordLot origin, vendor, material, lot quantity and stock posting quantitiesQALS-PRUEFLOS = QAVE-PRUEFLOSECC + S/4
QMELNotification HeaderQuality notifications raised against the vendorQMEL-LIFNUM = QALS-LIFNR AND QMEL-MATNR = QALS-MATNRECC + S/4
LFA1Vendor Master (General Section)Vendor nameLFA1-LIFNR = QALS-LIFNRECC + S/4
MAKTMaterial DescriptionsMaterial descriptionMAKT-MATNR = QALS-MATNR AND MAKT-SPRAS = SY-LANGUECC + S/4
I_InspLotUsageDecisionUsage Decision for Inspection LotIn S/4HANA it can replace QAVE with a clean core approachInspectionLot = QALS-PRUEFLOSS/4HANA only

Selection screen parameters

ParameterDescriptionTypeReference fieldRequiredExample
S_WERKPlantRange / multipleQALS-WERKYes1000
S_LIFNRVendorRange / multipleQALS-LIFNRNo100512
S_MATNRMaterialRange / multipleQALS-MATNRNoRM-3105
S_VDATUsage decision dateRange / multipleQAVE-VDATUMYes01.01.2026 – 31.10.2026
S_QMARTVendor complaint notification typeRange / multipleQMEL-QMARTNoQ2
P_LASTNNumber of latest lots to showSingle value—No10
R_VENDSummary per vendorRadio button—NoX
R_MATPer vendor and materialRadio button—No—

Output columns

#ColumnSource
1VendorQALS-LIFNR
2Vendor nameLFA1-NAME1
3MaterialQALS-MATNR
4Material descriptionMAKT-MAKTX
5LotsCalculated Number of goods receipt lots with a usage decision in the period
6Rejected lotsCalculated Number of lots with QAVE-VBEWERTUNG = R
7Lot rejection %Calculated Rejected lots ÷ lots × 100
8Received qtyCalculated Sum of QALS-LOSMENGE
9Rejected qtyCalculated Sum of QALS-LMENGE04 + LMENGE02 + LMENGE07
10UnitQALS-MENGENEINH
11PPMCalculated Rejected qty ÷ received qty × 1,000,000
12Quality notificationsCalculated Number of QMEL notifications raised against the vendor in the period
13Latest lot decisionsCalculated QAVE-VBEWERTUNG of the last N lots in date order

Sample output

VendorVendor nameMaterialMaterial descriptionLotsRejected lotsLot rejection %Received qtyRejected qtyUnitPPMQuality notificationsLatest lot decisions
100512Ege KimyaRM-3105Solvent-based paint18316.707,200540L75,0003A A R A A R A A A R
100245Atlas AmbalajRM-1001Carton box 40x304212.40210,0001,200PC5,7141A A A A A A R A A A
100387Delta MetalRM-2040Steel sheet 2 mm250019,5000KG00A A A A A A A A A A
A view built with fictional sample data; not real system data.

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.

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

QM Package Custom

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 …

5 components · v1.0

QM Package Custom

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 …

4 components · v1.0

Related reports

MM Report Custom ALV report

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 …

EKKO · EKPO · EKET · LFA1

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: Vendor Quality Scorecard and Rejection Rate (PPM) Report