WM Report Custom development ALV report

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

  • LT23 Transfer Orders by Number. Lists transfer orders and can show differences; no difference value and no totals per user or bin.
  • LI20 Clear Inventory Differences in WM. Clears differences in interim storage 999 in bulk; does not show which transfer order caused them.

Tables used

The tables the report reads and their join fields. ECC and S/4HANA differences are marked separately.

TableRoleJoinSystem
LTAPTransfer Order ItemTransfer order item: requested, actual and difference quantity, difference indicator, confirming user and time (driving table)—ECC + S/4
LTAKTransfer Order HeaderMovement type and reference document (delivery, purchase order)LTAK-LGNUM = LTAP-LGNUM AND LTAK-TANUM = LTAP-TANUMECC + S/4
MBEWMaterial ValuationMoving average or standard price for the difference valueMBEW-MATNR = LTAP-MATNR AND MBEW-BWKEY = LTAP-WERKS AND MBEW-BWTAR = ''ECC + S/4
LAGPStorage BinsStorage section and last count date of the source binLAGP-LGNUM = LTAP-LGNUM AND LAGP-LGTYP = LTAP-VLTYP AND LAGP-LGPLA = LTAP-VLPLAECC + 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

ParameterDescriptionTypeReference fieldRequiredExample
S_LGNUMWarehouse numberRange / multipleLTAP-LGNUMYes100
S_QDATUConfirmation dateRange / multipleLTAP-QDATUYes01.11.2026 – 17.11.2026
S_QNAMEConfirmed byRange / multipleLTAP-QNAMENoDEPO_TOP3
S_VLTYPSource storage typeRange / multipleLTAP-VLTYPNo010
S_MATNRMaterialRange / multipleLTAP-MATNRNoFG-5003
S_BWLVSWM movement typeRange / multipleLTAK-BWLVSNo601
P_MINVALMinimum difference valueSingle value—No100

Output columns

#ColumnSource
1Transfer orderLTAP-TANUM
2ItemLTAP-TAPOS
3Movement typeLTAK-BWLVS
4MaterialLTAP-MATNR
5DescriptionLTAP-MAKTX
6Source typeLTAP-VLTYP
7Source binLTAP-VLPLA
8Target qtyLTAP-VSOLM
9Actual qtyLTAP-VISTM
10Difference qtyLTAP-VDIFM
11UnitLTAP-MEINS
12Difference valueCalculated LTAP-VDIFM × (MBEW-VERPR or MBEW-STPRS) ÷ MBEW-PEINH
13Confirmed byLTAP-QNAME
14Confirmed onLTAP-QDATU
15Reference doc.LTAK-BENUM

Sample output

Transfer orderItemMovement typeMaterialDescriptionSource typeSource binTarget qtyActual qtyDifference qtyUnitDifference valueConfirmed byConfirmed onReference doc.
00003120450002601FG-5003Packed product C01004-12-0324204PC1,180DEPO_TOP311/11/20268000041277
00003121010001601FG-5010Packed product K01001-02-0148462PC236DEPO_TOP111/12/20268000041302
00003121880003601FG-5003Packed product C01004-12-031293PC885DEPO_TOP311/14/20268000041355
00003122040001101RM-2040Steel sheet 2 mm902450001239880079010KG612DEPO_KAB211/15/20264500012398
A view built with fictional sample data; not real system data.

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.

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 Report Custom ALV report

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 …

T320 · MARD · LQUA · LTAP

WM Program Custom Mass upload

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 …

LTAK · LTAP · LQUA · LAGP

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: Transfer Orders Confirmed with Differences and Difference Value Report