FIFO and FEFO Picking Violations Report (Picks That Skipped Older Stock)
Short answer: A custom ALV report that lists confirmed picking transfer order items taken from a newer quant while an available quant with an older goods receipt date (or an earlier shelf-life expiration date) was still in the same storage type. The skipped quant's bin, date and how many days older it is are shown together with the user who confirmed the pick.
- Estimated effort
- M · 5–8 working days
- System
- ECC and S/4HANA
- Tables
- 6
- Scope
- Global
- Built by
- NeKuDos Teknoloji
- Last updated
Why is the standard not enough?
LX27 lists quants by shelf-life expiration date and LT23 shows transfer orders by number; neither compares a completed pick with older stock that was waiting in the storage type at that time. When manual transfer orders or manually changed source bins bypass the removal strategy, it is noticed only when expired stock or count differences turn up.
Who uses it? Warehouse managers, quality assurance teams in food, pharma and chemical warehouses, warehouse process owners and internal audit.
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, source quant, goods receipt and expiration date (driving table) | — | ECC + S/4 |
| LTAKTransfer Order Header | Transfer order header: WM movement type and creation date | LTAK-LGNUM = LTAP-LGNUM AND LTAK-TANUM = LTAP-TANUM | ECC + S/4 |
| LQUAQuants | Older quants still sitting in the same storage type | LQUA-LGNUM = LTAP-LGNUM AND LQUA-LGTYP = LTAP-VLTYP AND LQUA-MATNR = LTAP-MATNR AND LQUA-WERKS = LTAP-WERKS AND LQUA-BESTQ = LTAP-BESTQ | ECC + S/4 |
| LAGPStorage Bins | Removal block on the bin of the older quant | LAGP-LGNUM = LQUA-LGNUM AND LAGP-LGTYP = LQUA-LGTYP AND LAGP-LGPLA = LQUA-LGPLA | ECC + S/4 |
| T331Storage Type Control | Removal strategy of the storage type | T331-LGNUM = LTAP-LGNUM AND T331-LGTYP = LTAP-VLTYP | ECC + S/4 |
| MAKTMaterial Descriptions | Material description in the logon language | MAKT-MATNR = LTAP-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 | LTAK-LGNUM | Yes | 100 |
| S_LGTYP | Source storage type | Range / multiple | LTAP-VLTYP | No | 001 |
| S_BWLVS | WM movement type | Range / multiple | LTAK-BWLVS | No | 601 |
| S_QDATU | Confirmation date | Range / multiple | LTAP-QDATU | Yes | 01.11.2026 – 16.11.2026 |
| S_MATNR | Material | Range / multiple | LTAP-MATNR | No | FG-5001 |
| P_TOLD | Tolerance (days) | Single value | — | No | 2 |
| R_FIFO | By goods receipt date (FIFO) | Radio button | — | No | X |
| R_FEFO | By shelf-life expiration date (FEFO) | Radio button | — | No | — |
| P_STRAT | Only FIFO/FEFO storage types | Checkbox | — | No | X |
Output columns
| # | Column | Source |
|---|---|---|
| 1 | Storage type | LTAP-VLTYP |
| 2 | Removal strategy | T331-STAUS |
| 3 | Transfer order | LTAP-TANUM |
| 4 | Item | LTAP-TAPOS |
| 5 | Material | LTAP-MATNR |
| 6 | Description | MAKT-MAKTX |
| 7 | Picked bin | LTAP-VLPLA |
| 8 | Picked quant GR date | LTAP-WDATU |
| 9 | Picked qty | LTAP-VISTA |
| 10 | Skipped bin | LQUA-LGPLA |
| 11 | Skipped quant GR date | LQUA-WDATU |
| 12 | Skipped quant qty | LQUA-VERME |
| 13 | Days older | Calculated LTAP-WDATU − LQUA-WDATU (in FEFO mode LTAP-VFDAT − LQUA-VFDAT) |
| 14 | Confirmed by | LTAP-QNAME |
| 15 | Confirmed on | LTAP-QDATU |
Sample output
| Storage type | Removal strategy | Transfer order | Item | Material | Description | Picked bin | Picked quant GR date | Picked qty | Skipped bin | Skipped quant GR date | Skipped quant qty | Days older | Confirmed by | Confirmed on |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 001 | F | 0000418230 | 0001 | FG-5001 | Packed product A | 01-03-02 | 10/30/2026 | 24 | 01-07-01 | 10/12/2026 | 36 | 18 | DEPO_AYILMAZ | 11/14/2026 |
| 001 | F | 0000418377 | 0002 | FG-5120 | Canned tomato 400 g | 01-11-04 | 11/03/2026 | 120 | 01-02-06 | 10/26/2026 | 80 | 8 | DEPO_KSAHIN | 11/15/2026 |
| 002 | H | 0000418402 | 0001 | RM-3105 | Solvent-based paint | 02-01-01 | 09/18/2026 | 10 | 02-04-03 | 09/20/2026 | 14 | 41 | DEPO_AYILMAZ | 11/15/2026 |
How does the report work?
- Transfer order headers are read from LTAK for the warehouse number, WM movement types and date range on the selection screen.
- Confirmed items (PQUIT = X) are taken from LTAP: source storage type and bin (VLTYP, VLPLA), source quant (VLQNR), material, batch, stock category, goods receipt date (WDATU) and shelf-life expiration date (VFDAT) of the picked quant, confirming user and confirmation date.
- The removal strategy of the source storage type is read from T331-STAUS; with “Only FIFO/FEFO storage types” selected, other types are skipped.
- For each item, LQUA is searched for quants with the same warehouse number, storage type, material, plant, stock category and special stock, available quantity (VERME) above zero and no removal block (LQUA-SKZUA and LAGP-SKZUA blank).
- In FIFO mode the oldest quant whose goods receipt date is older than the picked quant’s date by more than the tolerance is matched as a violation; in FEFO mode a quant with an earlier expiration date is matched.
- The material description is added from MAKT; the number of days skipped and the violation type are calculated.
Performance notes
Do not search LQUA item by item: read all quants of the materials involved for the selected storage types in one query and keep them in a sorted internal table keyed by material + storage type. Keep the date range on LTAK mandatory; in busy warehouses run the report as a daily background job.
Features
- ALV list (sort, filter, subtotals)
- User-specific layout variants
- Double-click drill-down to the document Double-clicking the transfer order displays it in LT21; double-clicking the skipped bin opens LS03N.
- Export to Excel
- Runs as a background job Can run every morning for the previous day's picks.
- Send the result by email The violation list can be emailed to the shift supervisor.
Authorization objects
- L_LGNUMDisplay authorization by warehouse number and storage type
- L_BWLVSAuthorization by WM movement type
Frequently asked questions
How does the report know the stock situation in the past?
If the skipped quant is still in the storage type today and its goods receipt date is older than the picked quant's, it was also there at the time of the pick. Older quants removed after the pick are not visible this way, so the report should run regularly over short date ranges.
Do blocked or quality stock count as violations?
No. Quants in bins with a removal block and quants in a different stock category (quality, blocked) are not compared; only stock that could have been picked creates a violation.
What happens after moving to S/4HANA or EWM?
The same check can be built in EWM on warehouse tasks (/SCWM/ORDIM_C) and quants (/SCWM/AQUA). The logic and selection screen stay, the tables read change; this is planned as a separate effort item.
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
Transfer Orders Confirmed with Differences and Difference Value Report
A custom ALV report that lists transfer order items confirmed with a quantity different from the requested quantity during picking or putaway, with …
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.