# Storage Bin Utilization and Empty Bin Report

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

- Type: Report, Custom development, ALV report
- Module: WM
- Estimated effort: S (2–3 working days)
- Last updated: 2026-11-17
- URL: https://nekuhub.com/en/reports/storage-bin-utilization-and-empty-bin-report/


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

### Closest standard alternatives

- LX03: Gives the bin status list; does not calculate weight and capacity utilization percentages.
- LS04: Lists empty bins; offers no combined view with blocked and full bins.

## Tables used

| Table | Role | Access | Join | System |
|---|---|---|---|---|
| LAGP | Storage bin: section, bin type, empty/full indicator, weight, capacity and blocks (driving table) | Read | - | ECC + S/4 |
| LQUA | Quants in the bin; used for the bin's material | Read | LQUA-LGNUM = LAGP-LGNUM AND LQUA-LGTYP = LAGP-LGTYP AND LQUA-LGPLA = LAGP-LGPLA | ECC + S/4 |
| T303 | Storage bin type definition | Read | T303-LGNUM = LAGP-LGNUM AND T303-LPTYP = LAGP-LPTYP | ECC + S/4 |
| T302 | Storage section definition | Read | 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 |
|---|---|---|---|---|
| S_LGNUM | Warehouse number | Range / multiple | LAGP-LGNUM | Yes |
| S_LGTYP | Storage type | Range / multiple | LAGP-LGTYP | No |
| S_LGBER | Storage section | Range / multiple | LAGP-LGBER | No |
| S_LPTYP | Bin type | Range / multiple | LAGP-LPTYP | No |
| P_MINPCT | Utilization threshold (%) | Single value | - | No |
| P_EMPTY | Empty bins only | Checkbox | - | No |
| P_BLOCK | Blocked bins only | Checkbox | - | No |

## Output columns

| Column | Source |
|---|---|
| Storage type | LAGP-LGTYP |
| Storage bin | LAGP-LGPLA |
| Section | LAGP-LGBER |
| Bin type | LAGP-LPTYP |
| Empty | LAGP-KZLER |
| Full | LAGP-KZVOL |
| Quants | LAGP-ANZQU |
| Load weight | LAGP-LGEWI |
| Max. weight | LAGP-MGEWI |
| Weight util. % | Calculated: LAGP-LGEWI ÷ LAGP-MGEWI × 100 |
| Total capacity | LAGP-LKAPV |
| Remaining capacity | LAGP-RKAPV |
| Capacity util. % | Calculated: (LAGP-LKAPV − LAGP-RKAPV) ÷ LAGP-LKAPV × 100 |
| Putaway block | LAGP-SKZUE |
| Removal block | LAGP-SKZUA |
| Block reason | LAGP-SPGRU |

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

## Authorization objects

- L_LGNUM: Display 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.

---
Let us build this report for your system: https://nekuhub.com/en/request-a-quote/?report=wm-storage-bin-utilization
