SAP table GEOLOC (Geo location (lon/lat/alt/...))
SAP table GEOLOC has 2 primary key fields being CLIENT,GUIDLOC.
| Field | Description | Data Type | Length | Decimals | Checktable | Data Element | |
|---|---|---|---|---|---|---|---|
| CLIENT | Client | CLNT | 3 | 0 | * | MANDT | |
| GUIDLOC | GUID 16 | RAW | 16 | 0 | GEOGUID | ||
| LONGITUDE | Geo location longitude | DEC | 15 | 12 | GEOLON | ||
| LATITUDE | Geo location latitude | DEC | 15 | 12 | GEOLAT | ||
| ALTITUDE | Geo location height | DEC | 9 | 3 | GEOALT | ||
| SRCID | Geo location data source ID/Geocoder ID | CHAR | 4 | 0 | GEOSRCID | ||
| SRCTSTMP | UTC Time Stamp in Short Form (YYYYMMDDhhmmss) | DEC | 15 | 0 | TIMESTAMP | ||
| PRECISID | Precision (street, postal code, ...) of a Geo location | NUMC | 4 | 0 | GEOPRECIS | ||
| TZONE | Time Zone | CHAR | 6 | 0 | * | TIMEZONE | |
| CREATED | UTC Time Stamp in Short Form (YYYYMMDDhhmmss) | DEC | 15 | 0 | TIMESTAMP | ||
| CREATEDBY | User Name | CHAR | 12 | 0 | UNAME | ||
| CHANGED | UTC Time Stamp in Short Form (YYYYMMDDhhmmss) | DEC | 15 | 0 | TIMESTAMP | ||
| CHANGEDBY | User Name | CHAR | 12 | 0 | UNAME | ||
| ADDRNUMBER | Address Number | CHAR | 10 | 0 | * | AD_ADDRNUM | |
| ADDRLOGSYS | Logical system | CHAR | 10 | 0 | * | LOGSYS | |
| ADDRGUID | Address guid | RAW | 16 | 0 | AD_GUID | ||
| DELETED | UTC Time Stamp in Short Form (YYYYMMDDhhmmss) | DEC | 15 | 0 | TIMESTAMP | ||
| DELETEDBY | User Name | CHAR | 12 | 0 | UNAME |