# Open Transfer Requirements Not Converted to Transfer Orders Aging Report

> 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.

- Type: Report, Custom development, ALV report
- Module: WM
- Estimated effort: S (2–4 working days)
- Last updated: 2026-11-17
- URL: https://nekuhub.com/en/reports/open-transfer-requirements-not-converted-to-transfer-orders-report/


## 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.

### Closest standard alternatives

- LB10: Lists open transfer requirements by storage type; no age, available stock or reason.
- LB11: Shows requirements per material; does not give several movement types in one list sorted by priority.

## Tables used

| Table | Role | Access | Join | System |
|---|---|---|---|---|
| LTBK | Transfer requirement header: movement type, requirement type and number, status, priority, creation time (driving table) | Read | - | ECC + S/4 |
| LTBP | Requirement item: material, plant, batch, requested and converted quantity | Read | LTBP-LGNUM = LTBK-LGNUM AND LTBP-TBNUM = LTBK-TBNUM | ECC + S/4 |
| LQUA | Total and available stock in the source storage type | Read | LQUA-LGNUM = LTBP-LGNUM AND LQUA-MATNR = LTBP-MATNR AND LQUA-WERKS = LTBP-WERKS | ECC + S/4 |
| MAKT | Material description (in the logon language) | Read | MAKT-MATNR = LTBP-MATNR AND MAKT-SPRAS = SY-LANGU | ECC + S/4 |

## Selection screen parameters

| Parameter | Description | Type | Reference field | Required |
|---|---|---|---|---|
| S_LGNUM | Warehouse number | Range / multiple | LTBK-LGNUM | Yes |
| S_BWLVS | WM movement type | Range / multiple | LTBK-BWLVS | No |
| S_BETYP | Requirement type | Range / multiple | LTBK-BETYP | No |
| S_TBPRI | Transfer priority | Range / multiple | LTBK-TBPRI | No |
| S_MATNR | Material | Range / multiple | LTBP-MATNR | No |
| S_BDATU | Requirement creation date | Range / multiple | LTBK-BDATU | No |
| P_MINAGE | Minimum age (days) | Single value | - | No |
| P_NOSTK | Only requirements without sufficient stock | Checkbox | - | No |

## Output columns

| Column | Source |
|---|---|
| Transfer req. | LTBK-TBNUM |
| Item | LTBP-TBPOS |
| Movement type | LTBK-BWLVS |
| Req. type | LTBK-BETYP |
| Req. number | LTBK-BENUM |
| Material | LTBP-MATNR |
| Description | MAKT-MAKTX |
| Requested qty | LTBP-MENGE |
| Open qty | Calculated: LTBP-MENGE − LTBP-TAMEN |
| Unit | LTBP-MEINS |
| Available stock | Calculated: Sum of LQUA-VERME in the source storage types |
| Priority | LTBK-TBPRI |
| Created on | LTBK-BDATU |
| Age (days) | Calculated: Key date − LTBK-BDATU |
| Likely reason | Calculated: From comparing available and total stock: no stock, stock blocked or reserved, waiting for manual processing |

## How does the report work?

1. 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.
2. 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.
3. 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.
4. 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.
5. The material description is added from MAKT. The result is shown in ALV sorted by priority (TBPRI) and age.

## Authorization objects

- L_LGNUM: Display authorization by warehouse number and storage type
- L_BWLVS: Authorization 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.

---
Let us build this report for your system: https://nekuhub.com/en/request-a-quote/?report=wm-open-transfer-requirements-aging
