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
Tables used
The tables the report reads and their join fields. ECC and S/4HANA differences are marked separately.
| Table | Role | Join | System |
|---|---|---|---|
| QAVEUsage Decision | Usage decision with rejection valuation, code and date (driving table) | — | ECC + S/4 |
| QALSInspection Lot Record | Material, batch, storage location, vendor and quantity posted to blocked stock | QALS-PRUEFLOS = QAVE-PRUEFLOS | ECC + S/4 |
| MCHBBatch Stocks | Today's blocked stock per batch | MCHB-MATNR = QALS-MATNR AND MCHB-WERKS = QALS-WERK AND MCHB-LGORT = QALS-LAGORTCHRG AND MCHB-CHARG = QALS-CHARG | ECC + S/4 |
| MARDStorage Location Data for Material | Blocked stock per storage location for materials without batches | MARD-MATNR = QALS-MATNR AND MARD-WERKS = QALS-WERK AND MARD-LGORT = QALS-LAGORTCHRG | ECC + S/4 |
| MSEGMaterial Document Item | Movements out of blocked stock after the decision | MSEG-MATNR = QALS-MATNR AND MSEG-WERKS = QALS-WERK AND MSEG-CHARG = QALS-CHARG | ECC + S/4 |
| MBEWMaterial Valuation | Price for the value of the remaining blocked stock | MBEW-MATNR = QALS-MATNR AND MBEW-BWKEY = değerleme alanı (üretim yeri) | ECC + S/4 |
| QMELNotification Header | Quality notification linked to the lot | QMEL-PRUEFLOS = QALS-PRUEFLOS | ECC + S/4 |
| LFA1Vendor Master (General Section) | Vendor name | LFA1-LIFNR = QALS-LIFNR | ECC + 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
| Parameter | Description | Type | Reference field | Required | Example |
|---|---|---|---|---|---|
| S_WERK | Plant | Range / multiple | QALS-WERK | Yes | 1000 |
| S_MATNR | Material | Range / multiple | QALS-MATNR | No | RM-3105 |
| S_LIFNR | Vendor | Range / multiple | QALS-LIFNR | No | 100512 |
| S_VDAT | Usage decision date | Range / multiple | QAVE-VDATUM | Yes | 01.01.2026 – 17.11.2026 |
| S_VCODE | Decision code | Range / multiple | QAVE-VCODE | No | R1 |
| P_MINAGE | Minimum days since decision | Single value | — | No | 7 |
| P_KEYDT | Key date (default: today) | Single value | SY-DATUM | Yes | 17.11.2026 |
Output columns
| # | Column | Source |
|---|---|---|
| 1 | Inspection lot | QALS-PRUEFLOS |
| 2 | Material | QALS-MATNR |
| 3 | Material description | QALS-KTEXTMAT |
| 4 | Batch | QALS-CHARG |
| 5 | Vendor | QALS-LIFNR |
| 6 | Vendor name | LFA1-NAME1 |
| 7 | Decision code | QAVE-VCODE |
| 8 | Decision date | QAVE-VDATUM |
| 9 | Posted to blocked | QALS-LMENGE04 |
| 10 | Still blocked | MCHB-CSPEM |
| 11 | Unit | QALS-MENGENEINH |
| 12 | Blocked stock value | Calculated Remaining blocked qty × MBEW price ÷ MBEW-PEINH |
| 13 | Days since decision | Calculated Key date − QAVE-VDATUM |
| 14 | Quality notification | QMEL-QMNUM |
Sample output
| Inspection lot | Material | Material description | Batch | Vendor | Vendor name | Decision code | Decision date | Posted to blocked | Still blocked | Unit | Blocked stock value | Days since decision | Quality notification |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 010000004377 | RM-3105 | Solvent-based paint | B2610-14 | 100512 | Ege Kimya | R1 | 10/16/2026 | 300 | 300 | L | 42,600 | 32 | 000300001233 |
| 010000004421 | RM-1001 | Carton box 40x30 | 100245 | Atlas Ambalaj | R2 | 10/30/2026 | 2,000 | 1,000 | PC | 4,250 | 18 | ||
| 010000004466 | RM-2040 | Steel sheet 2 mm | B2611-02 | 100387 | Delta Metal | R1 | 11/06/2026 | 450 | 450 | KG | 27,540 | 11 | 000300001262 |
How does the report work?
- 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.
- 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.
- 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).
- Remaining blocked quantity = the smaller of (today’s blocked stock, LMENGE04 − later movements). Lines with zero are skipped. Value = remaining quantity × MBEW price ÷ PEINH.
- 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
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 …
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
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 …
Vendor Quality Scorecard and Rejection Rate (PPM) Report
A custom ALV report that shows, per vendor and material, the lot rejection rate from goods receipt inspection lots, the rejected quantity in parts per …
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.