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 | Possible values | ||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
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 | ||||||||||||
|
||||||||||||||||
|
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 | SY | MANDT |
TVKN
Routes: Transportation Connection Points
|
MANDT |
| LOCATION | KNOTE | LOCATION | KNOTE |
TVKN
Routes: Transportation Connection Points
|
KNOTE |
| 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 | LOCATION | LIFNR |
LFA1
Vendor Master (General Section)
|
LIFNR |
| LOCATION | LIFNR | SY | MANDT |
LFA1
Vendor Master (General Section)
|
MANDT |
| 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 | LOCATION | TOR |
T30B
WM Gates
|
LGTOR |
| LOCATION | TOR | SY | MANDT |
T30B
WM Gates
|
MANDT |
| LOCATION | TOR | LOCATION | LGNUM |
T30B
WM Gates
|
LGNUM |
| LOCATION | VSTEL | SY | MANDT |
TVST
Organizational Unit: Shipping Points
|
MANDT |
| LOCATION | VSTEL | LOCATION | VSTEL |
TVST
Organizational Unit: Shipping Points
|
VSTEL |
| LOCATION | WERKS | LOCATION | WERKS |
T001W
Plants/Branches
|
WERKS |
| LOCATION | WERKS | SY | MANDT |
T001W
Plants/Branches
|
MANDT |