GEOLOC

Transparent Table Application Table
18 Fields 5 CDS Views

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

GEOLOC is an SAP database table in S/4HANA. Geo location (lon/lat/alt/...). It contains 18 fields. 5 CDS views read from this table.

CDS Views using this table (5)

ViewTypeJoinVDMDescription
CIC_GEO_COORDINATES view_entity from Proj. on Geographic Coordinates (Industry Cloud Solutions)
I_FrcElmntOrgAddrGeoLocDet view from BASIC Interface View for FE Address Geo Location Details
I_InvgCsMGeoLocation view from BASIC Basic View for ICM Geo Location
UPOV_PR_WC_UOM view left_outer UOM: Well Completion
UPOV_PR_WELL_UOM view left_outer UOM: Well

Fields (18)

KeyField Data ElementDescription DomainTypeLength
KEY client MANDT Client
KEY guidloc GEOGUID Guid 32
longitude GEOLON Longitude
latitude GEOLAT Latitude
altitude GEOALT Height
srcid GEOSRCID Data Source
srctstmp TIMESTAMP Time Stamp
precisid GEOPRECIS Precision
tzone TIMEZONE Time Zone
created TIMESTAMP Time Stamp
createdby UNAME User Name
changed TIMESTAMP Time Stamp
changedby UNAME User Name
addrnumber AD_ADDRNUM Address Number
addrlogsys LOGSYS Logical system
addrguid AD_GUID Address guid
deleted TIMESTAMP Time Stamp
deletedby UNAME User Name

Derived SQL schema, reconstructed from the indexed DDIC field metadata (field names, types, lengths and key flags) — a functional representation, not the verbatim SAP source.

-- Geo location (lon/lat/alt/...)
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE GEOLOC (
    CLIENT,      -- Client [MANDT]
    GUIDLOC,     -- Guid 32 [GEOGUID]
    LONGITUDE,   -- Longitude [GEOLON]
    LATITUDE,    -- Latitude [GEOLAT]
    ALTITUDE,    -- Height [GEOALT]
    SRCID,       -- Data Source [GEOSRCID]
    SRCTSTMP,    -- Time Stamp [TIMESTAMP]
    PRECISID,    -- Precision [GEOPRECIS]
    TZONE,       -- Time Zone [TIMEZONE]
    CREATED,     -- Time Stamp [TIMESTAMP]
    CREATEDBY,   -- User Name [UNAME]
    CHANGED,     -- Time Stamp [TIMESTAMP]
    CHANGEDBY,   -- User Name [UNAME]
    ADDRNUMBER,  -- Address Number [AD_ADDRNUM]
    ADDRLOGSYS,  -- Logical system [LOGSYS]
    ADDRGUID,    -- Address guid [AD_GUID]
    DELETED,     -- Time Stamp [TIMESTAMP]
    DELETEDBY,   -- User Name [UNAME]
    PRIMARY KEY (CLIENT, GUIDLOC)
);

Learn More