WM Report Custom development ALV report

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

  • LB10 Transfer Requirements for Storage Type. Lists open transfer requirements by storage type; no age, available stock or reason.
  • LB11 Transfer Requirements for Material. Shows requirements per material; does not give several movement types in one list sorted by priority.

Tables used

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

TableRoleJoinSystem
LTBKTransfer Requirement HeaderTransfer requirement header: movement type, requirement type and number, status, priority, creation time (driving table)—ECC + S/4
LTBPTransfer Requirement ItemRequirement item: material, plant, batch, requested and converted quantityLTBP-LGNUM = LTBK-LGNUM AND LTBP-TBNUM = LTBK-TBNUMECC + S/4
LQUAQuantsTotal and available stock in the source storage typeLQUA-LGNUM = LTBP-LGNUM AND LQUA-MATNR = LTBP-MATNR AND LQUA-WERKS = LTBP-WERKSECC + S/4
MAKTMaterial DescriptionsMaterial description (in the logon language)MAKT-MATNR = LTBP-MATNR AND MAKT-SPRAS = SY-LANGUECC + S/4

Selection screen parameters

ParameterDescriptionTypeReference fieldRequiredExample
S_LGNUMWarehouse numberRange / multipleLTBK-LGNUMYes100
S_BWLVSWM movement typeRange / multipleLTBK-BWLVSNo319
S_BETYPRequirement typeRange / multipleLTBK-BETYPNoP
S_TBPRITransfer priorityRange / multipleLTBK-TBPRINo1
S_MATNRMaterialRange / multipleLTBP-MATNRNoRM-1001
S_BDATURequirement creation dateRange / multipleLTBK-BDATUNo01.10.2026 – 17.11.2026
P_MINAGEMinimum age (days)Single value—No1
P_NOSTKOnly requirements without sufficient stockCheckbox—No—

Output columns

#ColumnSource
1Transfer req.LTBK-TBNUM
2ItemLTBP-TBPOS
3Movement typeLTBK-BWLVS
4Req. typeLTBK-BETYP
5Req. numberLTBK-BENUM
6MaterialLTBP-MATNR
7DescriptionMAKT-MAKTX
8Requested qtyLTBP-MENGE
9Open qtyCalculated LTBP-MENGE − LTBP-TAMEN
10UnitLTBP-MEINS
11Available stockCalculated Sum of LQUA-VERME in the source storage types
12PriorityLTBK-TBPRI
13Created onLTBK-BDATU
14Age (days)Calculated Key date − LTBK-BDATU
15Likely reasonCalculated From comparing available and total stock: no stock, stock blocked or reserved, waiting for manual processing

Sample output

Transfer req.ItemMovement typeReq. typeReq. numberMaterialDescriptionRequested qtyOpen qtyUnitAvailable stockPriorityCreated onAge (days)Likely reason
00000048120001319P1000245RM-1001Carton box 40x301,2001,200PC0111/12/20265No stock
00000048150001319P1000251RM-2040Steel sheet 2 mm800300KG2,450211/14/20263Waiting for manual processing
00000047900002311RM-3105Solvent-based paint150150L011/03/202614Stock blocked or reserved
00000048210001101B4500012398RM-1002Stretch film 50 cm600600KG60011/17/20260Waiting for manual processing
A view built with fictional sample data; not real system data.

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.

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

WM Report Custom ALV report

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 …

LUBU · LQUA · MAKT · T333

WM Report Custom ALV report

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 …

LTAK · LTAP · LIKP · 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: Open Transfer Requirements Not Converted to Transfer Orders Aging Report