# FIFO and FEFO Picking Violations Report (Picks That Skipped Older Stock)

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

- Type: Report, Custom development, ALV report
- Module: WM
- Estimated effort: M (5–8 working days)
- Last updated: 2026-11-17
- URL: https://nekuhub.com/en/reports/wm-fifo-picking-violation-report/


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

### Closest standard alternatives

- LX27: Lists quants by expiration date; does not compare completed picks with older stock.
- LT23: Shows transfer orders and source bins; does not show the older quant in the same storage type.

## Tables used

| Table | Role | Access | Join | System |
|---|---|---|---|---|
| LTAP | Confirmed picking items, source quant, goods receipt and expiration date (driving table) | Read | - | ECC + S/4 |
| LTAK | Transfer order header: WM movement type and creation date | Read | LTAK-LGNUM = LTAP-LGNUM AND LTAK-TANUM = LTAP-TANUM | ECC + S/4 |
| LQUA | Older quants still sitting in the same storage type | Read | 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 |
| LAGP | Removal block on the bin of the older quant | Read | LAGP-LGNUM = LQUA-LGNUM AND LAGP-LGTYP = LQUA-LGTYP AND LAGP-LGPLA = LQUA-LGPLA | ECC + S/4 |
| T331 | Removal strategy of the storage type | Read | T331-LGNUM = LTAP-LGNUM AND T331-LGTYP = LTAP-VLTYP | ECC + S/4 |
| MAKT | Material description in the logon language | Read | MAKT-MATNR = LTAP-MATNR AND MAKT-SPRAS = SY-LANGU | ECC + S/4 |

## Selection screen parameters

| Parameter | Description | Type | Reference field | Required |
|---|---|---|---|---|
| S_LGNUM | Warehouse number | Range / multiple | LTAK-LGNUM | Yes |
| S_LGTYP | Source storage type | Range / multiple | LTAP-VLTYP | No |
| S_BWLVS | WM movement type | Range / multiple | LTAK-BWLVS | No |
| S_QDATU | Confirmation date | Range / multiple | LTAP-QDATU | Yes |
| S_MATNR | Material | Range / multiple | LTAP-MATNR | No |
| P_TOLD | Tolerance (days) | Single value | - | No |
| R_FIFO | By goods receipt date (FIFO) | Radio button | - | No |
| R_FEFO | By shelf-life expiration date (FEFO) | Radio button | - | No |
| P_STRAT | Only FIFO/FEFO storage types | Checkbox | - | No |

## Output columns

| Column | Source |
|---|---|
| Storage type | LTAP-VLTYP |
| Removal strategy | T331-STAUS |
| Transfer order | LTAP-TANUM |
| Item | LTAP-TAPOS |
| Material | LTAP-MATNR |
| Description | MAKT-MAKTX |
| Picked bin | LTAP-VLPLA |
| Picked quant GR date | LTAP-WDATU |
| Picked qty | LTAP-VISTA |
| Skipped bin | LQUA-LGPLA |
| Skipped quant GR date | LQUA-WDATU |
| Skipped quant qty | LQUA-VERME |
| Days older | Calculated: LTAP-WDATU − LQUA-WDATU (in FEFO mode LTAP-VFDAT − LQUA-VFDAT) |
| Confirmed by | LTAP-QNAME |
| Confirmed on | LTAP-QDATU |

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

## Authorization objects

- L_LGNUM: Display authorization by warehouse number and storage type
- L_BWLVS: Authorization 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.

---
Let us build this report for your system: https://nekuhub.com/en/request-a-quote/?report=wm-fifo-picking-violations
