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
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
X Yes
NULL No
SKZUE Blocking indicator: for putaways (user) LEIN_SKZUE CHAR 1 0
X Yes
NULL No
SPGRU Blocking reason LVS_SPGRU T330 CHAR 1 0
STATU Status of Storage Unit LEIN_STATU CHAR 1 0
NULL in storage bin
1 For stock transfer
2 cont.stock addn
3 In Stck Rmvl
4 being created
5 in post.change
6 will be deleted
A to be picked (internal only)
B being created (internal only)
C in posting change (internal)
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
NULL Storage bin cannot be changed during confirmation
1 Storage bin can be changed during confirmation
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
NULL Goods movement posting complete
1 Goods movement posting still not complete
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 LGNUM T300 WM Warehouse Numbers LGNUM
LEIN LGNUM LEIN MANDT T300 WM Warehouse Numbers MANDT
LEIN LGTYP LEIN MANDT T301 WM Storage Types MANDT
LEIN LGTYP LEIN LGNUM T301 WM Storage Types LGNUM
LEIN LGTYP LEIN LGTYP T301 WM Storage Types LGTYP
LEIN MANDT LEIN MANDT T000 Clients MANDT
LEIN REFNR LEIN LGNUM T311 Definition of WM Groups LGNUM
LEIN REFNR LEIN REFNR T311 Definition of WM Groups REFNR
LEIN REFNR LEIN MANDT T311 Definition of WM Groups MANDT
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 UVTYP T301 WM Storage Types LGTYP
LEIN UVTYP LEIN MANDT T301 WM Storage Types MANDT
LEIN UVTYP LEIN LGNUM T301 WM Storage Types LGNUM