QM Report Custom development ALV report

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

  • QA32 Change Data for Inspection Lot. Lists inspection lots and their status; does not compare waiting time with a target or show stock value.
  • QA33 Display Data for Inspection Lot. Lists lots with a usage decision; does not age lots that are still waiting.

Tables used

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

TableRoleJoinSystem
QALSInspection Lot RecordInspection lot: type, origin, material, batch, vendor, dates and quantities (driving table)—ECC + S/4
QAMVCharacteristic Specifications for Inspection ProcessingInspection characteristics of the lotQAMV-PRUEFLOS = QALS-PRUEFLOSECC + S/4
QAMRCharacteristic Results During Inspection ProcessingCharacteristic results and valuationQAMR-PRUEFLOS = QAMV-PRUEFLOS AND QAMR-VORGLFNR = QAMV-VORGLFNR AND QAMR-MERKNR = QAMV-MERKNRECC + S/4
MBEWMaterial ValuationPrice for the value of quality stockMBEW-MATNR = QALS-MATNR AND MBEW-BWKEY = değerleme alanı (üretim yeri)ECC + S/4
LFA1Vendor Master (General Section)Vendor nameLFA1-LIFNR = QALS-LIFNRECC + S/4
I_InspectionLotInspection LotIn S/4HANA it can replace QALS with a clean core approachInspectionLot = QALS-PRUEFLOSS/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

ParameterDescriptionTypeReference fieldRequiredExample
S_WERKPlantRange / multipleQALS-WERKYes1000
S_ARTInspection typeRange / multipleQALS-ARTNo01
S_HERKLot originRange / multipleQALS-HERKUNFTNo01
S_MATNRMaterialRange / multipleQALS-MATNRNoRM-3105
S_LIFNRVendorRange / multipleQALS-LIFNRNo100512
S_ENSTLot creation dateRange / multipleQALS-ENSTEHDATNo01.09.2026 – 17.11.2026
P_TARGETTarget time to usage decision (days)Single value—Yes3
P_KEYDTKey date (default: today)Single valueSY-DATUMYes17.11.2026

Output columns

#ColumnSource
1Inspection lotQALS-PRUEFLOS
2Inspection typeQALS-ART
3MaterialQALS-MATNR
4Material descriptionQALS-KTEXTMAT
5BatchQALS-CHARG
6VendorQALS-LIFNR
7Vendor nameLFA1-NAME1
8Lot createdQALS-ENSTEHDAT
9Planned endQALS-PAENDTERM
10Days waitingCalculated Key date − QALS-ENSTEHDAT
11Open characteristicsCalculated Number of QAMV characteristics without a QAMR result or valuation
12Qty to be postedQALS-LMENGEZUB
13UnitQALS-MENGENEINH
14Quality stock valueCalculated QALS-LMENGEZUB × MBEW price ÷ MBEW-PEINH

Sample output

Inspection lotInspection typeMaterialMaterial descriptionBatchVendorVendor nameLot createdPlanned endDays waitingOpen characteristicsQty to be postedUnitQuality stock value
01000000451201RM-3105Solvent-based paintB2611-07100512Ege Kimya11/10/202611/12/202672400L56,800
01000000453001RM-1001Carton box 40x30100245Atlas Ambalaj11/13/202611/14/2026415,000PC21,250
04000000187704FG-2050Packed product BP2611-1511/15/202611/16/2026231,200KG98,400
A view built with fictional sample data; not real system data.

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.

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

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

MM Report Custom ALV report ChemicalsFood and Beverage

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, …

MCHB · MCHA · MARA · MAKT

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: Inspection Lots Awaiting Usage Decision Aging Report