QM Report Custom development ALV report

Blocked Stock Left from Rejected Usage Decisions Report

Short answer: A custom ALV report that lists the quantities rejected at the usage decision and posted to blocked stock that are still sitting in blocked stock, with the days since the decision, the vendor, the related quality notification and the stock value. Quality and warehouse teams see rejected stock that has not been returned to the vendor or scrapped, with someone to own it.

Estimated effort
M · 3–5 working days
System
ECC and S/4HANA
Tables
8
Scope
Global
Built by
NeKuDos Teknoloji
Last updated

Why is the standard not enough?

MMBE and MB52 show blocked stock quantities but not why the stock is blocked, which usage decision it came from or the vendor. QA33 lists lots with a rejection decision but does not show whether the quantity is still in blocked stock, was returned to the vendor or was scrapped. Weeks later, blocked stock with no owner piles up.

Who uses it? Quality control supervisors, warehouse managers, purchasing and cost control teams.

Closest standard alternatives

  • MMBE Stock Overview. Shows the blocked stock quantity; does not show which rejection it came from or the vendor.
  • QA33 Display Data for Inspection Lot. Lists lots with a rejection decision; does not show whether the quantity is still in blocked stock.

Tables used

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

TableRoleJoinSystem
QAVEUsage DecisionUsage decision with rejection valuation, code and date (driving table)—ECC + S/4
QALSInspection Lot RecordMaterial, batch, storage location, vendor and quantity posted to blocked stockQALS-PRUEFLOS = QAVE-PRUEFLOSECC + S/4
MCHBBatch StocksToday's blocked stock per batchMCHB-MATNR = QALS-MATNR AND MCHB-WERKS = QALS-WERK AND MCHB-LGORT = QALS-LAGORTCHRG AND MCHB-CHARG = QALS-CHARGECC + S/4
MARDStorage Location Data for MaterialBlocked stock per storage location for materials without batchesMARD-MATNR = QALS-MATNR AND MARD-WERKS = QALS-WERK AND MARD-LGORT = QALS-LAGORTCHRGECC + S/4
MSEGMaterial Document ItemMovements out of blocked stock after the decisionMSEG-MATNR = QALS-MATNR AND MSEG-WERKS = QALS-WERK AND MSEG-CHARG = QALS-CHARGECC + S/4
MBEWMaterial ValuationPrice for the value of the remaining blocked stockMBEW-MATNR = QALS-MATNR AND MBEW-BWKEY = değerleme alanı (üretim yeri)ECC + S/4
QMELNotification HeaderQuality notification linked to the lotQMEL-PRUEFLOS = QALS-PRUEFLOSECC + S/4
LFA1Vendor Master (General Section)Vendor nameLFA1-LIFNR = QALS-LIFNRECC + S/4

S/4HANA notes

  • MCHB → MATDOC: In S/4HANA batch stock quantities are calculated from MATDOC through a compatibility view; reads work, but test performance on large selections.
  • MARD → MATDOC: In S/4HANA stock quantities are no longer stored physically; reading MARD returns values calculated on the fly from MATDOC through a compatibility view. Reads still work, but test performance on very large selections.
  • MSEG → MATDOC: In S/4HANA MATDOC replaces MSEG; reading MSEG works through a compatibility view but is slow at high volumes.
  • 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_MATNRMaterialRange / multipleQALS-MATNRNoRM-3105
S_LIFNRVendorRange / multipleQALS-LIFNRNo100512
S_VDATUsage decision dateRange / multipleQAVE-VDATUMYes01.01.2026 – 17.11.2026
S_VCODEDecision codeRange / multipleQAVE-VCODENoR1
P_MINAGEMinimum days since decisionSingle value—No7
P_KEYDTKey date (default: today)Single valueSY-DATUMYes17.11.2026

Output columns

