QM Report Custom development ALV report

Usage Decisions Made Before All Characteristics Were Recorded Report

Short answer: A custom ALV report that lists, for inspection lots that already have a usage decision, the characteristics that were never recorded or valuated, with the user who made the decision and the decision code. Quality assurance and internal audit teams see, after the fact, the lots released with incomplete inspection.

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

Why is the standard not enough?

In QA11, depending on the settings, a usage decision can be made with a warning while characteristics are still open. QA33 lists lots with a decision but not which characteristic was left without a result; QE51N shows results lot by lot. There is no standard report that lists, for a period, the lots decided with incomplete inspection; for audits this list is prepared by hand.

Who uses it? Quality assurance managers, internal auditors, laboratory supervisors and teams responsible for GMP / ISO compliance.

Closest standard alternatives

  • QA33 Display Data for Inspection Lot. Lists lots with a usage decision; does not show which characteristic was left without a result.
  • QE51N Results Recording Worklist. Shows and records results lot by lot; does not list gaps after the decision across lots.

Tables used

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

TableRoleJoinSystem
QAVEUsage DecisionUsage decision: code, valuation, date and deciding user (driving table)—ECC + S/4
QALSInspection Lot RecordPlant, inspection type, material and batchQALS-PRUEFLOS = QAVE-PRUEFLOSECC + S/4
QAMVCharacteristic Specifications for Inspection ProcessingCharacteristics of the lot and their control indicatorsQAMV-PRUEFLOS = QALS-PRUEFLOSECC + S/4
QAMRCharacteristic Results During Inspection ProcessingCharacteristic result, number of values and valuationQAMR-PRUEFLOS = QAMV-PRUEFLOS AND QAMR-VORGLFNR = QAMV-VORGLFNR AND QAMR-MERKNR = QAMV-MERKNRECC + S/4
I_InspectionCharacteristicCharacteristic in Inspection LotIn S/4HANA it can replace QAMV with a clean core approachInspectionLot = QALS-PRUEFLOSS/4HANA only

Selection screen parameters

ParameterDescriptionTypeReference fieldRequiredExample
S_WERKPlantRange / multipleQALS-WERKYes1000
S_ARTInspection typeRange / multipleQALS-ARTNo04
S_MATNRMaterialRange / multipleQALS-MATNRNoFG-2050
S_VDATUsage decision dateRange / multipleQAVE-VDATUMYes01.10.2026 – 31.10.2026
S_VNAMEDecided byRange / multipleQAVE-VNAMENoKALITE02
S_VCODEDecision codeRange / multipleQAVE-VCODENoA1
P_REQRequired characteristics onlyCheckbox—NoX

Output columns

#ColumnSource
1Inspection lotQALS-PRUEFLOS
2Inspection typeQALS-ART
3MaterialQALS-MATNR
4BatchQALS-CHARG
5Decision codeQAVE-VCODE
6Decision valuationQAVE-VBEWERTUNG
7Decision dateQAVE-VDATUM
8Decided byQAVE-VNAME
9Operation counterQAMV-VORGLFNR
10Characteristic no.QAMV-MERKNR
11Master characteristicQAMV-VERWMERKM
12Characteristic textQAMV-KURZTEXT
13Values recordedQAMR-ANZWERTG
14Characteristic valuationQAMR-MBEWERTG

Sample output

Inspection lotInspection typeMaterialBatchDecision codeDecision valuationDecision dateDecided byOperation counterCharacteristic no.Master characteristicCharacteristic textValues recordedCharacteristic valuation
04000000180204FG-2050P2610-22A1A10/23/2026KALITE02000000010030VISKOZITEViscosity at 25 °C0
04000000180204FG-2050P2610-22A1A10/23/2026KALITE02000000010040RENK-DELTAEColour difference ΔE0
01000000439801RM-1001A2A10/27/2026KALITE01000000010020NEMMoisture content2
A view built with fictional sample data; not real system data.

How does the report work?

  1. Lots whose usage decision date (QAVE-VDATUM) is in the selected range are read from QAVE, and from QALS with the plant, inspection type and material filters.
  2. The QAMV characteristics of each lot are read. With “Required characteristics only” selected, characteristics marked as optional in the control indicators (QAMV-STEUERKZ) are skipped.
  3. Characteristics without a QAMR record, with an empty valuation (MBEWERTG) or with zero values recorded (ANZWERTG) count as missing.
  4. One line is created per missing characteristic, with the decision code (VCODE), valuation (VBEWERTUNG), date and the user who decided (VNAME).
  5. ALV shows subtotals per deciding user and decision code.

Performance notes

Read QAVE by decision date; read QAMV and QAMR once with the lot list and compare in memory. Run yearly audit lists in the background.

Features

  • ALV list (sort, filter, subtotals)
  • User-specific layout variants
  • Double-click drill-down to the document Double-clicking the lot number opens QA03; double-clicking a characteristic opens QE03.
  • Export to Excel
  • Runs as a background job
  • Send the result by email The monthly list can be sent to the quality assurance manager.

Authorization objects

  • Q_INSPTYPEInspection lot authorization by inspection type
  • Q_TCODEQM transaction code authorization

Frequently asked questions

How can a usage decision be made with open characteristics?

Depending on the inspection type and characteristic settings, SAP may allow open characteristics to be closed or skipped with a warning at the usage decision. The report shows in which lots this happened; whether to tighten the settings is a separate decision.

Are optional characteristics listed too?

Yes, if "Required characteristics only" is cleared. By default only required characteristics are listed, because optional ones are often left empty on purpose.

Does the report work on S/4HANA?

Yes. QAVE, QALS, QAMV and QAMR keep the same structure in S/4HANA.

Packages that include this solution

QM Package Custom

Quality Management Control Pack

A five-report pack for the weekly quality meeting: inspection lots awaiting a usage decision, decisions made before all results were recorded, blocked …

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: Usage Decisions Made Before All Characteristics Were Recorded Report