LEIN table — Storage Unit Header Table in Classic WM
LEIN is the classic Warehouse Management table that holds one row per storage unit (handling unit inside WM, identified by LENUM), recording its current storage type and bin. It answers where a pallet or container physically sits in the warehouse. It does not hold quantities or material numbers; those live in LQUA, which links back to LEIN by storage unit number.
This page covers LEIN, the storage unit header table in classic SAP Warehouse Management, and how it fits between the bin master, the quant table and transfer order processing. It focuses on the join pattern consultants actually use and the pitfalls that come from treating LEIN as if it carried stock quantities or material data.
Reviewed by an ERPClimb SAP consultant on 15 Sept 2026· 1,069 words
What it stores
Each row in LEIN represents one storage unit in classic WM: a physical handling unit such as a pallet, container or tote that has been placed into a warehouse and given a storage unit number (LENUM). The row records where that unit currently sits, expressed as warehouse number, storage type and storage bin. LEIN is a pure location and identity record for the unit itself. It does not carry the material, batch or quantity inside the unit; that detail sits in the quant table, which references the storage unit number. A storage unit can hold multiple quants if it is mixed, so LEIN and the quant table are in a one-to-many relationship. Storage units are created, moved and dissolved through transfer order processing, and LEIN is updated at confirmation, not at creation of the transfer order request.
Key fields
- MANDT - client, standard first key field on every table in the system
- LENUM - storage unit number, the unique identifier of the pallet or handling unit
- LGNUM - warehouse number the storage unit belongs to
- LGTYP - storage type where the storage unit currently resides
- LGPLA - storage bin within that storage type where the unit is placed
How it joins the data model
- LEIN-LGNUM = LAGP-LGNUM and LEIN-LGTYP = LAGP-LGTYP and LEIN-LGPLA = LAGP-LGPLA to resolve bin master data such as bin type and maximum capacity
- LEIN-LENUM = LQUA-LENUM to find the material, batch and quantity actually stored inside the unit
- LEIN-LGNUM = T300-LGNUM to resolve warehouse number text and control parameters
- LEIN-LGNUM = T301-LGNUM and LEIN-LGTYP = T301-LGTYP to resolve storage type control indicators
- LTAP-LENUM = LEIN-LENUM when tracing which transfer order item moved a given storage unit
How to read it safely
Always restrict on MANDT and LGNUM first; a shared client with several warehouse numbers turns a bin-level query into a full table scan otherwise. LENUM is the most selective field when a specific unit is under investigation and should be used directly if known rather than derived through bin or type filters. Do not attempt to select on LGPLA alone across the whole client; bin codes repeat across storage types and warehouse numbers, so a bin-only filter returns unrelated units in other warehouses. If tracing a business complaint about a missing pallet, start from the storage unit number if the user has it, and only fall back to storage type and bin range when the number is unknown.
How to prove it in the data
Symptom: a warehouse operator reports that a storage unit shown as available in the interleaving screen cannot be found in the bin. Take the storage unit number from the complaint and select LEIN on MANDT, LGNUM, LENUM. Compare the LGTYP and LGPLA returned against the physical location searched. If LEIN shows a different bin, the physical move happened without a confirmed transfer order, so the next step is LTAP filtered on that LENUM to find the last movement and its confirmation status, not a correction directly on LEIN.
ECC vs S/4HANA
LEIN remains part of the classic Warehouse Management data model on S/4HANA for customers who continue to run decentralized or classic WM rather than migrating to embedded EWM. It has not been replaced by a compatibility view in the way some MM or SD tables have, because classic WM itself continues to operate on its original table structure where it is still active. Where a warehouse has been converted to embedded EWM, storage unit data moves to the EWM storage unit model entirely and LEIN is no longer the relevant table for that warehouse number.
Common pitfalls
- Assuming LEIN carries stock quantity. It does not; the quantity lives in the quant table and must be joined in separately, otherwise a report built only on LEIN will show units with no visible material content and get flagged as a data error when it is simply the wrong table for that question.
- Editing LGTYP or LGPLA directly on LEIN to correct a bin discrepancy. This desynchronizes the storage unit from the quant records and the bin master occupancy status, and the next stock placement or removal against that bin will behave inconsistently. Corrections belong in a posting change or physical inventory transaction, not a direct table update.
- Treating a missing LEIN row as proof the storage unit never existed. Storage units are deleted from LEIN once emptied and confirmed out of the warehouse, so an absent row can simply mean the unit was already dissolved after full stock removal, which is normal lifecycle behavior, not an error.
- Confusing LEIN's storage unit number with a handling unit number from the general handling unit management tables. In warehouses where both concepts coexist, the numbers can look similar or even overlap in range if configured carelessly, and joining on the wrong number silently returns zero rows rather than an error.
- Assuming a storage unit shown in LEIN is undamaged or unblocked. Blocking status for stock removal or placement is controlled elsewhere in the WM data model, not visible from LEIN's location fields alone, so a unit can be correctly located but still unavailable for picking.
Whose problem this is
Warehouse operations or logistics execution consultants own questions about what LEIN shows, since it reflects transfer order confirmation results rather than a standalone master data set. Basis or data teams should not be asked to correct LEIN directly; any correction has to run through a WM transaction that also updates the quant and bin occupancy records consistently.
Related SAP objects
Reviewed pages this object connects to in the ERPClimb knowledge graph.
Source: ERPClimb — https://erpclimb.com/sap-tables/leinERPClimb is an independent platform and is not affiliated with SAP SE. Reference pages are written and reviewed by SAP consultants for learning and troubleshooting.