#ColumnSource
1Inspection lotQALS-PRUEFLOS
2MaterialQALS-MATNR
3Material descriptionQALS-KTEXTMAT
4BatchQALS-CHARG
5VendorQALS-LIFNR
6Vendor nameLFA1-NAME1
7Decision codeQAVE-VCODE
8Decision dateQAVE-VDATUM
9Posted to blockedQALS-LMENGE04
10Still blockedMCHB-CSPEM
11UnitQALS-MENGENEINH
12Blocked stock valueCalculated Remaining blocked qty × MBEW price ÷ MBEW-PEINH
13Days since decisionCalculated Key date − QAVE-VDATUM
14Quality notificationQMEL-QMNUM

Sample output

Inspection lotMaterialMaterial descriptionBatchVendorVendor nameDecision codeDecision datePosted to blockedStill blockedUnitBlocked stock valueDays since decisionQuality notification
010000004377RM-3105Solvent-based paintB2610-14100512Ege KimyaR110/16/2026300300L42,60032000300001233
010000004421RM-1001Carton box 40x30100245Atlas AmbalajR210/30/20262,0001,000PC4,25018
010000004466RM-2040Steel sheet 2 mmB2611-02100387Delta MetalR111/06/2026450450KG27,54011000300001262
A view built with fictional sample data; not real system data.

How does the report work?

  1. Lots with a rejecting usage decision (QAVE-VBEWERTUNG = R) and a decision date in the selected range are read from QAVE and QALS; the quantity posted to blocked stock is QALS-LMENGE04.
  2. Today’s blocked stock is read from MCHB-CSPEM for batch-managed materials (material, plant, storage location QALS-LAGORTCHRG, batch) and from MARD-SPEME for the others.
  3. Movements out of blocked stock for the same material and batch after the decision date are summed from MSEG (movement types for return to vendor, scrapping from blocked stock and transfer to unrestricted stock; MSEG-BUDAT_MKPF ≥ decision date).
  4. Remaining blocked quantity = the smaller of (today’s blocked stock, LMENGE04 − later movements). Lines with zero are skipped. Value = remaining quantity × MBEW price ÷ PEINH.
  5. Days since the decision are calculated; the quality notification linked to the lot (QMEL-PRUEFLOS) and the vendor name (LFA1) are added.

Performance notes

Read MSEG only with the material–batch list of rejected lots and posting dates after the decision; on large systems, plant and date restrictions on MSEG are a must. In S/4HANA, MATDOC or the related CDS view replaces MSEG.

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 the material opens MMBE.
  • Export to Excel
  • Runs as a background job
  • Send the result by email Rejected stock older than the set number of days can be sent weekly to the quality and purchasing teams.

Authorization objects

  • Q_INSPTYPEInspection lot authorization by inspection type
  • M_MSEG_WMBMaterial document and stock display authorization by plant

Frequently asked questions

Why can the blocked stock differ from the quantity on the inspection lot?

The same batch may hold blocked stock for other reasons, or part of the rejected stock may have moved later. The report therefore uses the smaller of today's blocked stock and the decision quantity minus later movements as the remaining quantity.

Can the return to vendor be started from the report?

The report only lists. For the selected lines, a return to vendor can be posted in MIGO, or a separate mass return program can be built.

Does the report work on S/4HANA?

Yes. In S/4HANA stock and movement data is read from MATDOC, and MCHB and MARD can still be read through compatibility views; the QM tables are the same.

Packages that include this solution

MM Package Custom

Inventory Control and GR/IR Pack

A five-report pack that tracks stock value and stock accuracy with one plant and storage location selection: stock aging, materials below safety …

5 components · v1.0

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 Standard ALV report

MB52 – List of Warehouse Stocks on Hand

MB52 is the standard SAP report (program RM07MLBS) that lists current material stocks per plant and storage location by stock type, together with …

MARD · MARA · MAKT · MBEW

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: Blocked Stock Left from Rejected Usage Decisions Report