WM Report Custom development ALV report

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

  • LS24 Display Quants for Material. Shows quants per material; gives neither the waiting time nor the open document that should clear the quant.
  • LX02 Stock List. Gives a stock list by storage type; does not trace the source of negative quants.

Tables used

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

TableRoleJoinSystem
LQUAQuantsQuants in interim storage types: quantity, goods receipt date, stock category (driving table)—ECC + S/4
LTBPTransfer Requirement ItemOpen transfer requirement items: requested quantity and quantity already in transfer ordersLTBP-LGNUM = LQUA-LGNUM AND LTBP-MATNR = LQUA-MATNR AND LTBP-WERKS = LQUA-WERKSECC + S/4
LTBKTransfer Requirement HeaderTransfer requirement header: material document, movement type, statusLTBK-LGNUM = LTBP-LGNUM AND LTBK-TBNUM = LTBP-TBNUMECC + S/4
LTAPTransfer Order ItemUnconfirmed items that carry the interim bin as source or destinationLTAP-LGNUM = LQUA-LGNUM AND LTAP-MATNR = LQUA-MATNR AND (LTAP-VLPLA = LQUA-LGPLA OR LTAP-NLPLA = LQUA-LGPLA)ECC + S/4
MAKTMaterial DescriptionsMaterial descriptionMAKT-MATNR = LQUA-MATNR AND MAKT-SPRAS = SY-LANGUECC + S/4

Selection screen parameters

ParameterDescriptionTypeReference fieldRequiredExample
S_LGNUMWarehouse numberRange / multipleLQUA-LGNUMYes100
S_LGTYPInterim storage typesRange / multipleLQUA-LGTYPYes902, 916, 921, 999
S_WERKSPlantRange / multipleLQUA-WERKSNo1000
S_MATNRMaterialRange / multipleLQUA-MATNRNoRM-1002
P_KEYDTKey dateSingle valueSY-DATUMYes17.11.2026
P_DAYSMinimum days waitingSingle value—No1
P_NEGNegative quants onlyCheckbox—No—

Output columns

#ColumnSource
1Storage typeLQUA-LGTYP
2Interim binLQUA-LGPLA
3MaterialLQUA-MATNR
4DescriptionMAKT-MAKTX
5BatchLQUA-CHARG
6Stock categoryLQUA-BESTQ
7Total qtyLQUA-GESME
8UnitLQUA-MEINS
9GR dateLQUA-WDATU
10Days waitingCalculated Key date − LQUA-WDATU
11NegativeCalculated X if LQUA-GESME < 0
12Transfer req.LTBP-TBNUM
13TR open qtyCalculated LTBP-MENGE − LTBP-TAMEN
14Material doc.LTBK-MBLNR
15Open TOLTAP-TANUM
16ExplanationCalculated Open TR, open TO or no source found

Sample output

Storage typeInterim binMaterialDescriptionBatchStock categoryTotal qtyUnitGR dateDays waitingNegativeTransfer req.TR open qtyMaterial doc.Open TOExplanation
9025000012834RM-1002Stretch film 50 cm300KG11/14/2026300000045213005000012834Open TR
9160080034490FG-5003Packed product C-24PC11/12/20265X00000081190Open TO
999SAYIM-2026FG-6200Detergent 5 kg-12CAR10/31/202617X0No source found
9025000012901RM-3105Solvent-based paintB2611-04Q180L11/15/2026200000045601805000012901Open TR
A view built with fictional sample data; not real system data.

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

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

WM Package Custom

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 …

5 components · v1.0

Related reports

WM Report Custom ALV report

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 …

T320 · MARD · LQUA · LTAP

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: Interim Storage Stuck and Negative Stock Report