SAP Reference
LT22
Display S/4HANA status: Active (StRM) · Replaced (EWM)S/4HANA status depends on deployment path: active with SAP Stock Room Management; replaced by EWM otherwise
Display Transfer Order per Storage Type
Notes
Classic LE-WM transaction. Remains available under SAP Stock Room Management, the in-scope successor to classic LE-WM for simpler warehouses; EWM warehouse-task processing is the alternative path in S/4HANA.
What the badges mean
- S/4HANA status: Active
- Active and unchanged in S/4HANA.
- S/4HANA status: Deprecated
- Still readable today, but no longer SAP's strategic path — plan around it.
- S/4HANA status: Replaced
- Replaced by a new persistence in S/4HANA; the classic name may still answer reads (see read mechanism).
- S/4HANA status: Migrating to IBP
- Planning scope is moving from APO toward IBP.
- S/4HANA status: Active (StRM) · Replaced (EWM)
- Path-dependent: active with SAP Stock Room Management, replaced where EWM is the warehouse path.
- S/4HANA status: Replaced · Compat View
- Compatibility view: the classic table name is redirected to a view over the new persistence — see how the physical model moved.
- S/4HANA status: Active · Proxy View
- Proxy view: reads route through NSDM proxy/CDS views — see how the physical model moved.
- master
- Data class: what the table holds — master data, transaction documents, org structure, config, or texts (one row per language — see the quirks guide).
In field listings, K marks a primary-key field, and linked type codes in the Type column jump to the matching quirks-guide section.
Boilerplate SQL
Databricks SQLStarting point for querying the tables behind this transaction. Set your Unity Catalog location and filter values below — they’re substituted into the SQL and the copy button.
Query parameters
7 parameters not filled: <catalog>, <schema>, <MANDT>, <LGNUM>, <DATE_FROM>, <DATE_TO>, <TANUM>
-- ============================================================
-- T-Code : LT22 Display Transfer Order per Storage Type
-- Purpose: Display transfer orders by storage type
-- Grain : One row per transfer-order item (LTAK header + LTAP item)
-- Tables : LTAK, LTAP, MAKT, MARA, T001W
-- Notes : LTAK.PQUIT = 'C' indicates a confirmed TO. VLPLA/NLPLA are the source/destination bins. For EWM, see /SCWM/* tables instead.
-- ============================================================
SELECT
-- Keys
h.MANDT AS "Client",
h.LGNUM AS "Warehouse Number",
h.TANUM AS "Transfer Order",
l.TAPOS AS "TO Item",
-- Descriptive text
mt.MAKTX AS "Material Description",
-- Quantities + UOM (paired)
l.VSOLM AS "Source Quantity",
l.VISTM AS "Actual Quantity",
l.NSOLM AS "Destination Quantity",
l.MEINS AS "Unit of Measure",
-- Dates
h.BDATU AS "Confirmation Date",
h.BZEIT AS "Confirmation Time",
h.DATAU AS "Creation Date",
h.UZEIT AS "Creation Time",
-- Status / indicators
h.BWLVS AS "Movement Type (WM)",
h.PQUIT AS "Confirmation Status",
l.KZQUIT AS "Item Confirmation",
h.BETYP AS "Reference Document Type",
h.BENUM AS "Reference Number",
-- Org fields
l.VLTYP AS "Source Storage Type",
l.VLPLA AS "Source Bin",
l.NLTYP AS "Destination Storage Type",
l.NLPLA AS "Destination Bin",
l.WERKS AS "Plant",
pt.NAME1 AS "Plant Name",
l.LGORT AS "Storage Location",
-- Master data enrichment
l.MATNR AS "Material Number",
m.MTART AS "Material Type",
m.MATKL AS "Material Group",
l.CHARG AS "Batch",
h.ERNAM AS "Created By"
FROM <catalog>.<schema>.ltak h
INNER JOIN <catalog>.<schema>.ltap l
ON l.MANDT = h.MANDT
AND l.LGNUM = h.LGNUM
AND l.TANUM = h.TANUM
LEFT JOIN <catalog>.<schema>.makt mt
ON mt.MANDT = l.MANDT
AND mt.MATNR = l.MATNR
AND mt.SPRAS = 'E'
LEFT JOIN <catalog>.<schema>.mara m
ON m.MANDT = l.MANDT
AND m.MATNR = l.MATNR
LEFT JOIN <catalog>.<schema>.t001w pt
ON pt.MANDT = l.MANDT
AND pt.WERKS = l.WERKS
WHERE
h.MANDT = '<MANDT>'
AND h.LGNUM = '<LGNUM>'
AND h.DATAU BETWEEN '<DATE_FROM>' AND '<DATE_TO>'
-- AND h.TANUM = '<TANUM>'
-- AND h.PQUIT = 'C' -- only confirmed
ORDER BY h.BDATU DESC, h.TANUM, l.TAPOS;Tables Used by This Transaction
How these tables connect — join details in the list below.
R read · W write · R/W read + write