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
Tables used
The tables the report reads and their join fields. ECC and S/4HANA differences are marked separately.
| Table | Role | Join | System |
|---|---|---|---|
| LAGPStorage Bins | Storage bin: section, bin type, empty/full indicator, weight, capacity and blocks (driving table) | — | ECC + S/4 |
| LQUAQuants | Quants in the bin; used for the bin's material | LQUA-LGNUM = LAGP-LGNUM AND LQUA-LGTYP = LAGP-LGTYP AND LQUA-LGPLA = LAGP-LGPLA | ECC + S/4 |
| T303WM Storage Bin Types | Storage bin type definition | T303-LGNUM = LAGP-LGNUM AND T303-LPTYP = LAGP-LPTYP | ECC + S/4 |
| T302WM Storage Sections | Storage section definition | T302-LGNUM = LAGP-LGNUM AND T302-LGTYP = LAGP-LGTYP AND T302-LGBER = LAGP-LGBER | ECC + S/4 |
Selection screen parameters
| Parameter | Description | Type | Reference field | Required | Example |
|---|---|---|---|---|---|
| S_LGNUM | Warehouse number | Range / multiple | LAGP-LGNUM | Yes | 100 |
| S_LGTYP | Storage type | Range / multiple | LAGP-LGTYP | No | 001 |
| S_LGBER | Storage section | Range / multiple | LAGP-LGBER | No | 001 |
| S_LPTYP | Bin type | Range / multiple | LAGP-LPTYP | No | P1 |
| P_MINPCT | Utilization threshold (%) | Single value | — | No | 85 |
| P_EMPTY | Empty bins only | Checkbox | — | No | — |
| P_BLOCK | Blocked bins only | Checkbox | — | No | — |
Output columns
| # | Column | Source |
|---|---|---|
| 1 | Storage type | LAGP-LGTYP |
| 2 | Storage bin | LAGP-LGPLA |
| 3 | Section | LAGP-LGBER |
| 4 | Bin type | LAGP-LPTYP |
| 5 | Empty | LAGP-KZLER |
| 6 | Full | LAGP-KZVOL |
| 7 | Quants | LAGP-ANZQU |
| 8 | Load weight | LAGP-LGEWI |
| 9 | Max. weight | LAGP-MGEWI |
| 10 | Weight util. % | Calculated LAGP-LGEWI ÷ LAGP-MGEWI × 100 |
| 11 | Total capacity | LAGP-LKAPV |
| 12 | Remaining capacity | LAGP-RKAPV |
| 13 | Capacity util. % | Calculated (LAGP-LKAPV − LAGP-RKAPV) ÷ LAGP-LKAPV × 100 |
| 14 | Putaway block | LAGP-SKZUE |
| 15 | Removal block | LAGP-SKZUA |
| 16 | Block reason | LAGP-SPGRU |
Sample output
| Storage type | Storage bin | Section | Bin type | Empty | Full | Quants | Load weight | Max. weight | Weight util. % | Total capacity | Remaining capacity | Capacity util. % | Putaway block | Removal block | Block reason |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 001 | 01-05-03 | 001 | P1 | X | 1 | 920 | 1,000 | 92 | 100 | 8 | 92 | ||||
| 001 | 01-05-04 | 001 | P1 | X | 0 | 0 | 1,000 | 0 | 100 | 100 | 0 | ||||
| 001 | 01-06-01 | 002 | P2 | 2 | 430 | 800 | 53.80 | 80 | 35 | 56.30 | X | 1 | |||
| 002 | 02-11-01 | 001 | K1 | 3 | 180 | 250 | 72 | 50 | 14 | 72 | X | 2 |
How does the report work?
- 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.
- Weight utilization % = LGEWI ÷ MGEWI × 100; capacity utilization % = (LKAPV − RKAPV) ÷ LKAPV × 100. Bins with a zero maximum get an empty ratio.
- The bin type text is added from T303; if the bin holds quants, the material of the first quant is taken from LQUA.
- 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.
- 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
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
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 …
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.