# ABC Slotting Analysis by Pick Frequency Report

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

- Type: Report, Custom development, ALV report
- Module: WM
- Estimated effort: M (4–6 working days)
- Last updated: 2026-11-17
- URL: https://nekuhub.com/en/reports/abc-slotting-analysis-by-pick-frequency-report/


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

### Closest standard alternatives

- LT22: Lists transfer orders by storage type; no pick count per material and no ABC class.
- LX02: Shows warehouse stock per bin; gives no velocity and no relocation suggestion.

## Tables used

| Table | Role | Access | Join | System |
|---|---|---|---|---|
| LTAP | Confirmed picking items: material, source storage type and bin, picked quantity, confirmation date (driving table) | Read | - | ECC + S/4 |
| LTAK | Transfer order header: the movement type restricts the list to picking orders | Read | LTAK-LGNUM = LTAP-LGNUM AND LTAK-TANUM = LTAP-TANUM | ECC + S/4 |
| MLGT | The material's fixed bin in the picking storage type | Read | MLGT-MATNR = LTAP-MATNR AND MLGT-LGNUM = LTAP-LGNUM AND MLGT-LGTYP = LTAP-VLTYP | ECC + S/4 |
| LAGP | Storage section and sort field of the bin | Read | LAGP-LGNUM = MLGT-LGNUM AND LAGP-LGTYP = MLGT-LGTYP AND LAGP-LGPLA = MLGT-LGPLA | ECC + S/4 |
| MLGN | Material warehouse data: storage section indicator | Read | MLGN-MATNR = LTAP-MATNR AND MLGN-LGNUM = LTAP-LGNUM | ECC + S/4 |
| LQUA | Without a fixed bin, the material's current largest quant | Read | 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 |
|---|---|---|---|---|
| S_LGNUM | Warehouse number | Range / multiple | LTAK-LGNUM | Yes |
| S_QDATU | Confirmation date range | Range / multiple | LTAP-QDATU | Yes |
| S_BWLVS | Picking movement types | Range / multiple | LTAK-BWLVS | Yes |
| S_VLTYP | Picking storage types | Range / multiple | LTAP-VLTYP | No |
| S_MATNR | Material | Range / multiple | LTAP-MATNR | No |
| P_ALIM | A class cumulative share (%) | Single value | - | No |
| P_BLIM | B class cumulative share (%) | Single value | - | No |
| P_FAST | Fast-pick storage section | Single value | LAGP-LGBER | No |
| P_MISMA | Only relocation suggestions | Checkbox | - | No |

## Output columns

| Column | Source |
|---|---|
| Material | LTAP-MATNR |
| Description | LTAP-MAKTX |
| Pick lines | Calculated: Number of confirmed LTAP items in the period |
| Picked qty | Calculated: Sum of LTAP-VISTM |
| Unit | LTAP-MEINS |
| Share (%) | Calculated: Pick lines ÷ all pick lines × 100 |
| Cumulative share (%) | Calculated: Running total of share in descending order |
| ABC class | Calculated: Cumulative share ≤ A threshold → A, ≤ B threshold → B, else C |
| Storage type | MLGT-LGTYP |
| Current bin | MLGT-LGPLA |
| Storage section | LAGP-LGBER |
| Bin sort field | LAGP-SORLP |
| Section indicator | MLGN-LGBKZ |
| Suggestion | Calculated: 'Relocation suggested' when the class does not fit the section and sort position |

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

## Authorization objects

- L_LGNUM: Display authorization by warehouse number
- M_MATE_LGN: Authorization 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.

---
Let us build this report for your system: https://nekuhub.com/en/request-a-quote/?report=wm-abc-slotting-pick-frequency
