WM Report Custom development ALV report

Storage Bin Utilization and Empty Bin Report

Short answer: A custom ALV report that shows, per storage type and storage section, the weight and capacity utilization percentage of every bin, the empty bins and the putaway/removal blocks in one table. Warehouse managers see which area is filling up and which bins cannot be used because of a block.

Estimated effort
S · 2–3 working days
System
ECC and S/4HANA
Tables
4
Scope
Global
Built by
NeKuDos Teknoloji
Last updated

Why is the standard not enough?

LX03 gives a bin status list, LS04 shows empty bins and LS03N opens one bin; none of them calculates capacity and weight utilization percentages, gives total utilization per storage section or shows the block reason together with the occupancy. The utilization KPI is usually built manually in Excel every month.

Who uses it? Warehouse managers, warehouse planners and logistics controlling teams.

Closest standard alternatives

  • LX03 Bin Status Report. Gives the bin status list; does not calculate weight and capacity utilization percentages.
  • LS04 Display Empty Storage Bins. Lists empty bins; offers no combined view with blocked and full bins.

Tables used

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

TableRoleJoinSystem
LAGPStorage BinsStorage bin: section, bin type, empty/full indicator, weight, capacity and blocks (driving table)—ECC + S/4
LQUAQuantsQuants in the bin; used for the bin's materialLQUA-LGNUM = LAGP-LGNUM AND LQUA-LGTYP = LAGP-LGTYP AND LQUA-LGPLA = LAGP-LGPLAECC + S/4
T303WM Storage Bin TypesStorage bin type definitionT303-LGNUM = LAGP-LGNUM AND T303-LPTYP = LAGP-LPTYPECC + S/4
T302WM Storage SectionsStorage section definitionT302-LGNUM = LAGP-LGNUM AND T302-LGTYP = LAGP-LGTYP AND T302-LGBER = LAGP-LGBERECC + S/4

Selection screen parameters

ParameterDescriptionTypeReference fieldRequiredExample
S_LGNUMWarehouse numberRange / multipleLAGP-LGNUMYes100
S_LGTYPStorage typeRange / multipleLAGP-LGTYPNo001
S_LGBERStorage sectionRange / multipleLAGP-LGBERNo001
S_LPTYPBin typeRange / multipleLAGP-LPTYPNoP1
P_MINPCTUtilization threshold (%)Single value—No85
P_EMPTYEmpty bins onlyCheckbox—No—
P_BLOCKBlocked bins onlyCheckbox—No—

Output columns

#ColumnSource
1Storage typeLAGP-LGTYP
2Storage binLAGP-LGPLA
3SectionLAGP-LGBER
4Bin typeLAGP-LPTYP
5EmptyLAGP-KZLER
6FullLAGP-KZVOL
7QuantsLAGP-ANZQU
8Load weightLAGP-LGEWI
9Max. weightLAGP-MGEWI
10Weight util. %Calculated LAGP-LGEWI ÷ LAGP-MGEWI × 100
11Total capacityLAGP-LKAPV
12Remaining capacityLAGP-RKAPV
13Capacity util. %Calculated (LAGP-LKAPV − LAGP-RKAPV) ÷ LAGP-LKAPV × 100
14Putaway blockLAGP-SKZUE
15Removal blockLAGP-SKZUA
16Block reasonLAGP-SPGRU

Sample output

Storage typeStorage binSectionBin typeEmptyFullQuantsLoad weightMax. weightWeight util. %Total capacityRemaining capacityCapacity util. %Putaway blockRemoval blockBlock reason
00101-05-03001P1X19201,00092100892
00101-05-04001P1X001,00001001000
00101-06-01002P2243080053.80803556.30X1
00202-11-01001K1318025072501472X2
A view built with fictional sample data; not real system data.

How does the report work?

  1. LAGP is read with the selection criteria: storage type, storage section, bin type, empty indicator (KZLER), full indicator (KZVOL), number of quants (ANZQU), load weight (LGEWI), maximum weight (MGEWI), total and remaining capacity (LKAPV, RKAPV) and blocks.
  2. Weight utilization % = LGEWI ÷ MGEWI × 100; capacity utilization % = (LKAPV − RKAPV) ÷ LKAPV × 100. Bins with a zero maximum get an empty ratio.
  3. The bin type text is added from T303; if the bin holds quants, the material of the first quant is taken from LQUA.
  4. With “Empty only”, bins with KZLER = X remain; with “Blocked only”, bins with SKZUE/SKZUA set remain; with a utilization threshold, bins above it are listed.
  5. The ALV shows bin count, empty bin count and average utilization as subtotals per storage type and storage section.

Performance notes

Restrict LAGP by warehouse number and storage type; the primary key starts with these fields. Read LQUA only for non-empty bins with FOR ALL ENTRIES. For warehouses with tens of thousands of bins, run the report overnight in the background.

Features

  • ALV list (sort, filter, subtotals)
  • User-specific layout variants
  • Double-click drill-down to the document Double-clicking a bin displays it in LS03N.
  • Export to Excel
  • Runs as a background job

Authorization objects

  • L_LGNUMDisplay authorization by warehouse number and storage type

Frequently asked questions

What does the report show for storage types without capacity check?

Storage types without capacity check keep LKAPV and MGEWI at zero; for those bins the utilization ratio stays empty, while the empty/full indicator and quant count are still reported.

Can utilization be taken for a past date?

LAGP only holds the current state. To track month-end utilization, the report can run as a background job and write the result into a snapshot table; this adds effort.

How is it adapted for systems using EWM?

In EWM, storage bins are in /SCWM/LAGP and quants in /SCWM/QUAN. The calculation stays the same; the read layer is written for the EWM tables.

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

Cycle Count Due Bins and Count Progress Report

A custom ALV report that shows the storage bins whose count is due or overdue based on the last count date and the material's cycle counting …

LAGP · LQUA · MARC · LINK

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: Storage Bin Utilization and Empty Bin Report