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
Tables used
The tables the report reads and their join fields. ECC and S/4HANA differences are marked separately.
| Table | Role | Join | System |
|---|---|---|---|
| LTAKTransfer Order Header | Transfer order header: movement type, creation date/time, delivery and creating user (driving table) | — | ECC + S/4 |
| LTAPTransfer Order Item | Open items: material, source/destination storage type and bin, target quantity | LTAP-LGNUM = LTAK-LGNUM AND LTAP-TANUM = LTAK-TANUM | ECC + S/4 |
| LIKPDelivery Header | Planned goods issue date and route of the delivery | LIKP-VBELN = LTAK-VBELN | ECC + S/4 |
| T301WM Storage Types | Storage type definition; used to separate interim storage types | T301-LGNUM = LTAP-LGNUM AND T301-LGTYP = LTAP-VLTYP | ECC + S/4 |
Selection screen parameters
| Parameter | Description | Type | Reference field | Required | Example |
|---|---|---|---|---|---|
| S_LGNUM | Warehouse number | Range / multiple | LTAK-LGNUM | Yes | 100 |
| S_BWLVS | WM movement type | Range / multiple | LTAK-BWLVS | No | 601 |
| S_VLTYP | Source storage type | Range / multiple | LTAP-VLTYP | No | 001 |
| S_NLTYP | Destination storage type | Range / multiple | LTAP-NLTYP | No | 916 |
| S_BDATU | Creation date | Range / multiple | LTAK-BDATU | No | 10.11.2026 – 17.11.2026 |
| S_BNAME | Created by | Range / multiple | LTAK-BNAME | No | DEPO_PLAN1 |
| P_HOURS | Delay threshold (hours) | Single value | — | Yes | 4 |
| P_RISK | Shipment risk only | Checkbox | — | No | X |
Output columns
| # | Column | Source |
|---|---|---|
| 1 | Transfer order | LTAK-TANUM |
| 2 | Item | LTAP-TAPOS |
| 3 | Movement type | LTAK-BWLVS |
| 4 | Delivery | LTAK-VBELN |
| 5 | Planned GI date | LIKP-WADAT |
| 6 | Material | LTAP-MATNR |
| 7 | Short text | LTAP-MAKTX |
| 8 | Source type | LTAP-VLTYP |
| 9 | Source bin | LTAP-VLPLA |
| 10 | Dest. type | LTAP-NLTYP |
| 11 | Target qty | LTAP-VSOLM |
| 12 | Unit | LTAP-MEINS |
| 13 | Created on | LTAK-BDATU |
| 14 | Created by | LTAK-BNAME |
| 15 | Waiting (hours) | Calculated (Key date/time − LTAK-BDATU/BZEIT) in hours |
| 16 | Status | Calculated Shipment at risk if GI date ≤ today; overdue if threshold exceeded; otherwise normal |
Sample output
| Transfer order | Item | Movement type | Delivery | Planned GI date | Material | Short text | Source type | Source bin | Dest. type | Target qty | Unit | Created on | Created by | Waiting (hours) | Status |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 0000081245 | 0001 | 601 | 0080034512 | 11/17/2026 | FG-5003 | Packed product C | 001 | 01-05-03 | 916 | 24 | PC | 11/17/2026 | DEPO_PLAN1 | 6.50 | Shipment at risk |
| 0000081245 | 0002 | 601 | 0080034512 | 11/17/2026 | FG-5011 | Instant soup pack | 002 | 02-11-01 | 916 | 120 | PC | 11/17/2026 | DEPO_PLAN1 | 6.50 | Shipment at risk |
| 0000081302 | 0001 | 601 | 0080034577 | 11/18/2026 | FG-6200 | Detergent 5 kg | 001 | 03-02-07 | 916 | 40 | CAR | 11/17/2026 | DEPO_PLAN2 | 5.20 | Overdue |
| 0000081310 | 0001 | 101 | RM-1002 | Stretch film 50 cm | 902 | 5000012834 | 001 | 300 | KG | 11/17/2026 | DEPO_GIRIS | 1.10 | Normal |
How does the report work?
- LTAK is read with the selection criteria; transfer orders with the confirmation indicator (KQUIT) set, i.e. fully confirmed, are skipped.
- 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.
- If the transfer order belongs to a delivery (LTAK-VBELN), the planned goods issue date (WADAT) and route are read from LIKP.
- Waiting time = (key date and time) − (LTAK-BDATU + LTAK-BZEIT), in hours. Items above the threshold are highlighted in red.
- 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
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 …
Related reports
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 …
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.