SAP Table LOCATION
City, described by different objects in the SAP System
LOCATION (City, described by different objects in the SAP System) 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 LOCATION to other SAP tables.
LOCATION table fields
| Field | Data element | Checktable | Datatype | Length | Decimals | |||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| KNOTE | Location: Points | L_KNOTE | TVKN | CHAR | 10 | 0 | ||||||||||
| VSTEL | Location: Shipping point | L_VSTEL | TVST | CHAR | 4 | 0 | ||||||||||
| LSTEL | Location: Loading point at shipping point | L_LSTEL | TVLA | CHAR | 2 | 0 | ||||||||||
| KUNNR | Location: Customer | L_KUNNR | KNA1 | CHAR | 10 | 0 | ||||||||||
| KUNABL | Location: Customer's unloading point | L_KUNABL | KNVA | CHAR | 25 | 0 | ||||||||||
| LIFNR | Location: Vendor | L_LIFNR | LFA1 | CHAR | 10 | 0 | ||||||||||
| WERKS | Location: Plant | L_WERK | T001W | CHAR | 4 | 0 | ||||||||||
| LGORT | Location: Storage location in plant | L_LGORT | T001L | CHAR | 4 | 0 | ||||||||||
| LGNUM | Location: Warehouse number | L_LGNUM | T300 | CHAR | 3 | 0 | ||||||||||
| TOR | Location: Door for warehouse number | L_LGTOR | T30B | CHAR | 3 | 0 | ||||||||||
| BELAD | Loaction: Additional information (e.g. load./unload.point) | L_BEABLAD | CHAR | 25 | 0 | |||||||||||
| ADRNR | Location: Address | L_ADRNR | CHAR | 10 | 0 | |||||||||||
| ADRHND | Location: Handle of an address | L_ADRHND | CHAR | 10 | 0 | |||||||||||
| ADRKNZ | Location: Origin indicator of address | L_ADRKNZ | CHAR | 1 | 0 |
Possible values
|
||||||||||
| UPDKZ | Location: Update indicator of address | L_UPDKZ | CHAR | 1 | 0 | |||||||||||
| ADRNRD | Location: Address, dynamically determined fr.ship.pnt, etc. | L_ADRNRD | CHAR | 10 | 0 | |||||||||||
LOCATION foreign key relationships
| Table | Field | Foreign key table | Foreign key field | Check table | Check field | |
|---|---|---|---|---|---|---|
| LOCATION | KNOTE | LOCATION | KNOTE | TVKN | Routes: Transportation Connection Points | KNOTE |
| LOCATION | KNOTE | SY | MANDT | TVKN | Routes: Transportation Connection Points | MANDT |
| LOCATION | KUNABL | SY | MANDT | KNVA | Customer Master Unloading Points | MANDT |
| LOCATION | KUNABL | LOCATION | KUNNR | KNVA | Customer Master Unloading Points | KUNNR |
| LOCATION | KUNABL | LOCATION | KUNABL | KNVA | Customer Master Unloading Points | ABLAD |
| LOCATION | KUNNR | SY | MANDT | KNA1 | General Data in Customer Master | MANDT |
| LOCATION | KUNNR | LOCATION | KUNNR | KNA1 | General Data in Customer Master | KUNNR |
| LOCATION | LGNUM | SY | MANDT | T300 | WM Warehouse Numbers | MANDT |
| LOCATION | LGNUM | LOCATION | LGNUM | T300 | WM Warehouse Numbers | LGNUM |
| LOCATION | LGORT | SY | MANDT | T001L | Storage Locations | MANDT |
| LOCATION | LGORT | LOCATION | WERKS | T001L | Storage Locations | WERKS |
| LOCATION | LGORT | LOCATION | LGORT | T001L | Storage Locations | LGORT |
| LOCATION | LIFNR | SY | MANDT | LFA1 | Vendor Master (General Section) | MANDT |
| LOCATION | LIFNR | LOCATION | LIFNR | LFA1 | Vendor Master (General Section) | LIFNR |
| LOCATION | LSTEL | SY | MANDT | TVLA | Org.unit: Loading points per shipping point | MANDT |
| LOCATION | LSTEL | LOCATION | VSTEL | TVLA | Org.unit: Loading points per shipping point | VSTEL |
| LOCATION | LSTEL | LOCATION | LSTEL | TVLA | Org.unit: Loading points per shipping point | LSTEL |
| LOCATION | TOR | SY | MANDT | T30B | WM Gates | MANDT |
| LOCATION | TOR | LOCATION | LGNUM | T30B | WM Gates | LGNUM |
| LOCATION | TOR | LOCATION | TOR | T30B | WM Gates | LGTOR |
| LOCATION | VSTEL | LOCATION | VSTEL | TVST | Organizational Unit: Shipping Points | VSTEL |
| LOCATION | VSTEL | SY | MANDT | TVST | Organizational Unit: Shipping Points | MANDT |
| LOCATION | WERKS | SY | MANDT | T001W | Plants/Branches | MANDT |
| LOCATION | WERKS | LOCATION | WERKS | T001W | Plants/Branches | WERKS |
