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
Tables used
The tables the report reads and their join fields. ECC and S/4HANA differences are marked separately.
| Table | Role | Join | System |
|---|---|---|---|
| QALSInspection Lot Record | In-process inspection lots, order and routing number (driving table) | — | ECC + S/4 |
| QAMRCharacteristic Results During Inspection Processing | Characteristic results: mean, valuation, date and inspector | QAMR-PRUEFLOS = QALS-PRUEFLOS | ECC + S/4 |
| QAMVCharacteristic Specifications for Inspection Processing | Characteristic description, target value and tolerance limits | QAMV-PRUEFLOS = QAMR-PRUEFLOS AND QAMV-VORGLFNR = QAMR-VORGLFNR AND QAMV-MERKNR = QAMR-MERKNR | ECC + S/4 |
| AFVCOperation within an Order | Order operation and work center link | AFVC-AUFPL = QALS-AUFPL AND AFVC-APLZL = QAMV-VORGLFNR | ECC + S/4 |
| CRHDWork Center Header | Work center code | CRHD-OBJTY = 'A' AND CRHD-OBJID = AFVC-ARBID | ECC + S/4 |
Selection screen parameters
| Parameter | Description | Type | Reference field | Required | Example |
|---|---|---|---|---|---|
| S_WERK | Plant | Range / multiple | QALS-WERK | Yes | 1000 |
| S_DATE | Result date range | Range / multiple | QAMR-PRUEFDATUV | Yes | 09.11.2026 – 15.11.2026 |
| S_ARBPL | Work center | Range / multiple | CRHD-ARBPL | No | CNC-03 |
| S_MATNR | Material | Range / multiple | QALS-MATNR | No | FG-7300 |
| S_AUFNR | Production order | Range / multiple | QALS-AUFNR | No | 1000452 |
| S_MERKM | Master characteristic | Range / multiple | QAMV-VERWMERKM | No | CAP-DIS |
| P_ALL | Also read accepted results (for rejection rate) | Checkbox | — | No | — |
Output columns
| # | Column | Source |
|---|---|---|
| 1 | Work center | CRHD-ARBPL |
| 2 | Production order | QALS-AUFNR |
| 3 | Operation | AFVC-VORNR |
| 4 | Inspection lot | QALS-PRUEFLOS |
| 5 | Material | QALS-MATNR |
| 6 | Master characteristic | QAMV-VERWMERKM |
| 7 | Characteristic text | QAMV-KURZTEXT |
| 8 | Lower limit | QAMV-TOLERANZUN |
| 9 | Upper limit | QAMV-TOLERANZOB |
| 10 | Mean value | QAMR-MITTELWERT |
| 11 | Unit | QAMV-MASSEINHSW |
| 12 | Deviation | Calculated Mean − upper limit when the mean is above it, mean − lower limit when it is below |
| 13 | Valuation | QAMR-MBEWERTG |
| 14 | Result date | QAMR-PRUEFDATUV |
| 15 | Inspector | QAMR-PRUEFER |
Sample output
| Work center | Production order | Operation | Inspection lot | Material | Master characteristic | Characteristic text | Lower limit | Upper limit | Mean value | Unit | Deviation | Valuation | Result date | Inspector |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| CNC-03 | 1000452 | 0020 | 030000007781 | FG-7300 | CAP-DIS | Bore diameter | 24.98 | 25.02 | 25.04 | MM | 0.02 | R | 11/10/2026 | OPERATOR1 |
| CNC-03 | 1000455 | 0020 | 030000007790 | FG-7300 | CAP-DIS | Bore diameter | 24.98 | 25.02 | 25.03 | MM | 0.01 | R | 11/11/2026 | OPERATOR2 |
| PRS-01 | 1000461 | 0010 | 030000007802 | FG-7410 | BOY-UZ | Part length | 119.50 | 120.50 | 119.32 | MM | -0.18 | R | 11/12/2026 | OPERATOR3 |
| BYA-02 | 1000470 | 0040 | 030000007815 | FG-7410 | KAPLAMA | Coating thickness | 60 | 90 | 94.50 | UM | 4.50 | R | 11/13/2026 | OPERATOR1 |
How does the report work?
- Inspection lots with origin 03 (in-process inspection) in the selected plant are read from QALS.
- 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.
- 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.
- 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.
- 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
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 …
Usage Decisions Made Before All Characteristics Were Recorded Report
A custom ALV report that lists, for inspection lots that already have a usage decision, the characteristics that were never recorded or valuated, 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.