WM Report Custom development ALV report

LE-WM to EWM Migration Readiness Check Report (S/4HANA)

Short answer: A check report that summarizes, before an S/4HANA conversion, the structure and open workload of every warehouse number on one line: storage types, bins, occupied bins, quants, negative quants, open transfer orders, open transfer requirements, unprocessed posting change notices, open inventory documents and storage units. It shows what must be cleaned up before the cutover and the master data volume to move to EWM.

Estimated effort
M · 5–8 working days
System
ECC and S/4HANA
Tables
12
Scope
Global
Built by
NeKuDos Teknoloji
Last updated

Why is the standard not enough?

LE-WM is part of the compatibility scope in S/4HANA, and the target is usually EWM or Stock Room Management. Standard LX03, LT22 and LX09 show each topic separately per warehouse; no list collects all volume and open-work indicators needed for migration planning in one table per warehouse number. Project teams gather these numbers by hand before every mock conversion.

Who uses it? S/4HANA conversion project teams, logistics solution architects, warehouse process owners and project managers.

Closest standard alternatives

  • LT22 Transfer Orders by Storage Type. Lists open transfer orders by storage type; does not collect the other migration indicators.
  • LX09 Overview of Transfer Requirements. Gives an overview of transfer requirements; does not show bin, quant and inventory volume.

Tables used

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

TableRoleJoinSystem
T300WM Warehouse NumbersWarehouse numbers (driving table)—ECC + S/4
T300TWarehouse Number DescriptionsWarehouse number descriptionT300T-LGNUM = T300-LGNUM AND T300T-SPRAS = SY-LANGUECC + S/4
T320Assignment of IM Storage Location to WM Warehouse NumberAssigned plant and storage location combinationsT320-LGNUM = T300-LGNUMECC + S/4
T301WM Storage TypesStorage typesT301-LGNUM = T300-LGNUMECC + S/4
T331Storage Type ControlStorage unit management settingT331-LGNUM = T300-LGNUMECC + S/4
LAGPStorage BinsNumber of bins and occupancyLAGP-LGNUM = T300-LGNUMECC + S/4
LQUAQuantsNumber of quants and negative quantsLQUA-LGNUM = T300-LGNUMECC + S/4
LTAKTransfer Order HeaderUnconfirmed transfer ordersLTAK-LGNUM = T300-LGNUMECC + S/4
LTBKTransfer Requirement HeaderOpen transfer requirementsLTBK-LGNUM = T300-LGNUMECC + S/4
LUBUPosting Change NoticeUnprocessed posting change noticesLUBU-LGNUM = T300-LGNUMECC + S/4
LINKWM Inventory Document HeaderIncomplete inventory documentsLINK-LGNUM = T300-LGNUMECC + S/4
LEINStorage Unit Header RecordsNumber of storage unitsLEIN-LGNUM = T300-LGNUMECC + S/4

Selection screen parameters

ParameterDescriptionTypeReference fieldRequiredExample
S_LGNUMWarehouse numberRange / multipleT300-LGNUMYes100
S_WERKSPlant (via the T320 assignment)Range / multipleT320-WERKSNo1000
P_OPENTOMaximum open transfer orders allowedSingle value—No0
P_OPENTRMaximum open transfer requirements allowedSingle value—No0
P_DETAILDetail lines per storage typeCheckbox—No—

Output columns

#ColumnSource
1WarehouseT300-LGNUM
2DescriptionT300T-LNUMT
3Plant/storage loc.Calculated Number of T320 records assigned to the warehouse
4Storage typesCalculated Number of T301 records
5SU-managed typesCalculated Number of storage types with T331-LENVW set
6BinsCalculated Number of LAGP records
7Occupied binsCalculated Number of bins with LAGP-KZLER blank
8QuantsCalculated Number of LQUA records
9Negative quantsCalculated Number of quants with LQUA-VERME < 0
10Open TOsCalculated Number of transfer orders with LTAK-KQUIT blank
11Open TRsCalculated Number of requirements whose LTBK-STATU is not completed
12Open PCNsCalculated Number of notices whose LUBU-STATU is not completed
13Open inventory docsCalculated Number of documents whose LINK-ISTAT is not completed
14Storage unitsCalculated Number of LEIN records
15ReadinessCalculated Clean-up needed when negative quants > 0 or open-work thresholds are exceeded, otherwise ready

Sample output

WarehouseDescriptionPlant/storage loc.Storage typesSU-managed typesBinsOccupied binsQuantsNegative quantsOpen TOsOpen TRsOpen PCNsOpen inventory docsStorage unitsReadiness
100Central warehouse Gebze312418,42014,30626,911714238529,820Clean-up needed
200Spare parts warehouse Manisa1606,2503,9804,417000000Ready
300Raw material warehouse Kayseri2829,1007,2158,0340114012,650Clean-up needed
A view built with fictional sample data; not real system data.

How does the report work?

  1. The selected warehouse numbers are read from T300 with descriptions in the logon language from T300T; the number of assigned plant and storage location combinations comes from T320.
  2. The number of storage types is taken from T301, and the number of storage types with storage unit management (LENVW) from T331.
  3. Total bins and occupied bins (KZLER blank) are counted from LAGP; the number of quants and of negative quants with available quantity below zero from LQUA.
  4. Open work: unconfirmed transfer orders (LTAK-KQUIT blank), incomplete transfer requirements (LTBK-STATU), unprocessed posting change notices (LUBU-STATU) and incomplete inventory documents (LINK-ISTAT) are counted.
  5. The number of storage units is taken from LEIN.
  6. A readiness status is set per warehouse: “Clean-up needed” when negative quants or open work exist, otherwise “Ready”; the thresholds can be set on the selection screen.

Performance notes

Do all counting on the database with COUNT(*) and GROUP BY per warehouse number; do not read any table line by line. The report then finishes in minutes even in warehouses with millions of quants and can be re-run before every mock conversion.

Features

  • ALV list (sort, filter, subtotals)
  • User-specific layout variants
  • Double-click drill-down to the document Double-clicking open transfer orders opens LT22, open transfer requirements LB10, negative quants LX02.
  • Export to Excel The result can be exported to Excel to compare mock conversions.
  • Runs as a background job

Authorization objects

  • L_LGNUMDisplay authorization by warehouse number and storage type

Frequently asked questions

Is the report run before moving to S/4HANA?

Yes. It runs in ECC before every mock conversion and before the go-live cutover. Clearing open work and negative quants shortens the cutover weekend, and the bin and stock volume to move to EWM is planned from here.

Is it useful if Stock Room Management is chosen instead of EWM?

Yes. Clearing open work is needed for both targets. The number of storage-unit-managed types and the bin volume also help decide whether simple stock room management is enough.

Do the numbers contain personal or customer data?

No. The report shows only warehouse structure and document counts; it contains no material, customer or personal data, so it can be shared freely with project management and external consultants.

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: LE-WM to EWM Migration Readiness Check Report (S/4HANA)