SAP Table LEIN
Storage unit header records
LEIN (Storage unit header records) is a standard table in SAP R\3 ERP systems. Below you can find the technical details of the fields that make up this table. Key fields are marked in blue.
Additionally we provide an overview of foreign key relationships, if any, that link LEIN to other SAP tables.
LEIN table fields
| Field | Data element | Checktable | Datatype | Length | Decimals | Possible values | ||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
MANDT
Client
|
MANDT | T000 |
CLNT
|
3 | 0 | |||||||||||||||||||||||
|
LENUM
Storage Unit Number
|
LENUM |
CHAR
|
20 | 0 | ||||||||||||||||||||||||
|
LGNUM
Warehouse Number / Warehouse Complex
|
LGNUM | T300 |
CHAR
|
3 | 0 | |||||||||||||||||||||||
|
LETYP
Storage Unit Type
|
LVS_LETYP | T307 |
CHAR
|
3 | 0 | |||||||||||||||||||||||
|
LGTYP
Storage Type
|
LGTYP | T301 |
CHAR
|
3 | 0 | |||||||||||||||||||||||
|
LGPLA
Storage Bin
|
LGPLA |
CHAR
|
10 | 0 | ||||||||||||||||||||||||
|
SKZUA
Blocking Indicator: For Stock Removals (User)
|
LEIN_SKZUA |
CHAR
|
1 | 0 | ||||||||||||||||||||||||
|
||||||||||||||||||||||||||||
|
SKZUE
Blocking indicator: for putaways (user)
|
LEIN_SKZUE |
CHAR
|
1 | 0 | ||||||||||||||||||||||||
|
||||||||||||||||||||||||||||
|
SPGRU
Blocking reason
|
LVS_SPGRU | T330 |
CHAR
|
1 | 0 | |||||||||||||||||||||||
|
STATU
Status of Storage Unit
|
LEIN_STATU |
CHAR
|
1 | 0 | ||||||||||||||||||||||||
|
||||||||||||||||||||||||||||
|
ANZQU
Number of quants on storage unit
|
LEIN_ANZQU |
DEC
|
7 | 0 | ||||||||||||||||||||||||
|
BDATU
Date of last movement
|
LEIN_BDATU |
DATS
|
8 | 0 | ||||||||||||||||||||||||
|
BZEIT
Time of last movement
|
LEIN_BZEIT |
TIMS
|
6 | 0 | ||||||||||||||||||||||||
|
BTANR
Transfer order number of last stock transfer
|
LEIN_BTANR |
NUMC
|
10 | 0 | ||||||||||||||||||||||||
|
BTAPS
Item in transfer order of last stock transfer
|
LEIN_BTAPS |
NUMC
|
4 | 0 | ||||||||||||||||||||||||
|
MGEWI
Weight of materials on storage unit
|
LEIN_MGEWI |
DEC
|
11 | 3 | ||||||||||||||||||||||||
|
GEWEI
Weight Unit
|
GEWEI | T006 |
UNIT
|
3 | 0 | |||||||||||||||||||||||
|
PLPOS
Position in storage bin
|
LVS_PLPOS |
CHAR
|
2 | 0 | ||||||||||||||||||||||||
|
AOFTA
Number of open transfer order items on storage unit
|
LEIN_AOFTA |
DEC
|
5 | 0 | ||||||||||||||||||||||||
|
REFNR
Group
|
LVS_REFNR | T311 |
CHAR
|
10 | 0 | |||||||||||||||||||||||
|
UVTYP
Stor.type to which rem.goods are posted after compl.st.rem.
|
LEIN_UVTYP | T301 |
CHAR
|
3 | 0 | |||||||||||||||||||||||
|
UVPLA
Stor.bin to which rem.goods are posted after compl.stck rem.
|
LEIN_UVPLA |
CHAR
|
10 | 0 | ||||||||||||||||||||||||
|
KKAPV
Capacity usage of storage unit type
|
LVS_KKAPV |
DEC
|
11 | 3 | ||||||||||||||||||||||||
|
OKAPV
Old capacity usage of storage unit
|
LEIN_OKAPV |
DEC
|
11 | 3 | ||||||||||||||||||||||||
|
NPLEI
Dest.stor.bin changeable during confirmation
|
LVS_NPLEI |
CHAR
|
1 | 0 | ||||||||||||||||||||||||
|
||||||||||||||||||||||||||||
|
UVPOS
Position in transfer bin
|
LEIN_UVPOS |
CHAR
|
2 | 0 | ||||||||||||||||||||||||
|
UVQNR
Quant
|
LVS_LQNUM |
NUMC
|
10 | 0 | ||||||||||||||||||||||||
|
WETYP
Storage type where GR posting takes place
|
LEIN_WETYP |
CHAR
|
3 | 0 | ||||||||||||||||||||||||
|
WEPLA
Storage bin where GR posting takes place
|
LEIN_WEPLA |
CHAR
|
10 | 0 | ||||||||||||||||||||||||
|
WESTA
Goods Movement Status for Storage Bin
|
LEIN_WESTA |
CHAR
|
1 | 0 | ||||||||||||||||||||||||
|
||||||||||||||||||||||||||||
|
WEAQU
Number of quants with missing GR posting
|
LEIN_WEAQU |
DEC
|
7 | 0 | ||||||||||||||||||||||||
|
VBELN
Delivery
|
VBELN_VL |
CHAR
|
10 | 0 | ||||||||||||||||||||||||
LEIN foreign key relationships
| Table | Field | Foreign key table | Foreign key field | Check table | Check field |
|---|---|---|---|---|---|
| LEIN | GEWEI | LEIN | MANDT |
T006
Units of Measurement
|
MANDT |
| LEIN | GEWEI | LEIN | GEWEI |
T006
Units of Measurement
|
MSEHI |
| LEIN | LETYP | LEIN | MANDT |
T307
Storage Unit Types
|
MANDT |
| LEIN | LETYP | LEIN | LGNUM |
T307
Storage Unit Types
|
LGNUM |
| LEIN | LETYP | LEIN | LETYP |
T307
Storage Unit Types
|
LETYP |
| LEIN | LGNUM | LEIN | MANDT |
T300
WM Warehouse Numbers
|
MANDT |
| LEIN | LGNUM | LEIN | LGNUM |
T300
WM Warehouse Numbers
|
LGNUM |
| LEIN | LGTYP | LEIN | LGNUM |
T301
WM Storage Types
|
LGNUM |
| LEIN | LGTYP | LEIN | LGTYP |
T301
WM Storage Types
|
LGTYP |
| LEIN | LGTYP | LEIN | MANDT |
T301
WM Storage Types
|
MANDT |
| LEIN | MANDT | LEIN | MANDT |
T000
Clients
|
MANDT |
| LEIN | REFNR | LEIN | REFNR |
T311
Definition of WM Groups
|
REFNR |
| LEIN | REFNR | LEIN | MANDT |
T311
Definition of WM Groups
|
MANDT |
| LEIN | REFNR | LEIN | LGNUM |
T311
Definition of WM Groups
|
LGNUM |
| LEIN | SPGRU | LEIN | MANDT |
T330
Blocking Reasons
|
MANDT |
| LEIN | SPGRU | LEIN | LGNUM |
T330
Blocking Reasons
|
LGNUM |
| LEIN | SPGRU | LEIN | SPGRU |
T330
Blocking Reasons
|
SPGRU |
| LEIN | UVTYP | LEIN | MANDT |
T301
WM Storage Types
|
MANDT |
| LEIN | UVTYP | LEIN | LGNUM |
T301
WM Storage Types
|
LGNUM |
| LEIN | UVTYP | LEIN | UVTYP |
T301
WM Storage Types
|
LGTYP |