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
Tables used
The tables the report reads and their join fields. ECC and S/4HANA differences are marked separately.
| Table | Role | Join | System |
|---|---|---|---|
| LTAPTransfer Order Item | Confirmed picking items: material, source storage type and bin, picked quantity, confirmation date (driving table) | — | ECC + S/4 |
| LTAKTransfer Order Header | Transfer order header: the movement type restricts the list to picking orders | LTAK-LGNUM = LTAP-LGNUM AND LTAK-TANUM = LTAP-TANUM | ECC + S/4 |
| MLGTMaterial Data per Storage Type | The material's fixed bin in the picking storage type | MLGT-MATNR = LTAP-MATNR AND MLGT-LGNUM = LTAP-LGNUM AND MLGT-LGTYP = LTAP-VLTYP | ECC + S/4 |
| LAGPStorage Bins | Storage section and sort field of the bin | LAGP-LGNUM = MLGT-LGNUM AND LAGP-LGTYP = MLGT-LGTYP AND LAGP-LGPLA = MLGT-LGPLA | ECC + S/4 |
| MLGNMaterial Data per Warehouse Number | Material warehouse data: storage section indicator | MLGN-MATNR = LTAP-MATNR AND MLGN-LGNUM = LTAP-LGNUM | ECC + S/4 |
| LQUAQuants | Without a fixed bin, the material's current largest quant | LQUA-LGNUM = LTAP-LGNUM AND LQUA-MATNR = LTAP-MATNR AND LQUA-LGTYP = LTAP-VLTYP | ECC + S/4 |
Selection screen parameters
| Parameter | Description | Type | Reference field | Required | Example |
|---|---|---|---|---|---|
| S_LGNUM | Warehouse number | Range / multiple | LTAK-LGNUM | Yes | 100 |
| S_QDATU | Confirmation date range | Range / multiple | LTAP-QDATU | Yes | 01.08.2026 – 31.10.2026 |
| S_BWLVS | Picking movement types | Range / multiple | LTAK-BWLVS | Yes | 601 |
| S_VLTYP | Picking storage types | Range / multiple | LTAP-VLTYP | No | 010 |
| S_MATNR | Material | Range / multiple | LTAP-MATNR | No | FG-5003 |
| P_ALIM | A class cumulative share (%) | Single value | — | No | 80 |
| P_BLIM | B class cumulative share (%) | Single value | — | No | 95 |
| P_FAST | Fast-pick storage section | Single value | LAGP-LGBER | No | 001 |
| P_MISMA | Only relocation suggestions | Checkbox | — | No | X |
Output columns
| # | Column | Source |
|---|---|---|
| 1 | Material | LTAP-MATNR |
| 2 | Description | LTAP-MAKTX |
| 3 | Pick lines | Calculated Number of confirmed LTAP items in the period |
| 4 | Picked qty | Calculated Sum of LTAP-VISTM |
| 5 | Unit | LTAP-MEINS |
| 6 | Share (%) | Calculated Pick lines ÷ all pick lines × 100 |
| 7 | Cumulative share (%) | Calculated Running total of share in descending order |
| 8 | ABC class | Calculated Cumulative share ≤ A threshold → A, ≤ B threshold → B, else C |
| 9 | Storage type | MLGT-LGTYP |
| 10 | Current bin | MLGT-LGPLA |
| 11 | Storage section | LAGP-LGBER |
| 12 | Bin sort field | LAGP-SORLP |
| 13 | Section indicator | MLGN-LGBKZ |
| 14 | Suggestion | Calculated 'Relocation suggested' when the class does not fit the section and sort position |
Sample output
| Material | Description | Pick lines | Picked qty | Unit | Share (%) | Cumulative share (%) | ABC class | Storage type | Current bin | Storage section | Bin sort field | Section indicator | Suggestion |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| FG-5003 | Packed product C | 1,842 | 22,104 | PC | 18.40 | 18.40 | A | 010 | 04-12-03 | 003 | 0412 | FST | Relocation suggested: move to fast section |
| FG-5010 | Packed product K | 1,210 | 9,680 | PC | 12.10 | 30.50 | A | 010 | 01-02-01 | 001 | 0102 | FST | OK |
| FG-6120 | Promotion set | 96 | 240 | PC | 1 | 88.20 | B | 010 | 02-01-02 | 001 | 0201 | OK | |
| FG-7031 | Spare lid | 14 | 14 | PC | 0.10 | 99.60 | C | 010 | 01-01-04 | 001 | 0101 | Relocation suggested: free the fast section |
How does the report work?
- 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.
- 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).
- 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.
- 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).
- 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
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
Automatic Replenishment Transfer Order Job for Fixed Picking Bins
A custom background job that evaluates stock in fixed picking bins together with the pending pick demand of open deliveries, and automatically creates …
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 …
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 …
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.