QM Report Custom development ALV report

In-Process Inspection Results Out of Tolerance by Work Center Report

Short answer: A custom ALV report that lists in-process inspection results of production orders that fell outside tolerance, by work center, operation and characteristic. At the end of a shift or week you see in one list which machine produces the most rejections on which dimension.

Estimated effort
M · 3–5 working days
System
ECC and S/4HANA
Tables
5
Scope
Global
Built by
NeKuDos Teknoloji
Last updated

Why is the standard not enough?

QE51N records and shows results for the selected inspection lot; it does not rank the rejected characteristics of many orders by work center. QA33 lists inspection lots but does not show characteristic values and tolerance limits. Seeing in-process quality problems by machine and dimension needs a report that combines results, plan and work center data.

Who uses it? Production and process engineers, quality control teams, shift supervisors and continuous improvement teams.

Closest standard alternatives

  • QE51N Results Recording Worklist. Records and shows results for selected lots; does not rank by work center.
  • QA33 Display Data for Inspection Lot. Lists inspection lots; does not show characteristic values and limits.

Tables used

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

TableRoleJoinSystem
QALSInspection Lot RecordIn-process inspection lots, order and routing number (driving table)—ECC + S/4
QAMRCharacteristic Results During Inspection ProcessingCharacteristic results: mean, valuation, date and inspectorQAMR-PRUEFLOS = QALS-PRUEFLOSECC + S/4
QAMVCharacteristic Specifications for Inspection ProcessingCharacteristic description, target value and tolerance limitsQAMV-PRUEFLOS = QAMR-PRUEFLOS AND QAMV-VORGLFNR = QAMR-VORGLFNR AND QAMV-MERKNR = QAMR-MERKNRECC + S/4
AFVCOperation within an OrderOrder operation and work center linkAFVC-AUFPL = QALS-AUFPL AND AFVC-APLZL = QAMV-VORGLFNRECC + S/4
CRHDWork Center HeaderWork center codeCRHD-OBJTY = 'A' AND CRHD-OBJID = AFVC-ARBIDECC + S/4

Selection screen parameters

ParameterDescriptionTypeReference fieldRequiredExample
S_WERKPlantRange / multipleQALS-WERKYes1000
S_DATEResult date rangeRange / multipleQAMR-PRUEFDATUVYes09.11.2026 – 15.11.2026
S_ARBPLWork centerRange / multipleCRHD-ARBPLNoCNC-03
S_MATNRMaterialRange / multipleQALS-MATNRNoFG-7300
S_AUFNRProduction orderRange / multipleQALS-AUFNRNo1000452
S_MERKMMaster characteristicRange / multipleQAMV-VERWMERKMNoCAP-DIS
P_ALLAlso read accepted results (for rejection rate)Checkbox—No—

Output columns

#ColumnSource
1Work centerCRHD-ARBPL
2Production orderQALS-AUFNR
3OperationAFVC-VORNR
4Inspection lotQALS-PRUEFLOS
5MaterialQALS-MATNR
6Master characteristicQAMV-VERWMERKM
7Characteristic textQAMV-KURZTEXT
8Lower limitQAMV-TOLERANZUN
9Upper limitQAMV-TOLERANZOB
10Mean valueQAMR-MITTELWERT
11UnitQAMV-MASSEINHSW
12DeviationCalculated Mean − upper limit when the mean is above it, mean − lower limit when it is below
13ValuationQAMR-MBEWERTG
14Result dateQAMR-PRUEFDATUV
15InspectorQAMR-PRUEFER

Sample output

Work centerProduction orderOperationInspection lotMaterialMaster characteristicCharacteristic textLower limitUpper limitMean valueUnitDeviationValuationResult dateInspector
CNC-0310004520020030000007781FG-7300CAP-DISBore diameter24.9825.0225.04MM0.02R11/10/2026OPERATOR1
CNC-0310004550020030000007790FG-7300CAP-DISBore diameter24.9825.0225.03MM0.01R11/11/2026OPERATOR2
PRS-0110004610010030000007802FG-7410BOY-UZPart length119.50120.50119.32MM-0.18R11/12/2026OPERATOR3
BYA-0210004700040030000007815FG-7410KAPLAMACoating thickness609094.50UM4.50R11/13/2026OPERATOR1
A view built with fictional sample data; not real system data.

How does the report work?

  1. Inspection lots with origin 03 (in-process inspection) in the selected plant are read from QALS.
  2. The characteristic results of the lot are taken from QAMR with the result date range (PRUEFDATUV); by default only those valued as rejected (MBEWERTG = R) are listed.
  3. The characteristic description, master characteristic, target value and lower/upper tolerance limits are read from QAMV. The deviation is the difference between the mean value and the limit that was exceeded.
  4. The operation is found in AFVC with QAMV-VORGLFNR (AUFPL = QALS-AUFPL, APLZL = VORGLFNR); the work center of the operation is read from CRHD with AFVC-ARBID.
  5. The ALV gives subtotals and rejection counts per work center and characteristic; when all results are selected, the rejection rate per work center (rejected results ÷ all results) is calculated.

Performance notes

Read QAMR with the result date range and the lot list; restrict QALS with HERKUNFT = 03 and the plant. Selecting all results increases the data volume; run long periods in the background.

Features

  • ALV list (sort, filter, subtotals)
  • User-specific layout variants A view totalled by work center and characteristic can be saved as a user layout.
  • Double-click drill-down to the document Double-clicking the inspection lot opens result display in QE53.
  • Export to Excel
  • Runs as a background job
  • Send the result by email A weekly summary can be sent to production and quality managers every Monday.

Authorization objects

  • Q_INSPTYPEInspection lot authorization by inspection type
  • C_AFKO_AWKProduction order authorization by plant and order type

Frequently asked questions

Do qualitative (coded) characteristics appear in the report too?

Yes. Qualitative characteristics have no mean or tolerance; the line shows the valuation and the selected code, and the deviation column stays empty.

Can a process capability (Cpk) value be added?

Yes. If single measured values are recorded, an extra view that calculates the standard deviation and Cpk per work center and characteristic can be added; this adds a day or two to the effort.

Does it work on S/4HANA?

Yes. QALS, QAMR, QAMV, AFVC and CRHD keep the same relationship on S/4HANA; the report runs unchanged.

Related reports

PP Report Custom ALV report

Scrap and Yield Analysis by Work Center Report

A custom ALV report that totals yield, scrap and rework from production confirmations per work center and operation, and compares the actual scrap …

AFRU · AFVC · AFVV · CRHD

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: In-Process Inspection Results Out of Tolerance by Work Center Report