# 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 time, how many characteristics are still open and the value waiting in quality inspection stock. Quality teams see in one list which lot is holding up production or shipping.

- Type: Report, Custom development, ALV report
- Module: QM
- Estimated effort: S (3–4 working days)
- Last updated: 2026-11-17
- URL: https://nekuhub.com/en/reports/inspection-lots-awaiting-usage-decision-report/


## Why is the standard not enough?

QA32 lists inspection lots and their status; QA33 shows lots with a usage decision. Neither compares the days since lot creation with a target time, shows the number of open characteristics or calculates the value of the quantity waiting in quality inspection stock. The cost of waiting lots and which lot comes first remain hidden.

### Closest standard alternatives

- QA32: Lists inspection lots and their status; does not compare waiting time with a target or show stock value.
- QA33: Lists lots with a usage decision; does not age lots that are still waiting.

## Tables used

| Table | Role | Access | Join | System |
|---|---|---|---|---|
| QALS | Inspection lot: type, origin, material, batch, vendor, dates and quantities (driving table) | Read | - | ECC + S/4 |
| QAMV | Inspection characteristics of the lot | Read | QAMV-PRUEFLOS = QALS-PRUEFLOS | ECC + S/4 |
| QAMR | Characteristic results and valuation | Read | QAMR-PRUEFLOS = QAMV-PRUEFLOS AND QAMR-VORGLFNR = QAMV-VORGLFNR AND QAMR-MERKNR = QAMV-MERKNR | ECC + S/4 |
| MBEW | Price for the value of quality stock | Read | MBEW-MATNR = QALS-MATNR AND MBEW-BWKEY = değerleme alanı (üretim yeri) | ECC + S/4 |
| LFA1 | Vendor name | Read | LFA1-LIFNR = QALS-LIFNR | ECC + S/4 |
| I_InspectionLot | In S/4HANA it can replace QALS 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_HERK | Lot origin | Range / multiple | QALS-HERKUNFT | No |
| S_MATNR | Material | Range / multiple | QALS-MATNR | No |
| S_LIFNR | Vendor | Range / multiple | QALS-LIFNR | No |
| S_ENST | Lot creation date | Range / multiple | QALS-ENSTEHDAT | No |
| P_TARGET | Target time to usage decision (days) | Single value | - | Yes |
| P_KEYDT | Key date (default: today) | Single value | SY-DATUM | Yes |

## Output columns

| Column | Source |
|---|---|
| Inspection lot | QALS-PRUEFLOS |
| Inspection type | QALS-ART |
| Material | QALS-MATNR |
| Material description | QALS-KTEXTMAT |
| Batch | QALS-CHARG |
| Vendor | QALS-LIFNR |
| Vendor name | LFA1-NAME1 |
| Lot created | QALS-ENSTEHDAT |
| Planned end | QALS-PAENDTERM |
| Days waiting | Calculated: Key date − QALS-ENSTEHDAT |
| Open characteristics | Calculated: Number of QAMV characteristics without a QAMR result or valuation |
| Qty to be posted | QALS-LMENGEZUB |
| Unit | QALS-MENGENEINH |
| Quality stock value | Calculated: QALS-LMENGEZUB × MBEW price ÷ MBEW-PEINH |

## How does the report work?

1. QALS is read with the plant, inspection type, lot origin, material, vendor and creation date from the selection screen; lots with a usage decision (QALS-STAT35 set) are skipped.
2. The characteristics in QAMV are counted for each lot; those without a result in QAMR or with an empty valuation (MBEWERTG) count as open.
3. Days waiting = key date − QALS-ENSTEHDAT. Lines above the target days are shown in red, lines past the planned inspection end (PAENDTERM) in yellow.
4. Value in quality stock = quantity still to be posted (LMENGEZUB) × MBEW price (VERPR for price control V, STPRS for S) ÷ price unit (PEINH).
5. The vendor name is added from LFA1; ALV shows subtotals per inspection type and material.

## Authorization objects

- Q_INSPTYPE: Inspection lot authorization by inspection type
- Q_TCODE: QM transaction code authorization

## Frequently asked questions

### Can the target time differ by inspection type?

Yes. Instead of a single target on the selection screen, a small maintenance table with a target per inspection type can be added; this adds about a day to the effort range.

### Are materials without batch management listed too?

Yes. The batch field stays empty; quantity and value are calculated from the quantity still to be posted on the inspection lot.

### Does the report work on S/4HANA?

Yes. QALS, QAMV and QAMR are also used in S/4HANA; for clean core, the I_InspectionLot and I_InspectionCharacteristic views can be preferred.

---
Let us build this report for your system: https://nekuhub.com/en/request-a-quote/?report=qm-inspection-lots-pending-ud-aging
