# Blocked Stock Left from Rejected Usage Decisions Report

> 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.

- Type: Report, Custom development, ALV report
- Module: QM
- Estimated effort: M (3–5 working days)
- Last updated: 2026-11-17
- URL: https://nekuhub.com/en/reports/blocked-stock-from-rejected-usage-decisions-report/


## 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.

### Closest standard alternatives

- MMBE: Shows the blocked stock quantity; does not show which rejection it came from or the vendor.
- QA33: Lists lots with a rejection decision; does not show whether the quantity is still in blocked stock.

## Tables used

| Table | Role | Access | Join | System |
|---|---|---|---|---|
| QAVE | Usage decision with rejection valuation, code and date (driving table) | Read | - | ECC + S/4 |
| QALS | Material, batch, storage location, vendor and quantity posted to blocked stock | Read | QALS-PRUEFLOS = QAVE-PRUEFLOS | ECC + S/4 |
| MCHB | Today's blocked stock per batch | Read | MCHB-MATNR = QALS-MATNR AND MCHB-WERKS = QALS-WERK AND MCHB-LGORT = QALS-LAGORTCHRG AND MCHB-CHARG = QALS-CHARG | ECC + S/4 |
| MARD | Blocked stock per storage location for materials without batches | Read | MARD-MATNR = QALS-MATNR AND MARD-WERKS = QALS-WERK AND MARD-LGORT = QALS-LAGORTCHRG | ECC + S/4 |
| MSEG | Movements out of blocked stock after the decision | Read | MSEG-MATNR = QALS-MATNR AND MSEG-WERKS = QALS-WERK AND MSEG-CHARG = QALS-CHARG | ECC + S/4 |
| MBEW | Price for the value of the remaining blocked stock | Read | MBEW-MATNR = QALS-MATNR AND MBEW-BWKEY = değerleme alanı (üretim yeri) | ECC + S/4 |
| QMEL | Quality notification linked to the lot | Read | QMEL-PRUEFLOS = QALS-PRUEFLOS | ECC + S/4 |
| LFA1 | Vendor name | Read | LFA1-LIFNR = QALS-LIFNR | ECC + S/4 |

## Selection screen parameters

| Parameter | Description | Type | Reference field | Required |
|---|---|---|---|---|
| S_WERK | Plant | Range / multiple | QALS-WERK | Yes |
| S_MATNR | Material | Range / multiple | QALS-MATNR | No |
| S_LIFNR | Vendor | Range / multiple | QALS-LIFNR | No |
| S_VDAT | Usage decision date | Range / multiple | QAVE-VDATUM | Yes |
| S_VCODE | Decision code | Range / multiple | QAVE-VCODE | No |
| P_MINAGE | Minimum days since decision | Single value | - | No |
| P_KEYDT | Key date (default: today) | Single value | SY-DATUM | Yes |

## Output columns

| Column | Source |
|---|---|
| Inspection lot | QALS-PRUEFLOS |
| Material | QALS-MATNR |
| Material description | QALS-KTEXTMAT |
| Batch | QALS-CHARG |
| Vendor | QALS-LIFNR |
| Vendor name | LFA1-NAME1 |
| Decision code | QAVE-VCODE |
| Decision date | QAVE-VDATUM |
| Posted to blocked | QALS-LMENGE04 |
| Still blocked | MCHB-CSPEM |
| Unit | QALS-MENGENEINH |
| Blocked stock value | Calculated: Remaining blocked qty × MBEW price ÷ MBEW-PEINH |
| Days since decision | Calculated: Key date − QAVE-VDATUM |
| Quality notification | QMEL-QMNUM |

## 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.

## Authorization objects

- Q_INSPTYPE: Inspection lot authorization by inspection type
- M_MSEG_WMB: Material 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.

---
Let us build this report for your system: https://nekuhub.com/en/request-a-quote/?report=qm-rejected-ud-blocked-stock
