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
Tables used
The tables the report reads and their join fields. ECC and S/4HANA differences are marked separately.
| Table | Role | Join | System |
|---|---|---|---|
| QAVEUsage Decision | Usage decision: code, valuation, date and deciding user (driving table) | — | ECC + S/4 |
| QALSInspection Lot Record | Plant, inspection type, material and batch | QALS-PRUEFLOS = QAVE-PRUEFLOS | ECC + S/4 |
| QAMVCharacteristic Specifications for Inspection Processing | Characteristics of the lot and their control indicators | QAMV-PRUEFLOS = QALS-PRUEFLOS | ECC + S/4 |
| QAMRCharacteristic Results During Inspection Processing | Characteristic result, number of values and valuation | QAMR-PRUEFLOS = QAMV-PRUEFLOS AND QAMR-VORGLFNR = QAMV-VORGLFNR AND QAMR-MERKNR = QAMV-MERKNR | ECC + S/4 |
| I_InspectionCharacteristicCharacteristic in Inspection Lot | In S/4HANA it can replace QAMV 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_ART | Inspection type | Range / multiple | QALS-ART | No | 04 |
| S_MATNR | Material | Range / multiple | QALS-MATNR | No | FG-2050 |
| S_VDAT | Usage decision date | Range / multiple | QAVE-VDATUM | Yes | 01.10.2026 – 31.10.2026 |
| S_VNAME | Decided by | Range / multiple | QAVE-VNAME | No | KALITE02 |
| S_VCODE | Decision code | Range / multiple | QAVE-VCODE | No | A1 |
| P_REQ | Required characteristics only | Checkbox | — | No | X |
Output columns
| # | Column | Source |
|---|---|---|
| 1 | Inspection lot | QALS-PRUEFLOS |
| 2 | Inspection type | QALS-ART |
| 3 | Material | QALS-MATNR |
| 4 | Batch | QALS-CHARG |
| 5 | Decision code | QAVE-VCODE |
| 6 | Decision valuation | QAVE-VBEWERTUNG |
| 7 | Decision date | QAVE-VDATUM |
| 8 | Decided by | QAVE-VNAME |
| 9 | Operation counter | QAMV-VORGLFNR |
| 10 | Characteristic no. | QAMV-MERKNR |
| 11 | Master characteristic | QAMV-VERWMERKM |
| 12 | Characteristic text | QAMV-KURZTEXT |
| 13 | Values recorded | QAMR-ANZWERTG |
| 14 | Characteristic valuation | QAMR-MBEWERTG |
Sample output
| Inspection lot | Inspection type | Material | Batch | Decision code | Decision valuation | Decision date | Decided by | Operation counter | Characteristic no. | Master characteristic | Characteristic text | Values recorded | Characteristic valuation |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 040000001802 | 04 | FG-2050 | P2610-22 | A1 | A | 10/23/2026 | KALITE02 | 00000001 | 0030 | VISKOZITE | Viscosity at 25 °C | 0 | |
| 040000001802 | 04 | FG-2050 | P2610-22 | A1 | A | 10/23/2026 | KALITE02 | 00000001 | 0040 | RENK-DELTAE | Colour difference ΔE | 0 | |
| 010000004398 | 01 | RM-1001 | A2 | A | 10/27/2026 | KALITE01 | 00000001 | 0020 | NEM | Moisture content | 2 |
How does the report work?
- 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.
- 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.
- Characteristics without a QAMR record, with an empty valuation (MBEWERTG) or with zero values recorded (ANZWERTG) count as missing.
- One line is created per missing characteristic, with the decision code (VCODE), valuation (VBEWERTUNG), date and the user who decided (VNAME).
- 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
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 …
Related reports
Inspection Lots Awaiting Usage Decision Aging Report
A custom ALV report that lists inspection lots without a usage decision, with how many days they have been waiting, whether they exceed the target …
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 …
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.