Inspection Lots Awaiting Usage Decision Aging Report
Short answer: 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.
- Estimated effort
- S · 3–4 working days
- System
- ECC and S/4HANA
- Tables
- 6
- Scope
- Global
- Built by
- NeKuDos Teknoloji
- Last updated
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.
Who uses it? Quality control engineers, laboratory supervisors, warehouse and production planners.
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 |
|---|---|---|---|
| QALSInspection Lot Record | Inspection lot: type, origin, material, batch, vendor, dates and quantities (driving table) | — | ECC + S/4 |
| QAMVCharacteristic Specifications for Inspection Processing | Inspection characteristics of the lot | QAMV-PRUEFLOS = QALS-PRUEFLOS | ECC + S/4 |
| QAMRCharacteristic Results During Inspection Processing | Characteristic results and valuation | QAMR-PRUEFLOS = QAMV-PRUEFLOS AND QAMR-VORGLFNR = QAMV-VORGLFNR AND QAMR-MERKNR = QAMV-MERKNR | ECC + S/4 |
| MBEWMaterial Valuation | Price for the value of quality stock | MBEW-MATNR = QALS-MATNR AND MBEW-BWKEY = değerleme alanı (üretim yeri) | ECC + S/4 |
| LFA1Vendor Master (General Section) | Vendor name | LFA1-LIFNR = QALS-LIFNR | ECC + S/4 |
| I_InspectionLotInspection Lot | In S/4HANA it can replace QALS with a clean core approach | InspectionLot = QALS-PRUEFLOS | S/4HANA only |
S/4HANA notes
- MBEW: In S/4HANA the Material Ledger is mandatory and valuation data is read through a compatibility view. Prices remain readable; validate value calculations against the currency and valuation view in use.
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 | 01 |
| S_HERK | Lot origin | Range / multiple | QALS-HERKUNFT | No | 01 |
| S_MATNR | Material | Range / multiple | QALS-MATNR | No | RM-3105 |
| S_LIFNR | Vendor | Range / multiple | QALS-LIFNR | No | 100512 |
| S_ENST | Lot creation date | Range / multiple | QALS-ENSTEHDAT | No | 01.09.2026 – 17.11.2026 |
| P_TARGET | Target time to usage decision (days) | Single value | — | Yes | 3 |
| P_KEYDT | Key date (default: today) | Single value | SY-DATUM | Yes | 17.11.2026 |
Output columns
| # | Column | Source |
|---|---|---|
| 1 | Inspection lot | QALS-PRUEFLOS |
| 2 | Inspection type | QALS-ART |
| 3 | Material | QALS-MATNR |
| 4 | Material description | QALS-KTEXTMAT |
| 5 | Batch | QALS-CHARG |
| 6 | Vendor | QALS-LIFNR |
| 7 | Vendor name | LFA1-NAME1 |
| 8 | Lot created | QALS-ENSTEHDAT |
| 9 | Planned end | QALS-PAENDTERM |
| 10 | Days waiting | Calculated Key date − QALS-ENSTEHDAT |
| 11 | Open characteristics | Calculated Number of QAMV characteristics without a QAMR result or valuation |
| 12 | Qty to be posted | QALS-LMENGEZUB |
| 13 | Unit | QALS-MENGENEINH |
| 14 | Quality stock value | Calculated QALS-LMENGEZUB × MBEW price ÷ MBEW-PEINH |
Sample output
| Inspection lot | Inspection type | Material | Material description | Batch | Vendor | Vendor name | Lot created | Planned end | Days waiting | Open characteristics | Qty to be posted | Unit | Quality stock value |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 010000004512 | 01 | RM-3105 | Solvent-based paint | B2611-07 | 100512 | Ege Kimya | 11/10/2026 | 11/12/2026 | 7 | 2 | 400 | L | 56,800 |
| 010000004530 | 01 | RM-1001 | Carton box 40x30 | 100245 | Atlas Ambalaj | 11/13/2026 | 11/14/2026 | 4 | 1 | 5,000 | PC | 21,250 | |
| 040000001877 | 04 | FG-2050 | Packed product B | P2611-15 | 11/15/2026 | 11/16/2026 | 2 | 3 | 1,200 | KG | 98,400 |
How does the report work?
- 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.
- The characteristics in QAMV are counted for each lot; those without a result in QAMR or with an empty valuation (MBEWERTG) count as open.
- Days waiting = key date − QALS-ENSTEHDAT. Lines above the target days are shown in red, lines past the planned inspection end (PAENDTERM) in yellow.
- Value in quality stock = quantity still to be posted (LMENGEZUB) × MBEW price (VERPR for price control V, STPRS for S) ÷ price unit (PEINH).
- The vendor name is added from LFA1; ALV shows subtotals per inspection type and material.
Performance notes
Narrow QALS by plant and creation date. Read QAMV and QAMR once with the list of open lots and count in memory.
Features
- ALV list (sort, filter, subtotals)
- User-specific layout variants
- Double-click drill-down to the document Double-clicking the lot number opens QA03, and QA11 for the usage decision.
- Export to Excel
- Runs as a background job
- Send the result by email Lots above the target time can be sent to the quality supervisor every morning.
Authorization objects
- Q_INSPTYPEInspection lot authorization by inspection type
- Q_TCODEQM 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.
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
Batch Shelf Life Tracking Report (Batches Close to Expiry)
A custom ALV report that lists batches close to or past their expiry date with remaining days, remaining shelf life percentage and stock value. Food, …
Mass Usage Decision for Inspection Lots That Passed All Characteristics
A custom background program that sets the usage decision with a chosen code for inspection lots whose characteristics were all accepted and that have …
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.