GEOLOC - Geo location (lon/lat/alt/...)
Geo location (lon/lat/alt/...) information is stored in SAP table GEOLOC.
It is part of development package SZGL in software component BC-SRV-GEO. This development package consists of objects that can be grouped under "R/3 Central Basis Development: Geo Locations".
It is part of development package SZGL in software component BC-SRV-GEO. This development package consists of objects that can be grouped under "R/3 Central Basis Development: Geo Locations".
Fields for table GEOLOC
Field Name | Description | Is Key | Data Element | Data Type | Length | Check Table |
|---|---|---|---|---|---|---|
| CLIENT | Client | X | MANDT | CLNT | 6 | * |
| GUIDLOC | GUID 16 | X | GEOGUID | RAW | 16 | |
| LONGITUDE | Geo location longitude | GEOLON | DEC | 8 | ||
| LATITUDE | Geo location latitude | GEOLAT | DEC | 8 | ||
| ALTITUDE | Geo location height | GEOALT | DEC | 5 | ||
| SRCID | Geo location data source ID/Geocoder ID | GEOSRCID | CHAR | 8 | ||
| SRCTSTMP | UTC Time Stamp in Short Form (YYYYMMDDhhmmss) | TIMESTAMP | DEC | 8 | ||
| PRECISID | Precision (street, postal code, ...) of a Geo location | GEOPRECIS | NUMC | 8 | ||
| TZONE | Time Zone | TIMEZONE | CHAR | 12 | * | |
| CREATED | UTC Time Stamp in Short Form (YYYYMMDDhhmmss) | TIMESTAMP | DEC | 8 | ||
| CREATEDBY | User Name | UNAME | CHAR | 24 | ||
| CHANGED | UTC Time Stamp in Short Form (YYYYMMDDhhmmss) | TIMESTAMP | DEC | 8 | ||
| CHANGEDBY | User Name | UNAME | CHAR | 24 | ||
| ADDRNUMBER | Address Number | AD_ADDRNUM | CHAR | 20 | * | |
| ADDRLOGSYS | Logical system | LOGSYS | CHAR | 20 | * | |
| ADDRGUID | Address guid | AD_GUID | RAW | 16 | ||
| DELETED | UTC Time Stamp in Short Form (YYYYMMDDhhmmss) | TIMESTAMP | DEC | 8 | ||
| DELETEDBY | User Name | UNAME | CHAR | 24 |