WM Report Custom development ALV report

ABC Slotting Analysis by Pick Frequency Report

Short answer: A custom ALV report that counts the confirmed picking transfer order items of a period per material, assigns each material an A, B or C class by pick frequency and compares that class with the material's current storage section and bin sort sequence. Fast movers stored in remote sections are listed with a relocation suggestion.

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

Why is the standard not enough?

LE-WM has no standard slotting analysis that compares pick frequency with the storage bin. LT22 and LT23 list transfer orders but do not calculate pick counts and an ABC class per material; LX02 shows stock but knows nothing about velocity. Teams do this analysis in Excel from exported lists, and the result is refreshed only every few months.

Who uses it? Warehouse managers, logistics process engineers and LE-WM consultants.

Closest standard alternatives

  • LT22 Transfer Orders by Storage Type. Lists transfer orders by storage type; no pick count per material and no ABC class.
  • LX02 Stock List. Shows warehouse stock per bin; gives no velocity and no relocation suggestion.

Tables used

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

TableRoleJoinSystem
LTAPTransfer Order ItemConfirmed picking items: material, source storage type and bin, picked quantity, confirmation date (driving table)—ECC + S/4
LTAKTransfer Order HeaderTransfer order header: the movement type restricts the list to picking ordersLTAK-LGNUM = LTAP-LGNUM AND LTAK-TANUM = LTAP-TANUMECC + S/4
MLGTMaterial Data per Storage TypeThe material's fixed bin in the picking storage typeMLGT-MATNR = LTAP-MATNR AND MLGT-LGNUM = LTAP-LGNUM AND MLGT-LGTYP = LTAP-VLTYPECC + S/4
LAGPStorage BinsStorage section and sort field of the binLAGP-LGNUM = MLGT-LGNUM AND LAGP-LGTYP = MLGT-LGTYP AND LAGP-LGPLA = MLGT-LGPLAECC + S/4
MLGNMaterial Data per Warehouse NumberMaterial warehouse data: storage section indicatorMLGN-MATNR = LTAP-MATNR AND MLGN-LGNUM = LTAP-LGNUMECC + S/4
LQUAQuantsWithout a fixed bin, the material's current largest quantLQUA-LGNUM = LTAP-LGNUM AND LQUA-MATNR = LTAP-MATNR AND LQUA-LGTYP = LTAP-VLTYPECC + S/4

Selection screen parameters

ParameterDescriptionTypeReference fieldRequiredExample
S_LGNUMWarehouse numberRange / multipleLTAK-LGNUMYes100
S_QDATUConfirmation date rangeRange / multipleLTAP-QDATUYes01.08.2026 – 31.10.2026
S_BWLVSPicking movement typesRange / multipleLTAK-BWLVSYes601
S_VLTYPPicking storage typesRange / multipleLTAP-VLTYPNo010
S_MATNRMaterialRange / multipleLTAP-MATNRNoFG-5003
P_ALIMA class cumulative share (%)Single value—No80
P_BLIMB class cumulative share (%)Single value—No95
P_FASTFast-pick storage sectionSingle valueLAGP-LGBERNo001
P_MISMAOnly relocation suggestionsCheckbox—NoX

Output columns

#ColumnSource
1MaterialLTAP-MATNR
2DescriptionLTAP-MAKTX
3Pick linesCalculated Number of confirmed LTAP items in the period
4Picked qtyCalculated Sum of LTAP-VISTM
5UnitLTAP-MEINS
6Share (%)Calculated Pick lines ÷ all pick lines × 100
7Cumulative share (%)Calculated Running total of share in descending order
8ABC classCalculated Cumulative share ≤ A threshold → A, ≤ B threshold → B, else C
9Storage typeMLGT-LGTYP
10Current binMLGT-LGPLA
11Storage sectionLAGP-LGBER
12Bin sort fieldLAGP-SORLP
13Section indicatorMLGN-LGBKZ
14SuggestionCalculated 'Relocation suggested' when the class does not fit the section and sort position

Sample output

MaterialDescriptionPick linesPicked qtyUnitShare (%)Cumulative share (%)ABC classStorage typeCurrent binStorage sectionBin sort fieldSection indicatorSuggestion
FG-5003Packed product C1,84222,104PC18.4018.40A01004-12-030030412FSTRelocation suggested: move to fast section
FG-5010Packed product K1,2109,680PC12.1030.50A01001-02-010010102FSTOK
FG-6120Promotion set96240PC188.20B01002-01-020010201OK
FG-7031Spare lid1414PC0.1099.60C01001-01-040010101Relocation suggested: free the fast section
A view built with fictional sample data; not real system data.

How does the report work?

  1. Confirmed transfer order items (LTAP-PQUIT set) in the selected warehouse number and date range are read; from LTAK, only picking movement types (BWLVS from the selection screen, e.g. 601) are taken.
  2. Items whose source storage type is one of the selected picking storage types are counted per material: number of pick lines and total picked quantity (VISTM).
  3. Materials are sorted by pick lines in descending order; up to the A threshold of the cumulative share (default 80%) they are A, up to the B threshold (default 95%) B, the rest C.
  4. The material’s current location is taken from the fixed bin in MLGT, or, without a fixed bin, from the bin of the largest quant in LQUA; LAGP adds the storage section (LGBER) and the bin sort field (SORLP). MLGN gives the material’s storage section indicator (LGBKZ).
  5. If an A material is outside the fast-pick section or in the last quarter of the bin sort sequence, or a C material sits in the fast-pick section, the line is flagged ‘relocation suggested’.

Performance notes

Read LTAP by warehouse number and confirmation date (QDATU); in large warehouses it is faster to build a yearly analysis from monthly background jobs and keep the result. Do the pick count in the database with GROUP BY.

Features

  • ALV list (sort, filter, subtotals)
  • User-specific layout variants
  • Double-click drill-down to the document Double-clicking a material lists its picking transfer orders in the period.
  • Export to Excel
  • Runs as a background job The quarterly analysis can run as a monthly job.

Authorization objects

  • L_LGNUMDisplay authorization by warehouse number
  • M_MATE_LGNAuthorization to display the material's warehouse number data

Frequently asked questions

Is the ABC class based on quantity or on line count?

By default it uses the number of pick lines, because the picker's walking effort depends on line count. A quantity-based option can be added to the selection screen.

Does the report relocate materials itself?

No. The report gives suggestions; the fixed bin change is made in the material master (MLGT) and the stock is moved with a transfer order. These steps can be added as a separate program.

How does it work in storage types without fixed bins?

Without a fixed bin, the bin of the material's largest quant in that storage type is taken as its current location. In warehouses with mixed storage, the suggestion is given at storage section level.

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

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

WM Report Custom ALV report

Warehouse Picker Productivity Report

A custom ALV report that groups confirmed transfer order items by confirming user, day and source storage type, and calculates items confirmed per …

LTAP · LTAK · T333 · T301

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: ABC Slotting Analysis by Pick Frequency Report