- Home
- Resources
- SAP Tables
- T001L - Storage Locations
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.
Source: T001L (Storage Locations)
T001L table fields
Field |
Data element |
Checktable |
Datatype |
Length |
Decimals |
|
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 |
Possible values
|
XBUFX |
Freezing book inventory bal. allowed in stor. loc. |
XBUFX |
|
CHAR |
|
1 |
0 |
Possible values
|
DISKZ |
Storage location MRP indicator |
DISKZ |
|
CHAR |
|
1 |
0 |
Possible values
NULL |
Storage location stock also planned at plant level |
1 |
Storage location stock excluded from MRP |
2 |
Storage location stock planned separately |
|
XBLGO |
Storage location authorization for goods movements active |
XBLGO |
|
CHAR |
|
1 |
0 |
Possible values
|
XRESS |
Storage location is allocated to resource (storage resource) |
XRESS |
|
CHAR |
|
1 |
0 |
Possible values
|
XHUPF |
Handling unit requirement |
XHUPF |
|
CHAR |
|
1 |
0 |
Possible values
|
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 |
Possible values
NULL |
No restrictions with regard to goods movements |
A |
Inventory management only by incoming transfer postings |
B |
Inventory management only by goods issue to production order |
|
OIH_LICNO |
License number for untaxed stock |
OIH_LICNO |
|
CHAR |
|
15 |
0 |
|
OIG_ITRFL |
TD in-transit flag |
OIG_ITRFL |
|
CHAR |
|
1 |
0 |
Possible values
|
OIB_TNKASSIGN |
Silo Managament: Tank assignment indicator |
OIB_TNKASSIGN |
|
CHAR |
|
1 |
0 |
Possible values
NULL |
No tank creation allowed at this storage location |
M |
Tank creation allowed, not all materials are held in tanks |
T |
Tank creation allowed, all materials are held in tanks |
|
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 |
LIFNR |
LFA1 |
Vendor Master (General Section) |
LIFNR |
T001L |
LIFNR |
T001L |
MANDT |
LFA1 |
Vendor Master (General Section) |
MANDT |
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 |
MANDT |
TVTW |
Organizational Unit: Distribution Channels |
MANDT |
T001L |
VTWEG |
T001L |
VTWEG |
TVTW |
Organizational Unit: Distribution Channels |
VTWEG |
T001L |
WERKS |
T001L |
MANDT |
T001W |
Plants/Branches |
MANDT |
T001L |
WERKS |
T001L |
WERKS |
T001W |
Plants/Branches |
WERKS |