Open Transfer Requirements Not Converted to Transfer Orders Aging Report
Short answer: A custom ALV report that lists open or partially processed transfer requirements across all WM movement types by age, priority and the available stock in the source storage types. Each line shows why the requirement has not become a transfer order yet: no stock, blocked stock or simply too recent.
- 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?
LB10 and LB11 show open transfer requirements by storage type or material, but they do not show how many days a requirement has been waiting, whether available stock exists to cover the open quantity, or a worklist sorted by priority on one screen. Teams work out why a requirement is stuck by checking stock in LS24 one by one. The custom report calculates the aging and the likely reason automatically.
Who uses it? Warehouse shift supervisors, LE-WM key users and production supply planners.
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 |
|---|---|---|---|
| LTBKTransfer Requirement Header | Transfer requirement header: movement type, requirement type and number, status, priority, creation time (driving table) | — | ECC + S/4 |
| LTBPTransfer Requirement Item | Requirement item: material, plant, batch, requested and converted quantity | LTBP-LGNUM = LTBK-LGNUM AND LTBP-TBNUM = LTBK-TBNUM | ECC + S/4 |
| LQUAQuants | Total and available stock in the source storage type | LQUA-LGNUM = LTBP-LGNUM AND LQUA-MATNR = LTBP-MATNR AND LQUA-WERKS = LTBP-WERKS | ECC + S/4 |
| MAKTMaterial Descriptions | Material description (in the logon language) | MAKT-MATNR = LTBP-MATNR AND MAKT-SPRAS = SY-LANGU | ECC + S/4 |
Selection screen parameters
| Parameter | Description | Type | Reference field | Required | Example |
|---|---|---|---|---|---|
| S_LGNUM | Warehouse number | Range / multiple | LTBK-LGNUM | Yes | 100 |
| S_BWLVS | WM movement type | Range / multiple | LTBK-BWLVS | No | 319 |
| S_BETYP | Requirement type | Range / multiple | LTBK-BETYP | No | P |
| S_TBPRI | Transfer priority | Range / multiple | LTBK-TBPRI | No | 1 |
| S_MATNR | Material | Range / multiple | LTBP-MATNR | No | RM-1001 |
| S_BDATU | Requirement creation date | Range / multiple | LTBK-BDATU | No | 01.10.2026 – 17.11.2026 |
| P_MINAGE | Minimum age (days) | Single value | — | No | 1 |
| P_NOSTK | Only requirements without sufficient stock | Checkbox | — | No | — |
Output columns
| # | Column | Source |
|---|---|---|
| 1 | Transfer req. | LTBK-TBNUM |
| 2 | Item | LTBP-TBPOS |
| 3 | Movement type | LTBK-BWLVS |
| 4 | Req. type | LTBK-BETYP |
| 5 | Req. number | LTBK-BENUM |
| 6 | Material | LTBP-MATNR |
| 7 | Description | MAKT-MAKTX |
| 8 | Requested qty | LTBP-MENGE |
| 9 | Open qty | Calculated LTBP-MENGE − LTBP-TAMEN |
| 10 | Unit | LTBP-MEINS |
| 11 | Available stock | Calculated Sum of LQUA-VERME in the source storage types |
| 12 | Priority | LTBK-TBPRI |
| 13 | Created on | LTBK-BDATU |
| 14 | Age (days) | Calculated Key date − LTBK-BDATU |
| 15 | Likely reason | Calculated From comparing available and total stock: no stock, stock blocked or reserved, waiting for manual processing |
Sample output
| Transfer req. | Item | Movement type | Req. type | Req. number | Material | Description | Requested qty | Open qty | Unit | Available stock | Priority | Created on | Age (days) | Likely reason |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 0000004812 | 0001 | 319 | P | 1000245 | RM-1001 | Carton box 40x30 | 1,200 | 1,200 | PC | 0 | 1 | 11/12/2026 | 5 | No stock |
| 0000004815 | 0001 | 319 | P | 1000251 | RM-2040 | Steel sheet 2 mm | 800 | 300 | KG | 2,450 | 2 | 11/14/2026 | 3 | Waiting for manual processing |
| 0000004790 | 0002 | 311 | RM-3105 | Solvent-based paint | 150 | 150 | L | 0 | 11/03/2026 | 14 | Stock blocked or reserved | |||
| 0000004821 | 0001 | 101 | B | 4500012398 | RM-1002 | Stretch film 50 cm | 600 | 600 | KG | 600 | 11/17/2026 | 0 | Waiting for manual processing |
How does the report work?
- Requirements with status open (STATU blank) or partially processed (STATU = ‘T’) are read from LTBK for the selected warehouse number, movement type and requirement type.
- From the LTBP items, open quantity = requested quantity (MENGE) − quantity already in transfer orders (TAMEN); items flagged as completed (ELIKZ) or with zero open quantity are skipped.
- The available quantity (VERME) of the LQUA quants in the source storage type (LTBK-VLTYP; if blank, the storage types of the movement type’s search strategy) is summed per material, plant and batch.
- Age = key date − creation date (LTBK-BDATU). Reason code: ’no stock’ when available stock is zero, ‘stock blocked or reserved’ when total stock exists but none is available, ‘waiting for manual processing’ when stock is sufficient.
- The material description is added from MAKT. The result is shown in ALV sorted by priority (TBPRI) and age.
Performance notes
Read LTBK by warehouse number and status; LTBK has an index on warehouse number and status. Read LQUA once with FOR ALL ENTRIES on the material list and aggregate the result in memory.
Features
- ALV list (sort, filter, subtotals)
- User-specific layout variants
- Double-click drill-down to the document Double-clicking the requirement number displays it in LB03.
- Export to Excel
- Runs as a background job
- Send the result by email Waiting requirements can be sent to the warehouse supervisor at the start of each shift.
Authorization objects
- L_LGNUMDisplay authorization by warehouse number and storage type
- L_BWLVSAuthorization by WM movement type
Frequently asked questions
Are partially converted requirements included?
Yes. For requirements with status 'T' (partially processed), only the remaining open quantity (MENGE − TAMEN) is shown.
How is the likely reason determined?
Total stock (GESME) and available stock (VERME) in the source storage types are compared. For the exact cause you can jump from the line to LS24 and inspect the quants.
Does the report work on S/4HANA?
LE-WM on S/4HANA (including stock room management) uses the same LTBK/LTBP structure, so the report runs unchanged. After a move to EWM the equivalent is warehouse requests and a separate report is needed.
Related reports
Automatic Putaway Transfer Order Creation Job for Goods Receipt Interim Storage
A custom background job that finds open transfer requirements waiting in goods receipt interim storage longer than a set time, converts them into …
Open Posting Change Notices Aging Report
A custom ALV report that lists posting change notices (stock category, batch or material changes) not yet converted to transfer orders by age, next to …
Unconfirmed Transfer Orders Aging Report
A custom ALV report that lists transfer order items that were created but not confirmed across a warehouse number, by hours waiting, planned goods …
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.