# 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 the difference quantity, difference value, confirming user and source bin. Repeated shortages per bin and per user become visible before inventory differences are posted.

- Type: Report, Custom development, ALV report
- Module: WM
- Estimated effort: S (2–4 working days)
- Last updated: 2026-11-17
- URL: https://nekuhub.com/en/reports/transfer-orders-confirmed-with-differences-value-report/


## Why is the standard not enough?

LT23 shows transfer orders and items with differences can be filtered, but it does not multiply the difference quantity by the material value and does not aggregate by user or bin. Differences go to interim storage 999 and are cleared in bulk with LI20; at that point their origin is lost. The custom report shows each difference at its source, with its value and the person responsible.

### Closest standard alternatives

- LT23: Lists transfer orders and can show differences; no difference value and no totals per user or bin.
- LI20: Clears differences in interim storage 999 in bulk; does not show which transfer order caused them.

## Tables used

| Table | Role | Access | Join | System |
|---|---|---|---|---|
| LTAP | Transfer order item: requested, actual and difference quantity, difference indicator, confirming user and time (driving table) | Read | - | ECC + S/4 |
| LTAK | Movement type and reference document (delivery, purchase order) | Read | LTAK-LGNUM = LTAP-LGNUM AND LTAK-TANUM = LTAP-TANUM | ECC + S/4 |
| MBEW | Moving average or standard price for the difference value | Read | MBEW-MATNR = LTAP-MATNR AND MBEW-BWKEY = LTAP-WERKS AND MBEW-BWTAR = '' | ECC + S/4 |
| LAGP | Storage section and last count date of the source bin | Read | LAGP-LGNUM = LTAP-LGNUM AND LAGP-LGTYP = LTAP-VLTYP AND LAGP-LGPLA = LTAP-VLPLA | ECC + S/4 |

## Selection screen parameters

| Parameter | Description | Type | Reference field | Required |
|---|---|---|---|---|
| S_LGNUM | Warehouse number | Range / multiple | LTAP-LGNUM | Yes |
| S_QDATU | Confirmation date | Range / multiple | LTAP-QDATU | Yes |
| S_QNAME | Confirmed by | Range / multiple | LTAP-QNAME | No |
| S_VLTYP | Source storage type | Range / multiple | LTAP-VLTYP | No |
| S_MATNR | Material | Range / multiple | LTAP-MATNR | No |
| S_BWLVS | WM movement type | Range / multiple | LTAK-BWLVS | No |
| P_MINVAL | Minimum difference value | Single value | - | No |

## Output columns

| Column | Source |
|---|---|
| Transfer order | LTAP-TANUM |
| Item | LTAP-TAPOS |
| Movement type | LTAK-BWLVS |
| Material | LTAP-MATNR |
| Description | LTAP-MAKTX |
| Source type | LTAP-VLTYP |
| Source bin | LTAP-VLPLA |
| Target qty | LTAP-VSOLM |
| Actual qty | LTAP-VISTM |
| Difference qty | LTAP-VDIFM |
| Unit | LTAP-MEINS |
| Difference value | Calculated: LTAP-VDIFM × (MBEW-VERPR or MBEW-STPRS) ÷ MBEW-PEINH |
| Confirmed by | LTAP-QNAME |
| Confirmed on | LTAP-QDATU |
| Reference doc. | LTAK-BENUM |

## How does the report work?

1. LTAP items in the selected warehouse number and confirmation date range with the difference indicator (KZDIF) set or a source difference quantity (VDIFM) other than zero are read.
2. LTAK adds the movement type, requirement type and number (e.g. the delivery).
3. Difference value = VDIFM × unit price; the unit price comes from MBEW according to the price control (VERPR for V, STPRS for S) divided by the price unit (PEINH). The plant is used as the valuation area.
4. Lines whose absolute difference value is below the threshold on the selection screen are removed.
5. The result is shown in ALV with subtotals per user (QNAME) and source bin; a second view gives the number of difference lines and total value per user.

## Authorization objects

- L_LGNUM: Display authorization by warehouse number
- M_MATE_WRK: Authorization to display the material price in the plant for the difference value

## Frequently asked questions

### Are both picking and putaway differences included?

Yes. The source difference quantity (VDIFM) holds shortages in picking, the destination difference quantity (NDIFM) holds putaway differences. The selection screen lets you choose which side to report.

### Which price is used for the difference value?

The material's valuation price in the plant: the moving average price for price control V, the standard price for S. With split valuation, the price of the relevant valuation type should be used.

### Is this report suitable for measuring a user's performance?

The report shows in whose confirmation the difference arose; whether the cause is bin stock, master data or a physical error must be investigated separately. Using user data must follow company policy and any agreement with employee representatives.

---
Let us build this report for your system: https://nekuhub.com/en/request-a-quote/?report=wm-transfer-order-confirmation-differences
