Bins With Mixed Stock Not Allowed by the Storage Type Report
Short answer: A custom ALV report that lists, across whole storage types, bins holding more than one material, batch or quant against the storage type's mixed storage setting. The quants in every violating bin are shown with goods receipt date and quantity, so it is clear at once which stock has to be moved.
- Estimated effort
- S · 3–5 working days
- System
- ECC and S/4HANA
- Tables
- 4
- Scope
- Global
- Built by
- NeKuDos Teknoloji
- Last updated
Why is the standard not enough?
LS03N shows one bin at a time; LX03 gives bin status but does not compare it with the mixed storage rule. Violations created after the mixed storage setting is tightened, after manual transfer orders or after stock loads are noticed only when the wrong product is picked.
Who uses it? Warehouse supervisors, inventory controllers and consultants responsible for WM configuration.
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 bins: material, batch, quantity, goods receipt date (driving table) | — | ECC + S/4 |
| T331Storage Type Control | Mixed storage setting of the storage type | T331-LGNUM = LQUA-LGNUM AND T331-LGTYP = LQUA-LGTYP | ECC + S/4 |
| LAGPStorage Bins | Storage section, number of quants and blocks of the bin | LAGP-LGNUM = LQUA-LGNUM AND LAGP-LGTYP = LQUA-LGTYP AND LAGP-LGPLA = LQUA-LGPLA | ECC + S/4 |
| MAKTMaterial Descriptions | Material description in the logon language | 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 | Storage type | Range / multiple | LQUA-LGTYP | No | 001 |
| S_LGBER | Storage section | Range / multiple | LAGP-LGBER | No | 001 |
| S_MATNR | Material | Range / multiple | LQUA-MATNR | No | FG-5001 |
| P_BATCH | Also check batch mixing | Checkbox | — | No | X |
| P_ONLYV | Show violating bins only | Checkbox | — | No | X |
Output columns
| # | Column | Source |
|---|---|---|
| 1 | Storage type | LQUA-LGTYP |
| 2 | Mixed storage setting | T331-MISCH |
| 3 | Storage section | LAGP-LGBER |
| 4 | Storage bin | LQUA-LGPLA |
| 5 | Quants | Calculated Number of LQUA records in the bin |
| 6 | Materials | Calculated Number of distinct LQUA-MATNR values in the bin |
| 7 | Batches | Calculated Number of distinct LQUA-CHARG values in the bin |
| 8 | Quant | LQUA-LQNUM |
| 9 | Material | LQUA-MATNR |
| 10 | Description | MAKT-MAKTX |
| 11 | Batch | LQUA-CHARG |
| 12 | Total stock | LQUA-GESME |
| 13 | Unit | LQUA-MEINS |
| 14 | GR date | LQUA-WDATU |
| 15 | Violation | Calculated By the rule: more than one quant, more than one material or more than one batch |
Sample output
| Storage type | Mixed storage setting | Storage section | Storage bin | Quants | Materials | Batches | Quant | Material | Description | Batch | Total stock | Unit | GR date | Violation |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 001 | 001 | 01-04-03 | 2 | 2 | 2 | 0000081544 | FG-5001 | Packed product A | B26-0412 | 48 | CS | 10/21/2026 | More than one material | |
| 001 | 001 | 01-04-03 | 2 | 2 | 2 | 0000082107 | FG-5003 | Packed product C | B26-0498 | 12 | CS | 11/05/2026 | More than one material | |
| 003 | A | 002 | 03-12-01 | 2 | 1 | 2 | 0000080931 | RM-2040 | Steel sheet 2 mm | S26-0091 | 350 | KG | 09/30/2026 | More than one batch |
| 003 | A | 002 | 03-12-01 | 2 | 1 | 2 | 0000082215 | RM-2040 | Steel sheet 2 mm | S26-0117 | 120 | KG | 11/08/2026 | More than one batch |
How does the report work?
- The mixed storage setting (MISCH) is read from T331 for the selected warehouse number and storage types and translated into the rule allowed per bin: one quant, one material (several batches allowed) or freely mixed.
- All quants in these storage types are read from LQUA, and the number of quants, materials and batches is counted per warehouse number + storage type + bin.
- Bins whose counts break the rule are flagged as violations; with “Also check batch mixing” selected, batch mixing is reported as well.
- The storage section and block indicators of violating bins come from LAGP, and the material description from MAKT.
- The quants of each violating bin are listed on separate lines, with the first quant to enter the bin at the top.
Performance notes
Read LQUA by warehouse number and storage type and do the counting on the database with GROUP BY; fetch quant details only for violating bins in a second query. The report finishes in seconds even in large warehouses.
Features
- ALV list (sort, filter, subtotals)
- User-specific layout variants
- Double-click drill-down to the document Double-clicking the bin opens LS03N; double-clicking the quant opens LS23.
- Export to Excel
- Runs as a background job
Authorization objects
- L_LGNUMDisplay authorization by warehouse number and storage type
Frequently asked questions
Doesn't the system already prevent mixed storage?
It does for new putaways. But when the setting is changed later, existing bins are not checked, and initial stock loads and some manual movements can leave violations. The report shows this accumulated state.
How is a violating bin fixed?
The list is the starting point for a transfer order that moves the newest quant to another bin. If needed, a button can be added that creates a move transfer order, like LT01, for the selected quants; this increases the effort range.
Does it work for storage types with storage unit management?
Yes. The storage unit number of the quants (LQUA-LENUM) can be shown as well; batch mixing on a pallet and batch mixing in a bin are evaluated separately.
Packages that include this solution
Warehouse Storage Discipline and Slotting Pack
A four-component pack that shows whether stock in the warehouse is stored in the right place and moved in the right order: FIFO and FEFO picking …
Related reports
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 …
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 …
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.