WM Report Custom development ALV report

Unconfirmed Transfer Orders Aging Report

Short answer: A custom ALV report that lists transfer order items that were created but not confirmed across a warehouse number, by hours waiting, planned goods issue date of the linked delivery and source storage type. Shift supervisors see the picks that put shipments at risk before the cut-off time.

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?

LT22 and LT23 list open transfer orders by storage type or document, but they do not calculate the waiting time in hours, do not show the planned goods issue date of the delivery next to it and do not flag items past the cut-off time. LT24 is material-based and gives no wave or delivery priority. Teams rebuild this list in Excel every shift.

Who uses it? Warehouse shift supervisors, shipping planners and LE-WM key users.

Closest standard alternatives

  • LT22 Transfer Orders by Storage Type. Lists open transfer orders by storage type; no waiting time and no delivery goods issue date.
  • LT23 Transfer Orders by Number. Shows transfer orders by document number; does not flag risk against the cut-off time.

Tables used

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

TableRoleJoinSystem
LTAKTransfer Order HeaderTransfer order header: movement type, creation date/time, delivery and creating user (driving table)—ECC + S/4
LTAPTransfer Order ItemOpen items: material, source/destination storage type and bin, target quantityLTAP-LGNUM = LTAK-LGNUM AND LTAP-TANUM = LTAK-TANUMECC + S/4
LIKPDelivery HeaderPlanned goods issue date and route of the deliveryLIKP-VBELN = LTAK-VBELNECC + S/4
T301WM Storage TypesStorage type definition; used to separate interim storage typesT301-LGNUM = LTAP-LGNUM AND T301-LGTYP = LTAP-VLTYPECC + S/4

Selection screen parameters

ParameterDescriptionTypeReference fieldRequiredExample
S_LGNUMWarehouse numberRange / multipleLTAK-LGNUMYes100
S_BWLVSWM movement typeRange / multipleLTAK-BWLVSNo601
S_VLTYPSource storage typeRange / multipleLTAP-VLTYPNo001
S_NLTYPDestination storage typeRange / multipleLTAP-NLTYPNo916
S_BDATUCreation dateRange / multipleLTAK-BDATUNo10.11.2026 – 17.11.2026
S_BNAMECreated byRange / multipleLTAK-BNAMENoDEPO_PLAN1
P_HOURSDelay threshold (hours)Single value—Yes4
P_RISKShipment risk onlyCheckbox—NoX

Output columns

#ColumnSource
1Transfer orderLTAK-TANUM
2ItemLTAP-TAPOS
3Movement typeLTAK-BWLVS
4DeliveryLTAK-VBELN
5Planned GI dateLIKP-WADAT
6MaterialLTAP-MATNR
7Short textLTAP-MAKTX
8Source typeLTAP-VLTYP
9Source binLTAP-VLPLA
10Dest. typeLTAP-NLTYP
11Target qtyLTAP-VSOLM
12UnitLTAP-MEINS
13Created onLTAK-BDATU
14Created byLTAK-BNAME
15Waiting (hours)Calculated (Key date/time − LTAK-BDATU/BZEIT) in hours
16StatusCalculated Shipment at risk if GI date ≤ today; overdue if threshold exceeded; otherwise normal

Sample output

Transfer orderItemMovement typeDeliveryPlanned GI dateMaterialShort textSource typeSource binDest. typeTarget qtyUnitCreated onCreated byWaiting (hours)Status
00000812450001601008003451211/17/2026FG-5003Packed product C00101-05-0391624PC11/17/2026DEPO_PLAN16.50Shipment at risk
00000812450002601008003451211/17/2026FG-5011Instant soup pack00202-11-01916120PC11/17/2026DEPO_PLAN16.50Shipment at risk
00000813020001601008003457711/18/2026FG-6200Detergent 5 kg00103-02-0791640CAR11/17/2026DEPO_PLAN25.20Overdue
00000813100001101RM-1002Stretch film 50 cm9025000012834001300KG11/17/2026DEPO_GIRIS1.10Normal
A view built with fictional sample data; not real system data.

How does the report work?

  1. LTAK is read with the selection criteria; transfer orders with the confirmation indicator (KQUIT) set, i.e. fully confirmed, are skipped.
  2. Items with an empty confirmation indicator (PQUIT) are taken from LTAP; source and destination storage type/bin, target quantity (VSOLM) and the material short text (MAKTX) are added.
  3. If the transfer order belongs to a delivery (LTAK-VBELN), the planned goods issue date (WADAT) and route are read from LIKP.
  4. Waiting time = (key date and time) − (LTAK-BDATU + LTAK-BZEIT), in hours. Items above the threshold are highlighted in red.
  5. Risk status: “Shipment at risk” when the goods issue date is today or in the past and the item is still open, “Overdue” when the threshold is exceeded, otherwise “Normal”. The result is shown with subtotals per storage type and delivery.

Performance notes

Narrow the LTAK selection by warehouse number and KQUIT = blank; the standard index on LTAK serves these fields. Read LTAP in a single JOIN with the same key. Running the report as a background job at shift start and emailing it reduces online load.

Features

  • ALV list (sort, filter, subtotals)
  • User-specific layout variants
  • Double-click drill-down to the document Double-clicking the transfer order number displays it in LT21.
  • Export to Excel
  • Runs as a background job
  • Send the result by email Can be sent to supervisors per warehouse number at shift start.

Authorization objects

  • L_LGNUMDisplay authorization by warehouse number and storage type
  • L_BWLVSAuthorization by WM movement type

Frequently asked questions

Do partially confirmed transfer orders appear in the list?

Yes. As long as KQUIT is blank on the header, the unconfirmed items (LTAP-PQUIT blank) are listed; confirmed items do not appear as rows.

Which time zone is the waiting time based on?

The creation date and time (LTAK-BDATU/BZEIT) are stored in system time. For warehouses in another time zone, a conversion per warehouse number can be added.

Does this report work on S/4HANA?

On S/4HANA systems using Stock Room Management or classic LE-WM, LTAK and LTAP keep the same structure. If EWM is used, open warehouse tasks are read from /SCWM/ORDIM_O and the report is adapted accordingly.

Packages that include this solution

WM Package Custom

Warehouse Operations Control Pack

A five-report pack that shows daily warehouse health per warehouse number: unconfirmed transfer orders, stock stuck in interim storage and negative …

5 components · v1.0

Related reports

WM Report Custom ALV report

Interim Storage Stuck and Negative Stock Report

A custom ALV report that lists quants in goods receipt, shipping, posting change and difference interim storage types that have been waiting longer …

LQUA · LTBP · LTBK · LTAP

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: Unconfirmed Transfer Orders Aging Report