QM Report Custom development ALV report

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

  • QGA2 Display Inspection Results. Shows inspection results per lot; does not combine lots or calculate Cp/Cpk.
  • QE03 Display Characteristic Results. Shows the characteristic results of one lot; no capability analysis over a period.

Tables used

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

TableRoleJoinSystem
QALSInspection Lot RecordInspection lot: material, plant, inspection type, creation date (driving table)—ECC + S/4
QAMVCharacteristic Specifications for Inspection ProcessingCharacteristic specification: master characteristic, target value, lower and upper tolerance, unitQAMV-PRUEFLOS = QALS-PRUEFLOSECC + S/4
QAMRCharacteristic Results During Inspection ProcessingCharacteristic summary result: mean, variance, number of valuesQAMR-PRUEFLOS = QAMV-PRUEFLOS AND QAMR-VORGLFNR = QAMV-VORGLFNR AND QAMR-MERKNR = QAMV-MERKNRECC + S/4
QASEResults Table for the Sample UnitSingle measured valuesQASE-PRUEFLOS = QAMV-PRUEFLOS AND QASE-VORGLFNR = QAMV-VORGLFNR AND QASE-MERKNR = QAMV-MERKNRECC + S/4
MAKTMaterial DescriptionsMaterial descriptionMAKT-MATNR = QALS-MATNR AND MAKT-SPRAS = SY-LANGUECC + S/4
I_InspectionResultValueSingle Value of an Inspection Characteristic ResultIn S/4HANA it can replace QASE with a clean core approachInspectionLot = QALS-PRUEFLOSS/4HANA only

Selection screen parameters

ParameterDescriptionTypeReference fieldRequiredExample
S_WERKPlantRange / multipleQALS-WERKYes1000
S_MATNRMaterialRange / multipleQALS-MATNRYesFG-1120
S_ARTInspection typeRange / multipleQALS-ARTNo04
S_DATELot creation date rangeRange / multipleQALS-ENSTEHDATYes01.08.2026 – 31.10.2026
S_MICMaster inspection characteristicRange / multipleQAMV-VERWMERKMNoNET-AG
P_MINNMinimum number of valuesSingle value—No25
P_CPKTarget CpkSingle value—Yes1.33
P_SINGLECalculate from single values (QASE)Checkbox—NoX

Output columns

#ColumnSource
1MaterialQALS-MATNR
2Material descriptionMAKT-MAKTX
3Master characteristicQAMV-VERWMERKM
4Characteristic textQAMV-KURZTEXT
5Target valueQAMV-SOLLWERT
6Lower limit (LSL)QAMV-TOLERANZUN
7Upper limit (USL)QAMV-TOLERANZOB
8UnitQAMV-MASSEINHSW
9LotsCalculated Number of distinct QALS-PRUEFLOS
10ValuesCalculated Number of QASE single values or Σ QAMR-ANZWERTG
11MeanCalculated Mean of all values (x̄)
12Standard deviationCalculated σ = √(sample variance)
13CpCalculated (USL − LSL) ÷ 6σ; empty for a one-sided tolerance
14CpkCalculated min(USL − x̄, x̄ − LSL) ÷ 3σ
15Out of tolerance %Calculated Values outside the limits ÷ number of values × 100
16StatusCalculated Capable (Cpk ≥ target), marginal (1.00 – target), not capable (< 1.00) or insufficient data

Sample output

MaterialMaterial descriptionMaster characteristicCharacteristic textTarget valueLower limit (LSL)Upper limit (USL)UnitLotsValuesMeanStandard deviationCpCpkOut of tolerance %Status
FG-1120Tomato paste 830 gNET-AGNet weight830825840G422108311.901.321.050.50Marginal
FG-1120Tomato paste 830 gBRIXBrix value282730%424228.600.2521.870Capable
FG-2050Plastic bucket 10 LET-KALWall thickness1.801.602MM301501.710.051.330.733.10Not capable
FG-4010Hazelnut kernels 500 gNEMMoisture content56%25255.200.221.210Marginal
A view built with fictional sample data; not real system data.

How does the report work?

  1. QALS is read by plant, material, inspection type and lot creation date (ENSTEHDAT); cancelled lots are skipped.
  2. 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.
  3. 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).
  4. σ = √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.
  5. Out of tolerance % = number of values outside the limits ÷ total values × 100.
  6. 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

QM Package Custom

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 …

5 components · v1.0

Related reports

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: Process Capability (Cp/Cpk) Report by Inspection Characteristic