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

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

- Type: Report, Custom development, ALV report
- Module: QM
- Estimated effort: M (3–5 working days)
- Last updated: 2026-11-17
- URL: https://nekuhub.com/en/reports/in-process-inspection-results-out-of-tolerance-by-work-center-report/


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

### Closest standard alternatives

- QE51N: Records and shows results for selected lots; does not rank by work center.
- QA33: Lists inspection lots; does not show characteristic values and limits.

## Tables used

| Table | Role | Access | Join | System |
|---|---|---|---|---|
| QALS | In-process inspection lots, order and routing number (driving table) | Read | - | ECC + S/4 |
| QAMR | Characteristic results: mean, valuation, date and inspector | Read | QAMR-PRUEFLOS = QALS-PRUEFLOS | ECC + S/4 |
| QAMV | Characteristic description, target value and tolerance limits | Read | QAMV-PRUEFLOS = QAMR-PRUEFLOS AND QAMV-VORGLFNR = QAMR-VORGLFNR AND QAMV-MERKNR = QAMR-MERKNR | ECC + S/4 |
| AFVC | Order operation and work center link | Read | AFVC-AUFPL = QALS-AUFPL AND AFVC-APLZL = QAMV-VORGLFNR | ECC + S/4 |
| CRHD | Work center code | Read | CRHD-OBJTY = 'A' AND CRHD-OBJID = AFVC-ARBID | ECC + S/4 |

## Selection screen parameters

| Parameter | Description | Type | Reference field | Required |
|---|---|---|---|---|
| S_WERK | Plant | Range / multiple | QALS-WERK | Yes |
| S_DATE | Result date range | Range / multiple | QAMR-PRUEFDATUV | Yes |
| S_ARBPL | Work center | Range / multiple | CRHD-ARBPL | No |
| S_MATNR | Material | Range / multiple | QALS-MATNR | No |
| S_AUFNR | Production order | Range / multiple | QALS-AUFNR | No |
| S_MERKM | Master characteristic | Range / multiple | QAMV-VERWMERKM | No |
| P_ALL | Also read accepted results (for rejection rate) | Checkbox | - | No |

## Output columns

| Column | Source |
|---|---|
| Work center | CRHD-ARBPL |
| Production order | QALS-AUFNR |
| Operation | AFVC-VORNR |
| Inspection lot | QALS-PRUEFLOS |
| Material | QALS-MATNR |
| Master characteristic | QAMV-VERWMERKM |
| Characteristic text | QAMV-KURZTEXT |
| Lower limit | QAMV-TOLERANZUN |
| Upper limit | QAMV-TOLERANZOB |
| Mean value | QAMR-MITTELWERT |
| Unit | QAMV-MASSEINHSW |
| Deviation | Calculated: Mean − upper limit when the mean is above it, mean − lower limit when it is below |
| Valuation | QAMR-MBEWERTG |
| Result date | QAMR-PRUEFDATUV |
| Inspector | QAMR-PRUEFER |

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

## Authorization objects

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

---
Let us build this report for your system: https://nekuhub.com/en/request-a-quote/?report=qm-in-process-out-of-tolerance-by-work-center
