# Usage Decisions Made Before All Characteristics Were Recorded Report

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

- Type: Report, Custom development, ALV report
- Module: QM
- Estimated effort: S (2–4 working days)
- Last updated: 2026-11-17
- URL: https://nekuhub.com/en/reports/usage-decisions-with-missing-inspection-results-report/


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

### Closest standard alternatives

- QA33: Lists lots with a usage decision; does not show which characteristic was left without a result.
- QE51N: Shows and records results lot by lot; does not list gaps after the decision across lots.

## Tables used

| Table | Role | Access | Join | System |
|---|---|---|---|---|
| QAVE | Usage decision: code, valuation, date and deciding user (driving table) | Read | - | ECC + S/4 |
| QALS | Plant, inspection type, material and batch | Read | QALS-PRUEFLOS = QAVE-PRUEFLOS | ECC + S/4 |
| QAMV | Characteristics of the lot and their control indicators | Read | QAMV-PRUEFLOS = QALS-PRUEFLOS | ECC + S/4 |
| QAMR | Characteristic result, number of values and valuation | Read | QAMR-PRUEFLOS = QAMV-PRUEFLOS AND QAMR-VORGLFNR = QAMV-VORGLFNR AND QAMR-MERKNR = QAMV-MERKNR | ECC + S/4 |
| I_InspectionCharacteristic | In S/4HANA it can replace QAMV with a clean core approach | Read | InspectionLot = QALS-PRUEFLOS | S/4HANA only |

## Selection screen parameters

| Parameter | Description | Type | Reference field | Required |
|---|---|---|---|---|
| S_WERK | Plant | Range / multiple | QALS-WERK | Yes |
| S_ART | Inspection type | Range / multiple | QALS-ART | No |
| S_MATNR | Material | Range / multiple | QALS-MATNR | No |
| S_VDAT | Usage decision date | Range / multiple | QAVE-VDATUM | Yes |
| S_VNAME | Decided by | Range / multiple | QAVE-VNAME | No |
| S_VCODE | Decision code | Range / multiple | QAVE-VCODE | No |
| P_REQ | Required characteristics only | Checkbox | - | No |

## Output columns

| Column | Source |
|---|---|
| Inspection lot | QALS-PRUEFLOS |
| Inspection type | QALS-ART |
| Material | QALS-MATNR |
| Batch | QALS-CHARG |
| Decision code | QAVE-VCODE |
| Decision valuation | QAVE-VBEWERTUNG |
| Decision date | QAVE-VDATUM |
| Decided by | QAVE-VNAME |
| Operation counter | QAMV-VORGLFNR |
| Characteristic no. | QAMV-MERKNR |
| Master characteristic | QAMV-VERWMERKM |
| Characteristic text | QAMV-KURZTEXT |
| Values recorded | QAMR-ANZWERTG |
| Characteristic valuation | QAMR-MBEWERTG |

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

## Authorization objects

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

---
Let us build this report for your system: https://nekuhub.com/en/request-a-quote/?report=qm-ud-with-missing-results
