1. Home
  2. Resources
  3. SAP Tables
  4. GEOLOC - Geo location (lon/lat/alt/...)

SAP Table GEOLOC

Geo location (lon/lat/alt/...)

GEOLOC (Geo location (lon/lat/alt/...)) 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 GEOLOC to other SAP tables.

GEOLOC table fields

Field Data element Checktable Datatype Length Decimals
CLIENT Client MANDT CLNT 3 0
GUIDLOC GUID 16 GEOGUID RAW 16 0
LONGITUDE Geo location longitude GEOLON DEC 15 12
LATITUDE Geo location latitude GEOLAT DEC 15 12
ALTITUDE Geo location height GEOALT DEC 9 3
SRCID Geo location data source ID/Geocoder ID GEOSRCID CHAR 4 0
SRCTSTMP UTC Time Stamp in Short Form (YYYYMMDDhhmmss) TIMESTAMP DEC 15 0
PRECISID Precision (street, postal code, ...) of a Geo location GEOPRECIS NUMC 4 0
0000 Not specified
0100 World
0200 Continent
0300 Country
0400 Region
0500 Town limits
0600 Postal Code
0700 City
0800 District
0900 Street mid-point
1000 House number range (street section) mid-point
1100 House number (interpolated)
1200 House number (exact)
1300 House number with supplement (e.g. Neurottstr. 7b)
TZONE Time Zone TIMEZONE CHAR 6 0
CREATED UTC Time Stamp in Short Form (YYYYMMDDhhmmss) TIMESTAMP DEC 15 0
CREATEDBY User Name UNAME CHAR 12 0
CHANGED UTC Time Stamp in Short Form (YYYYMMDDhhmmss) TIMESTAMP DEC 15 0
CHANGEDBY User Name UNAME CHAR 12 0
ADDRNUMBER Address number AD_ADDRNUM CHAR 10 0
ADDRLOGSYS Logical system LOGSYS CHAR 10 0
ADDRGUID Address guid AD_GUID RAW 16 0
DELETED UTC Time Stamp in Short Form (YYYYMMDDhhmmss) TIMESTAMP DEC 15 0
DELETEDBY User Name UNAME CHAR 12 0