SAP Table T001L
Storage Locations
T001L (Storage Locations) 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 T001L to other SAP tables.
T001L table fields
| Field | Data element | Checktable | Datatype | Length | Decimals | Possible values | ||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
MANDT
Client
|
MANDT | T000 |
CLNT
|
3 | 0 | |||||||||
|
WERKS
Plant
|
WERKS_D | T001W |
CHAR
|
4 | 0 | |||||||||
|
LGORT
Storage Location
|
LGORT_D |
CHAR
|
4 | 0 | ||||||||||
|
LGOBE
Description of Storage Location
|
LGOBE |
CHAR
|
16 | 0 | ||||||||||
|
SPART
Division
|
SPART | TSPA |
CHAR
|
2 | 0 | |||||||||
|
XLONG
Negative stocks allowed in storage location
|
XLONG |
CHAR
|
1 | 0 | ||||||||||
|
||||||||||||||
|
XBUFX
Freezing book inventory bal. allowed in stor. loc.
|
XBUFX |
CHAR
|
1 | 0 | ||||||||||
|
||||||||||||||
|
DISKZ
Storage location MRP indicator
|
DISKZ |
CHAR
|
1 | 0 | ||||||||||
|
||||||||||||||
|
XBLGO
Storage location authorization for goods movements active
|
XBLGO |
CHAR
|
1 | 0 | ||||||||||
|
||||||||||||||
|
XRESS
Storage location is allocated to resource (storage resource)
|
XRESS |
CHAR
|
1 | 0 | ||||||||||
|
||||||||||||||
|
XHUPF
Handling unit requirement
|
XHUPF |
CHAR
|
1 | 0 | ||||||||||
|
||||||||||||||
|
PARLG
Partner storage location of the handling unit
|
PARLG |
CHAR
|
4 | 0 | ||||||||||
|
VKORG
Sales Organization
|
VKORG | TVKO |
CHAR
|
4 | 0 | |||||||||
|
VTWEG
Distribution Channel
|
VTWEG | TVTW |
CHAR
|
2 | 0 | |||||||||
|
VSTEL
Shipping Point/Receiving Point
|
VSTEL | TVST |
CHAR
|
4 | 0 | |||||||||
|
LIFNR
Vendor Account Number
|
ELIFN | LFA1 |
CHAR
|
10 | 0 | |||||||||
|
KUNNR
Account Number of Customer
|
EKUNN | KNA1 |
CHAR
|
10 | 0 | |||||||||
|
MESBS
Business System of MES
|
MB_MES_BUSINESS_SYSTEM | MDG_BUS_SYS_TECH |
CHAR
|
60 | 0 | |||||||||
|
MESST
Type of inventory management for production storage location
|
MB_MES_STORLOC_TYPE |
CHAR
|
1 | 0 | ||||||||||
|
||||||||||||||
|
OIH_LICNO
License number for untaxed stock
|
OIH_LICNO |
CHAR
|
15 | 0 | ||||||||||
|
OIG_ITRFL
TD in-transit flag
|
OIG_ITRFL |
CHAR
|
1 | 0 | ||||||||||
|
||||||||||||||
|
OIB_TNKASSIGN
Silo Managament: Tank assignment indicator
|
OIB_TNKASSIGN |
CHAR
|
1 | 0 | ||||||||||
|
||||||||||||||
T001L foreign key relationships
| Table | Field | Foreign key table | Foreign key field | Check table | Check field |
|---|---|---|---|---|---|
| T001L | KUNNR | T001L | MANDT |
KNA1
General Data in Customer Master
|
MANDT |
| T001L | KUNNR | T001L | KUNNR |
KNA1
General Data in Customer Master
|
KUNNR |
| T001L | LIFNR | T001L | MANDT |
LFA1
Vendor Master (General Section)
|
MANDT |
| T001L | LIFNR | T001L | LIFNR |
LFA1
Vendor Master (General Section)
|
LIFNR |
| T001L | MANDT | T001L | MANDT |
T000
Clients
|
MANDT |
| T001L | MESBS | T001L | MANDT |
MDG_BUS_SYS_TECH
Technical information of a Business System
|
MANDT |
| T001L | MESBS | T001L | MESBS |
MDG_BUS_SYS_TECH
Technical information of a Business System
|
BUSINESS_SYSTEM |
| T001L | SPART | T001L | MANDT |
TSPA
Organizational Unit: Sales Divisions
|
MANDT |
| T001L | SPART | T001L | SPART |
TSPA
Organizational Unit: Sales Divisions
|
SPART |
| T001L | VKORG | T001L | MANDT |
TVKO
Organizational Unit: Sales Organizations
|
MANDT |
| T001L | VKORG | T001L | VKORG |
TVKO
Organizational Unit: Sales Organizations
|
VKORG |
| T001L | VSTEL | T001L | MANDT |
TVST
Organizational Unit: Shipping Points
|
MANDT |
| T001L | VSTEL | T001L | VSTEL |
TVST
Organizational Unit: Shipping Points
|
VSTEL |
| T001L | VTWEG | T001L | VTWEG |
TVTW
Organizational Unit: Distribution Channels
|
VTWEG |
| T001L | VTWEG | T001L | MANDT |
TVTW
Organizational Unit: Distribution Channels
|
MANDT |
| T001L | WERKS | T001L | MANDT |
T001W
Plants/Branches
|
MANDT |
| T001L | WERKS | T001L | WERKS |
T001W
Plants/Branches
|
WERKS |