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
Tables used
The tables the report reads and their join fields. ECC and S/4HANA differences are marked separately.
| Table | Role | Join | System |
|---|---|---|---|
| T300WM Warehouse Numbers | Warehouse numbers (driving table) | — | ECC + S/4 |
| T300TWarehouse Number Descriptions | Warehouse number description | T300T-LGNUM = T300-LGNUM AND T300T-SPRAS = SY-LANGU | ECC + S/4 |
| T320Assignment of IM Storage Location to WM Warehouse Number | Assigned plant and storage location combinations | T320-LGNUM = T300-LGNUM | ECC + S/4 |
| T301WM Storage Types | Storage types | T301-LGNUM = T300-LGNUM | ECC + S/4 |
| T331Storage Type Control | Storage unit management setting | T331-LGNUM = T300-LGNUM | ECC + S/4 |
| LAGPStorage Bins | Number of bins and occupancy | LAGP-LGNUM = T300-LGNUM | ECC + S/4 |
| LQUAQuants | Number of quants and negative quants | LQUA-LGNUM = T300-LGNUM | ECC + S/4 |
| LTAKTransfer Order Header | Unconfirmed transfer orders | LTAK-LGNUM = T300-LGNUM | ECC + S/4 |
| LTBKTransfer Requirement Header | Open transfer requirements | LTBK-LGNUM = T300-LGNUM | ECC + S/4 |
| LUBUPosting Change Notice | Unprocessed posting change notices | LUBU-LGNUM = T300-LGNUM | ECC + S/4 |
| LINKWM Inventory Document Header | Incomplete inventory documents | LINK-LGNUM = T300-LGNUM | ECC + S/4 |
| LEINStorage Unit Header Records | Number of storage units | LEIN-LGNUM = T300-LGNUM | ECC + S/4 |
Selection screen parameters
| Parameter | Description | Type | Reference field | Required | Example |
|---|---|---|---|---|---|
| S_LGNUM | Warehouse number | Range / multiple | T300-LGNUM | Yes | 100 |
| S_WERKS | Plant (via the T320 assignment) | Range / multiple | T320-WERKS | No | 1000 |
| P_OPENTO | Maximum open transfer orders allowed | Single value | — | No | 0 |
| P_OPENTR | Maximum open transfer requirements allowed | Single value | — | No | 0 |
| P_DETAIL | Detail lines per storage type | Checkbox | — | No | — |
Output columns
| # | Column | Source |
|---|---|---|
| 1 | Warehouse | T300-LGNUM |
| 2 | Description | T300T-LNUMT |
| 3 | Plant/storage loc. | Calculated Number of T320 records assigned to the warehouse |
| 4 | Storage types | Calculated Number of T301 records |
| 5 | SU-managed types | Calculated Number of storage types with T331-LENVW set |
| 6 | Bins | Calculated Number of LAGP records |
| 7 | Occupied bins | Calculated Number of bins with LAGP-KZLER blank |
| 8 | Quants | Calculated Number of LQUA records |
| 9 | Negative quants | Calculated Number of quants with LQUA-VERME < 0 |
| 10 | Open TOs | Calculated Number of transfer orders with LTAK-KQUIT blank |
| 11 | Open TRs | Calculated Number of requirements whose LTBK-STATU is not completed |
| 12 | Open PCNs | Calculated Number of notices whose LUBU-STATU is not completed |
| 13 | Open inventory docs | Calculated Number of documents whose LINK-ISTAT is not completed |
| 14 | Storage units | Calculated Number of LEIN records |
| 15 | Readiness | Calculated Clean-up needed when negative quants > 0 or open-work thresholds are exceeded, otherwise ready |
Sample output
| Warehouse | Description | Plant/storage loc. | Storage types | SU-managed types | Bins | Occupied bins | Quants | Negative quants | Open TOs | Open TRs | Open PCNs | Open inventory docs | Storage units | Readiness |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 100 | Central warehouse Gebze | 3 | 12 | 4 | 18,420 | 14,306 | 26,911 | 7 | 142 | 38 | 5 | 2 | 9,820 | Clean-up needed |
| 200 | Spare parts warehouse Manisa | 1 | 6 | 0 | 6,250 | 3,980 | 4,417 | 0 | 0 | 0 | 0 | 0 | 0 | Ready |
| 300 | Raw material warehouse Kayseri | 2 | 8 | 2 | 9,100 | 7,215 | 8,034 | 0 | 11 | 4 | 0 | 1 | 2,650 | Clean-up needed |
How does the report work?
- 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.
- The number of storage types is taken from T301, and the number of storage types with storage unit management (LENVW) from T331.
- 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.
- 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.
- The number of storage units is taken from LEIN.
- 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
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 …
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 …
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.