WM Report Custom development ALV report

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

  • LX27 Stock Levels by Shelf Life Expiration Date. Lists quants by expiration date; does not compare completed picks with older stock.
  • LT23 Transfer Orders by Number. Shows transfer orders and source bins; does not show the older quant in the same storage type.

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, source quant, goods receipt and expiration date (driving table)—ECC + S/4
LTAKTransfer Order HeaderTransfer order header: WM movement type and creation dateLTAK-LGNUM = LTAP-LGNUM AND LTAK-TANUM = LTAP-TANUMECC + S/4
LQUAQuantsOlder quants still sitting in the same storage typeLQUA-LGNUM = LTAP-LGNUM AND LQUA-LGTYP = LTAP-VLTYP AND LQUA-MATNR = LTAP-MATNR AND LQUA-WERKS = LTAP-WERKS AND LQUA-BESTQ = LTAP-BESTQECC + S/4
LAGPStorage BinsRemoval block on the bin of the older quantLAGP-LGNUM = LQUA-LGNUM AND LAGP-LGTYP = LQUA-LGTYP AND LAGP-LGPLA = LQUA-LGPLAECC + S/4
T331Storage Type ControlRemoval strategy of the storage typeT331-LGNUM = LTAP-LGNUM AND T331-LGTYP = LTAP-VLTYPECC + S/4
MAKTMaterial DescriptionsMaterial description in the logon languageMAKT-MATNR = LTAP-MATNR AND MAKT-SPRAS = SY-LANGUECC + S/4

Selection screen parameters

ParameterDescriptionTypeReference fieldRequiredExample
S_LGNUMWarehouse numberRange / multipleLTAK-LGNUMYes100
S_LGTYPSource storage typeRange / multipleLTAP-VLTYPNo001
S_BWLVSWM movement typeRange / multipleLTAK-BWLVSNo601
S_QDATUConfirmation dateRange / multipleLTAP-QDATUYes01.11.2026 – 16.11.2026
S_MATNRMaterialRange / multipleLTAP-MATNRNoFG-5001
P_TOLDTolerance (days)Single value—No2
R_FIFOBy goods receipt date (FIFO)Radio button—NoX
R_FEFOBy shelf-life expiration date (FEFO)Radio button—No—
P_STRATOnly FIFO/FEFO storage typesCheckbox—NoX

Output columns

#ColumnSource
1Storage typeLTAP-VLTYP
2Removal strategyT331-STAUS
3Transfer orderLTAP-TANUM
4ItemLTAP-TAPOS
5MaterialLTAP-MATNR
6DescriptionMAKT-MAKTX
7Picked binLTAP-VLPLA
8Picked quant GR dateLTAP-WDATU
9Picked qtyLTAP-VISTA
10Skipped binLQUA-LGPLA
11Skipped quant GR dateLQUA-WDATU
12Skipped quant qtyLQUA-VERME
13Days olderCalculated LTAP-WDATU − LQUA-WDATU (in FEFO mode LTAP-VFDAT − LQUA-VFDAT)
14Confirmed byLTAP-QNAME
15Confirmed onLTAP-QDATU

Sample output

Storage typeRemoval strategyTransfer orderItemMaterialDescriptionPicked binPicked quant GR datePicked qtySkipped binSkipped quant GR dateSkipped quant qtyDays olderConfirmed byConfirmed on
001F00004182300001FG-5001Packed product A01-03-0210/30/20262401-07-0110/12/20263618DEPO_AYILMAZ11/14/2026
001F00004183770002FG-5120Canned tomato 400 g01-11-0411/03/202612001-02-0610/26/2026808DEPO_KSAHIN11/15/2026
002H00004184020001RM-3105Solvent-based paint02-01-0109/18/20261002-04-0309/20/20261441DEPO_AYILMAZ11/15/2026
A view built with fictional sample data; not real system data.

How does the report work?

  1. Transfer order headers are read from LTAK for the warehouse number, WM movement types and date range on the selection screen.
  2. 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.
  3. The removal strategy of the source storage type is read from T331-STAUS; with “Only FIFO/FEFO storage types” selected, other types are skipped.
  4. 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).
  5. 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.
  6. 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

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

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: FIFO and FEFO Picking Violations Report (Picks That Skipped Older Stock)