Interim Storage Stuck and Negative Stock Report
Short answer: 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.
- Estimated effort
- M · 3–5 working days
- System
- ECC and S/4HANA
- Tables
- 5
- Scope
- Global
- Built by
- NeKuDos Teknoloji
- Last updated
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.
Who uses it? Warehouse key users, inventory control teams and LE-WM support consultants.
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 |
|---|---|---|---|
| LQUAQuants | Quants in interim storage types: quantity, goods receipt date, stock category (driving table) | — | ECC + S/4 |
| LTBPTransfer Requirement Item | Open transfer requirement items: requested quantity and quantity already in transfer orders | LTBP-LGNUM = LQUA-LGNUM AND LTBP-MATNR = LQUA-MATNR AND LTBP-WERKS = LQUA-WERKS | ECC + S/4 |
| LTBKTransfer Requirement Header | Transfer requirement header: material document, movement type, status | LTBK-LGNUM = LTBP-LGNUM AND LTBK-TBNUM = LTBP-TBNUM | ECC + S/4 |
| LTAPTransfer Order Item | Unconfirmed items that carry the interim bin as source or destination | LTAP-LGNUM = LQUA-LGNUM AND LTAP-MATNR = LQUA-MATNR AND (LTAP-VLPLA = LQUA-LGPLA OR LTAP-NLPLA = LQUA-LGPLA) | ECC + S/4 |
| MAKTMaterial Descriptions | Material description | MAKT-MATNR = LQUA-MATNR AND MAKT-SPRAS = SY-LANGU | ECC + S/4 |
Selection screen parameters
| Parameter | Description | Type | Reference field | Required | Example |
|---|---|---|---|---|---|
| S_LGNUM | Warehouse number | Range / multiple | LQUA-LGNUM | Yes | 100 |
| S_LGTYP | Interim storage types | Range / multiple | LQUA-LGTYP | Yes | 902, 916, 921, 999 |
| S_WERKS | Plant | Range / multiple | LQUA-WERKS | No | 1000 |
| S_MATNR | Material | Range / multiple | LQUA-MATNR | No | RM-1002 |
| P_KEYDT | Key date | Single value | SY-DATUM | Yes | 17.11.2026 |
| P_DAYS | Minimum days waiting | Single value | — | No | 1 |
| P_NEG | Negative quants only | Checkbox | — | No | — |
Output columns
| # | Column | Source |
|---|---|---|
| 1 | Storage type | LQUA-LGTYP |
| 2 | Interim bin | LQUA-LGPLA |
| 3 | Material | LQUA-MATNR |
| 4 | Description | MAKT-MAKTX |
| 5 | Batch | LQUA-CHARG |
| 6 | Stock category | LQUA-BESTQ |
| 7 | Total qty | LQUA-GESME |
| 8 | Unit | LQUA-MEINS |
| 9 | GR date | LQUA-WDATU |
| 10 | Days waiting | Calculated Key date − LQUA-WDATU |
| 11 | Negative | Calculated X if LQUA-GESME < 0 |
| 12 | Transfer req. | LTBP-TBNUM |
| 13 | TR open qty | Calculated LTBP-MENGE − LTBP-TAMEN |
| 14 | Material doc. | LTBK-MBLNR |
| 15 | Open TO | LTAP-TANUM |
| 16 | Explanation | Calculated Open TR, open TO or no source found |
Sample output
| Storage type | Interim bin | Material | Description | Batch | Stock category | Total qty | Unit | GR date | Days waiting | Negative | Transfer req. | TR open qty | Material doc. | Open TO | Explanation |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 902 | 5000012834 | RM-1002 | Stretch film 50 cm | 300 | KG | 11/14/2026 | 3 | 0000004521 | 300 | 5000012834 | Open TR | ||||
| 916 | 0080034490 | FG-5003 | Packed product C | -24 | PC | 11/12/2026 | 5 | X | 0 | 0000081190 | Open TO | ||||
| 999 | SAYIM-2026 | FG-6200 | Detergent 5 kg | -12 | CAR | 10/31/2026 | 17 | X | 0 | No source found | |||||
| 902 | 5000012901 | RM-3105 | Solvent-based paint | B2611-04 | Q | 180 | L | 11/15/2026 | 2 | 0000004560 | 180 | 5000012901 | Open TR |
How does the report work?
- 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).
- Days waiting = key date − goods receipt date (WDATU). Quants newer than the threshold are dropped unless “Negative only” is selected.
- Negative quants (GESME < 0) are flagged separately.
- 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.
- 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).
Performance notes
Read LQUA by warehouse number and interim storage types; the number of quants in interim storage is usually small. Run the LTBP and LTAP lookups once for the materials found, using FOR ALL ENTRIES.
Features
- ALV list (sort, filter, subtotals)
- User-specific layout variants
- Double-click drill-down to the document Double-clicking a transfer requirement opens LB03; double-clicking a transfer order opens LT21.
- Export to Excel
- Runs as a background job
- Send the result by email Quants above the threshold can be sent to the warehouse owner before month-end.
Authorization objects
- L_LGNUMDisplay 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.
Packages that include this solution
Warehouse Operations Control Pack
A five-report pack that shows daily warehouse health per warehouse number: unconfirmed transfer orders, stock stuck in interim storage and negative …
Related reports
Automatic Putaway Transfer Order Creation Job for Goods Receipt Interim Storage
A custom background job that finds open transfer requirements waiting in goods receipt interim storage longer than a set time, converts them into …
WM vs IM Stock Comparison Report
A custom ALV report that compares inventory management stock per storage location (MARD) with the total of warehouse management quants (LQUA) by …
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.