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 | |||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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
|
||||||||
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
|
||||||||
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
|
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 | VKORG | TVKO | Organizational Unit: Sales Organizations | VKORG |
T001L | VKORG | T001L | MANDT | TVKO | Organizational Unit: Sales Organizations | MANDT |
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 |