Process Capability (Cp/Cpk) Report by Inspection Characteristic
Short answer: A custom ALV report that calculates the mean, standard deviation, Cp and Cpk for each master inspection characteristic from the quantitative results of the inspection lots of the selected material and period, and classifies them as capable, marginal or not capable against a target Cpk. Quality engineers get the capability table requested in customer audits and PPAP files from SAP data in one run.
- 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?
QGA2 and QE03 show results per inspection lot and characteristic; they do not combine the results of many lots for one characteristic and calculate Cp/Cpk. SPC control charts only work with configured control chart types and task list settings and are not active in most systems. Teams export the results and calculate them in statistics software. The custom report calculates the capability indices directly from single values or summarized results and also handles one-sided tolerances correctly.
Who uses it? Quality engineers, process engineers, customer quality representatives and laboratory managers.
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 | Inspection lot: material, plant, inspection type, creation date (driving table) | — | ECC + S/4 |
| QAMVCharacteristic Specifications for Inspection Processing | Characteristic specification: master characteristic, target value, lower and upper tolerance, unit | QAMV-PRUEFLOS = QALS-PRUEFLOS | ECC + S/4 |
| QAMRCharacteristic Results During Inspection Processing | Characteristic summary result: mean, variance, number of values | QAMR-PRUEFLOS = QAMV-PRUEFLOS AND QAMR-VORGLFNR = QAMV-VORGLFNR AND QAMR-MERKNR = QAMV-MERKNR | ECC + S/4 |
| QASEResults Table for the Sample Unit | Single measured values | QASE-PRUEFLOS = QAMV-PRUEFLOS AND QASE-VORGLFNR = QAMV-VORGLFNR AND QASE-MERKNR = QAMV-MERKNR | ECC + S/4 |
| MAKTMaterial Descriptions | Material description | MAKT-MATNR = QALS-MATNR AND MAKT-SPRAS = SY-LANGU | ECC + S/4 |
| I_InspectionResultValueSingle Value of an Inspection Characteristic Result | In S/4HANA it can replace QASE with a clean core approach | InspectionLot = QALS-PRUEFLOS | S/4HANA only |
Selection screen parameters
| Parameter | Description | Type | Reference field | Required | Example |
|---|---|---|---|---|---|
| S_WERK | Plant | Range / multiple | QALS-WERK | Yes | 1000 |
| S_MATNR | Material | Range / multiple | QALS-MATNR | Yes | FG-1120 |
| S_ART | Inspection type | Range / multiple | QALS-ART | No | 04 |
| S_DATE | Lot creation date range | Range / multiple | QALS-ENSTEHDAT | Yes | 01.08.2026 – 31.10.2026 |
| S_MIC | Master inspection characteristic | Range / multiple | QAMV-VERWMERKM | No | NET-AG |
| P_MINN | Minimum number of values | Single value | — | No | 25 |
| P_CPK | Target Cpk | Single value | — | Yes | 1.33 |
| P_SINGLE | Calculate from single values (QASE) | Checkbox | — | No | X |
Output columns
| # | Column | Source |
|---|---|---|
| 1 | Material | QALS-MATNR |
| 2 | Material description | MAKT-MAKTX |
| 3 | Master characteristic | QAMV-VERWMERKM |
| 4 | Characteristic text | QAMV-KURZTEXT |
| 5 | Target value | QAMV-SOLLWERT |
| 6 | Lower limit (LSL) | QAMV-TOLERANZUN |
| 7 | Upper limit (USL) | QAMV-TOLERANZOB |
| 8 | Unit | QAMV-MASSEINHSW |
| 9 | Lots | Calculated Number of distinct QALS-PRUEFLOS |
| 10 | Values | Calculated Number of QASE single values or Σ QAMR-ANZWERTG |
| 11 | Mean | Calculated Mean of all values (x̄) |
| 12 | Standard deviation | Calculated σ = √(sample variance) |
| 13 | Cp | Calculated (USL − LSL) ÷ 6σ; empty for a one-sided tolerance |
| 14 | Cpk | Calculated min(USL − x̄, x̄ − LSL) ÷ 3σ |
| 15 | Out of tolerance % | Calculated Values outside the limits ÷ number of values × 100 |
| 16 | Status | Calculated Capable (Cpk ≥ target), marginal (1.00 – target), not capable (< 1.00) or insufficient data |
Sample output
| Material | Material description | Master characteristic | Characteristic text | Target value | Lower limit (LSL) | Upper limit (USL) | Unit | Lots | Values | Mean | Standard deviation | Cp | Cpk | Out of tolerance % | Status |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| FG-1120 | Tomato paste 830 g | NET-AG | Net weight | 830 | 825 | 840 | G | 42 | 210 | 831 | 1.90 | 1.32 | 1.05 | 0.50 | Marginal |
| FG-1120 | Tomato paste 830 g | BRIX | Brix value | 28 | 27 | 30 | % | 42 | 42 | 28.60 | 0.25 | 2 | 1.87 | 0 | Capable |
| FG-2050 | Plastic bucket 10 L | ET-KAL | Wall thickness | 1.80 | 1.60 | 2 | MM | 30 | 150 | 1.71 | 0.05 | 1.33 | 0.73 | 3.10 | Not capable |
| FG-4010 | Hazelnut kernels 500 g | NEM | Moisture content | 5 | 6 | % | 25 | 25 | 5.20 | 0.22 | 1.21 | 0 | Marginal |
How does the report work?
- QALS is read by plant, material, inspection type and lot creation date (ENSTEHDAT); cancelled lots are skipped.
- Quantitative characteristics with at least one tolerance limit are taken from QAMV; results are grouped by master inspection characteristic (QAMV-VERWMERKM), so different lots and plans are combined. Limits are taken from the latest lot; if limits changed between lots, the line is flagged.
- With “Calculate from single values” selected, the QASE-MESSWERT single values (except those flagged invalid) are used; otherwise the mean (MITTELWERT), variance (VARIANZ) and number of values (ANZWERTG) are taken from the QAMR summary of each lot and the pooled variance is calculated as Σ((nᵢ − 1)·sᵢ² + nᵢ·(x̄ᵢ − x̄)²) ÷ (N − 1).
- σ = √variance; Cp = (USL − LSL) ÷ 6σ; Cpk = min(USL − x̄, x̄ − LSL) ÷ 3σ. For a one-sided tolerance only the available side is used and Cp stays empty.
- Out of tolerance % = number of values outside the limits ÷ total values × 100.
- Classification: Cpk ≥ target is capable, between 1.00 and the target is marginal, below 1.00 is not capable; if the number of values is below the minimum, “insufficient data” is shown.
Performance notes
Narrow the QALS selection by plant, material and date. QASE is a large table; read single values only for the selected lots and characteristics. For many materials, working with summarized results (QAMR) is faster.
Features
- ALV list (sort, filter, subtotals)
- User-specific layout variants
- Double-click drill-down to the document Double-clicking a line lists the mean and deviation per lot for the characteristic; clicking a lot opens QA03.
- Export to Excel
- Runs as a background job
- Send the result by email The monthly capability table can be emailed to the quality manager and the customer quality representative.
Authorization objects
- Q_INSPTYPEInspection lot display authorization by inspection type
- M_MATE_WRKMaterial authorization by plant
Frequently asked questions
Should single values or summarized results be used?
If the characteristic is recorded with single values (QASE filled), single values give the most accurate result. If only summarized results are recorded, the report calculates the pooled variance from each lot's mean and variance, taking both within-lot and between-lot spread into account.
How are one-sided tolerances calculated?
For characteristics with only an upper or only a lower limit, Cpk is calculated against the available limit (e.g. (USL − x̄) ÷ 3σ). Cp is left empty because it needs both limits.
Does the report work on S/4HANA?
Yes. QALS, QAMV, QAMR and QASE also exist in S/4HANA. For a clean core approach, the I_InspectionCharacteristic, I_InspectionResult and I_InspectionResultValue CDS views can be used.
Packages that include this solution
Customer Complaint and Root Cause Pack
A five-component pack that follows a customer complaint from intake to improvement: automatic complaint notifications from a portal or call centre …
Related reports
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 …
Inspection Results Upload from Laboratory File Program
A custom interface program that records the measured values in a CSV/XLSX file produced by laboratory instruments or a laboratory information system …
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 …
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.