WM Report Custom development ALV report

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

  • LS03N Display Storage Bin. Shows the content of one bin; gives no violation list across a storage type.
  • LX03 Bin Status Report. Lists bin status and occupancy; does not compare it with the mixed storage rule.

Tables used

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

TableRoleJoinSystem
LQUAQuantsQuants in bins: material, batch, quantity, goods receipt date (driving table)—ECC + S/4
T331Storage Type ControlMixed storage setting of the storage typeT331-LGNUM = LQUA-LGNUM AND T331-LGTYP = LQUA-LGTYPECC + S/4
LAGPStorage BinsStorage section, number of quants and blocks of the binLAGP-LGNUM = LQUA-LGNUM AND LAGP-LGTYP = LQUA-LGTYP AND LAGP-LGPLA = LQUA-LGPLAECC + S/4
MAKTMaterial DescriptionsMaterial description in the logon languageMAKT-MATNR = LQUA-MATNR AND MAKT-SPRAS = SY-LANGUECC + S/4

Selection screen parameters

ParameterDescriptionTypeReference fieldRequiredExample
S_LGNUMWarehouse numberRange / multipleLQUA-LGNUMYes100
S_LGTYPStorage typeRange / multipleLQUA-LGTYPNo001
S_LGBERStorage sectionRange / multipleLAGP-LGBERNo001
S_MATNRMaterialRange / multipleLQUA-MATNRNoFG-5001
P_BATCHAlso check batch mixingCheckbox—NoX
P_ONLYVShow violating bins onlyCheckbox—NoX

Output columns

#ColumnSource
1Storage typeLQUA-LGTYP
2Mixed storage settingT331-MISCH
3Storage sectionLAGP-LGBER
4Storage binLQUA-LGPLA
5QuantsCalculated Number of LQUA records in the bin
6MaterialsCalculated Number of distinct LQUA-MATNR values in the bin
7BatchesCalculated Number of distinct LQUA-CHARG values in the bin
8QuantLQUA-LQNUM
9MaterialLQUA-MATNR
10DescriptionMAKT-MAKTX
11BatchLQUA-CHARG
12Total stockLQUA-GESME
13UnitLQUA-MEINS
14GR dateLQUA-WDATU
15ViolationCalculated By the rule: more than one quant, more than one material or more than one batch

Sample output

Storage typeMixed storage settingStorage sectionStorage binQuantsMaterialsBatchesQuantMaterialDescriptionBatchTotal stockUnitGR dateViolation
00100101-04-032220000081544FG-5001Packed product AB26-041248CS10/21/2026More than one material
00100101-04-032220000082107FG-5003Packed product CB26-049812CS11/05/2026More than one material
003A00203-12-012120000080931RM-2040Steel sheet 2 mmS26-0091350KG09/30/2026More than one batch
003A00203-12-012120000082215RM-2040Steel sheet 2 mmS26-0117120KG11/08/2026More than one batch
A view built with fictional sample data; not real system data.

How does the report work?

  1. 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.
  2. 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.
  3. Bins whose counts break the rule are flagged as violations; with “Also check batch mixing” selected, batch mixing is reported as well.
  4. The storage section and block indicators of violating bins come from LAGP, and the material description from MAKT.
  5. 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

WM Package Custom

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 …

4 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

WM Report Custom ALV report

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 …

LAGP · LQUA · T303 · T302

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: Bins With Mixed Stock Not Allowed by the Storage Type Report