# Interim Storage Stuck and Negative Stock Report

> A custom ALV report that lists quants in goods receipt, shipping, posting change and difference interim storage types that have been waiting longer than a set time or have gone negative, together with the open transfer requirement and transfer order that should clear them. Warehouse teams clean up interim storage before month-end.

- Type: Report, Custom development, ALV report
- Module: WM
- Estimated effort: M (3–5 working days)
- Last updated: 2026-11-17
- URL: https://nekuhub.com/en/reports/interim-storage-stuck-and-negative-stock-report/


## Why is the standard not enough?

LX02 and LS24 show quants in interim storage types, but they do not calculate how long a quant has been waiting and do not show the material document, the open transfer requirement or the unconfirmed transfer order that created it on the same line. The cause of negative quants is usually searched one by one across LB10, LT22 and MB51.

### Closest standard alternatives

- LS24: Shows quants per material; gives neither the waiting time nor the open document that should clear the quant.
- LX02: Gives a stock list by storage type; does not trace the source of negative quants.

## Tables used

| Table | Role | Access | Join | System |
|---|---|---|---|---|
| LQUA | Quants in interim storage types: quantity, goods receipt date, stock category (driving table) | Read | - | ECC + S/4 |
| LTBP | Open transfer requirement items: requested quantity and quantity already in transfer orders | Read | LTBP-LGNUM = LQUA-LGNUM AND LTBP-MATNR = LQUA-MATNR AND LTBP-WERKS = LQUA-WERKS | ECC + S/4 |
| LTBK | Transfer requirement header: material document, movement type, status | Read | LTBK-LGNUM = LTBP-LGNUM AND LTBK-TBNUM = LTBP-TBNUM | ECC + S/4 |
| LTAP | Unconfirmed items that carry the interim bin as source or destination | Read | LTAP-LGNUM = LQUA-LGNUM AND LTAP-MATNR = LQUA-MATNR AND (LTAP-VLPLA = LQUA-LGPLA OR LTAP-NLPLA = LQUA-LGPLA) | ECC + S/4 |
| MAKT | Material description | Read | MAKT-MATNR = LQUA-MATNR AND MAKT-SPRAS = SY-LANGU | ECC + S/4 |

## Selection screen parameters

| Parameter | Description | Type | Reference field | Required |
|---|---|---|---|---|
| S_LGNUM | Warehouse number | Range / multiple | LQUA-LGNUM | Yes |
| S_LGTYP | Interim storage types | Range / multiple | LQUA-LGTYP | Yes |
| S_WERKS | Plant | Range / multiple | LQUA-WERKS | No |
| S_MATNR | Material | Range / multiple | LQUA-MATNR | No |
| P_KEYDT | Key date | Single value | SY-DATUM | Yes |
| P_DAYS | Minimum days waiting | Single value | - | No |
| P_NEG | Negative quants only | Checkbox | - | No |

## Output columns

| Column | Source |
|---|---|
| Storage type | LQUA-LGTYP |
| Interim bin | LQUA-LGPLA |
| Material | LQUA-MATNR |
| Description | MAKT-MAKTX |
| Batch | LQUA-CHARG |
| Stock category | LQUA-BESTQ |
| Total qty | LQUA-GESME |
| Unit | LQUA-MEINS |
| GR date | LQUA-WDATU |
| Days waiting | Calculated: Key date − LQUA-WDATU |
| Negative | Calculated: X if LQUA-GESME < 0 |
| Transfer req. | LTBP-TBNUM |
| TR open qty | Calculated: LTBP-MENGE − LTBP-TAMEN |
| Material doc. | LTBK-MBLNR |
| Open TO | LTAP-TANUM |
| Explanation | Calculated: Open TR, open TO or no source found |

## How does the report work?

1. LQUA is read for the selected interim storage types (for example 902, 916, 921, 999). In interim storage the bin number usually carries the reference document (LGPLA).
2. Days waiting = key date − goods receipt date (WDATU). Quants newer than the threshold are dropped unless "Negative only" is selected.
3. Negative quants (GESME < 0) are flagged separately.
4. For the material and plant, open transfer requirements with remaining quantity (MENGE − TAMEN) greater than zero are found in LTBP; the material document (MBLNR) and movement type are added from LTBK.
5. LTAP is searched for unconfirmed items that carry this interim bin as source or destination. Explanation: open TR exists, open TO exists or "no source found" (needs manual correction).

## Authorization objects

- L_LGNUM: Display authorization by warehouse number and storage type

## Frequently asked questions

### Which storage types count as interim storage?

In a standard setup, storage types starting with 9 (902 goods receipt, 916 shipping, 921 posting change, 999 differences) are interim. You can enter your own interim types on the selection screen.

### Why do negative quants occur?

They usually occur when goods issue is posted before the transfer order is confirmed, or after a transfer order was cancelled. The report tries to find the open transfer order or requirement that should clear the quant; if none is found, the row is flagged for manual correction.

### Does the report post corrections?

No, it only reads. Corrections are made in the standard process with LT01 or LT04; if needed, a separate clean-up program can be built on the same logic.

---
Let us build this report for your system: https://nekuhub.com/en/request-a-quote/?report=wm-interim-storage-stuck-negative-stock
