Transfer Orders Confirmed with Differences and Difference Value Report
Short answer: 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.
- Estimated effort
- S · 2–4 working days
- System
- ECC and S/4HANA
- Tables
- 4
- Scope
- Global
- Built by
- NeKuDos Teknoloji
- Last updated
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.
Who uses it? Warehouse managers, inventory control and internal audit teams.
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 | Transfer order item: requested, actual and difference quantity, difference indicator, confirming user and time (driving table) | — | ECC + S/4 |
| LTAKTransfer Order Header | Movement type and reference document (delivery, purchase order) | LTAK-LGNUM = LTAP-LGNUM AND LTAK-TANUM = LTAP-TANUM | ECC + S/4 |
| MBEWMaterial Valuation | Moving average or standard price for the difference value | MBEW-MATNR = LTAP-MATNR AND MBEW-BWKEY = LTAP-WERKS AND MBEW-BWTAR = '' | ECC + S/4 |
| LAGPStorage Bins | Storage section and last count date of the source bin | LAGP-LGNUM = LTAP-LGNUM AND LAGP-LGTYP = LTAP-VLTYP AND LAGP-LGPLA = LTAP-VLPLA | ECC + S/4 |
S/4HANA notes
- MBEW: In S/4HANA the Material Ledger is mandatory and valuation data is read through a compatibility view. Prices remain readable; validate value calculations against the currency and valuation view in use.
Selection screen parameters
| Parameter | Description | Type | Reference field | Required | Example |
|---|---|---|---|---|---|
| S_LGNUM | Warehouse number | Range / multiple | LTAP-LGNUM | Yes | 100 |
| S_QDATU | Confirmation date | Range / multiple | LTAP-QDATU | Yes | 01.11.2026 – 17.11.2026 |
| S_QNAME | Confirmed by | Range / multiple | LTAP-QNAME | No | DEPO_TOP3 |
| S_VLTYP | Source storage type | Range / multiple | LTAP-VLTYP | No | 010 |
| S_MATNR | Material | Range / multiple | LTAP-MATNR | No | FG-5003 |
| S_BWLVS | WM movement type | Range / multiple | LTAK-BWLVS | No | 601 |
| P_MINVAL | Minimum difference value | Single value | — | No | 100 |
Output columns
| # | Column | Source |
|---|---|---|
| 1 | Transfer order | LTAP-TANUM |
| 2 | Item | LTAP-TAPOS |
| 3 | Movement type | LTAK-BWLVS |
| 4 | Material | LTAP-MATNR |
| 5 | Description | LTAP-MAKTX |
| 6 | Source type | LTAP-VLTYP |
| 7 | Source bin | LTAP-VLPLA |
| 8 | Target qty | LTAP-VSOLM |
| 9 | Actual qty | LTAP-VISTM |
| 10 | Difference qty | LTAP-VDIFM |
| 11 | Unit | LTAP-MEINS |
| 12 | Difference value | Calculated LTAP-VDIFM × (MBEW-VERPR or MBEW-STPRS) ÷ MBEW-PEINH |
| 13 | Confirmed by | LTAP-QNAME |
| 14 | Confirmed on | LTAP-QDATU |
| 15 | Reference doc. | LTAK-BENUM |
Sample output
| Transfer order | Item | Movement type | Material | Description | Source type | Source bin | Target qty | Actual qty | Difference qty | Unit | Difference value | Confirmed by | Confirmed on | Reference doc. |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 0000312045 | 0002 | 601 | FG-5003 | Packed product C | 010 | 04-12-03 | 24 | 20 | 4 | PC | 1,180 | DEPO_TOP3 | 11/11/2026 | 8000041277 |
| 0000312101 | 0001 | 601 | FG-5010 | Packed product K | 010 | 01-02-01 | 48 | 46 | 2 | PC | 236 | DEPO_TOP1 | 11/12/2026 | 8000041302 |
| 0000312188 | 0003 | 601 | FG-5003 | Packed product C | 010 | 04-12-03 | 12 | 9 | 3 | PC | 885 | DEPO_TOP3 | 11/14/2026 | 8000041355 |
| 0000312204 | 0001 | 101 | RM-2040 | Steel sheet 2 mm | 902 | 4500012398 | 800 | 790 | 10 | KG | 612 | DEPO_KAB2 | 11/15/2026 | 4500012398 |
How does the report work?
- 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.
- LTAK adds the movement type, requirement type and number (e.g. the delivery).
- 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.
- Lines whose absolute difference value is below the threshold on the selection screen are removed.
- 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.
Performance notes
Restrict LTAP by warehouse number and confirmation date; push the KZDIF filter to the database. Read MBEW once with the material/plant list.
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.
- Export to Excel
- Runs as a background job
- Send the result by email A weekly difference summary can be sent to the warehouse manager and internal audit.
Authorization objects
- L_LGNUMDisplay authorization by warehouse number
- M_MATE_WRKAuthorization 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.
Related reports
WM vs IM Stock Comparison Report
A custom ALV report that compares inventory management stock per storage location (MARD) with the total of warehouse management quants (LQUA) by …
Mass Transfer Order Confirmation Upload Program
A custom program that confirms hundreds of transfer order items in one run from picking results that come from handheld scanners, warehouse automation …
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.