SAP Reference

LT02

Create S/4HANA status: Active (StRM) · Replaced (EWM)

S/4HANA status depends on deployment path: active with SAP Stock Room Management; replaced by EWM otherwise

Create Transfer Order for Inventory Difference

Module: WM · Warehouse Management (Classic)
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 SQL

Starting 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 : LT02 Create Transfer Order for Inventory Difference
-- Purpose: Create a transfer order to clear an inventory difference
-- Grain  : One row per transfer-order item (LTAK header + LTAP item)
-- Tables : LTAK, LTAP, MAKT, MARA, T001W
-- Notes  : LTAK.KQUIT = 'X' indicates a confirmed TO header; the item-level confirmation flag is LTAP.PQUIT. 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 "Creation Date",
  h.BZEIT   AS "Creation Time",
  l.QDATU   AS "Item Confirmation Date",
  l.QZEIT   AS "Item Confirmation Time",

  -- Status / indicators
  h.BWLVS   AS "Movement Type (WM)",
  h.KQUIT   AS "Confirmation Status",
  l.PQUIT   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.BNAME   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.BDATU BETWEEN '<DATE_FROM>' AND '<DATE_TO>'
  -- AND h.TANUM = '<TANUM>'
  -- AND h.KQUIT = 'X'   -- only confirmed
ORDER BY h.BDATU DESC, h.TANUM, l.TAPOS;

Tables Used by This Transaction

A curated list of the main business tables behind this transaction, drawn from this reference’s catalog. Tables a query joins only for names and descriptions may be left out.

How these tables connect — join details in the list below.

Loading relationship diagram…

Join details

  • LTAKLTAPheader item · 1:N
    ON ltak.TANUM = ltap.TANUM AND ltak.MANDT = ltap.MANDT
  • MARAMAKTtext table · 1:N
    ON mara.MATNR = makt.MATNR AND mara.MANDT = makt.MANDT

R read · W write · R/W read + write

More Warehouse Management (Classic) t-codes