GEOT005S_LOC

Transparent Table Temporary Data
7 Fields 1 CDS Views

Geo-location data for Country Regions

GEOT005S_LOC is an SAP database table in S/4HANA. Geo-location data for Country Regions. It contains 7 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
I_CountryRegionGeoPoint view from BASIC Geographical Location of a Region

Fields (7)

KeyField Data ElementDescription DomainTypeLength
KEY mandt MANDT Client
KEY land1 LAND1 Country/Reg.
KEY bland REGIO Region
longitude GEOLON Longitude
latitude GEOLAT Latitude
altitude GEOALT Height
geo_location GEOM_EWKB GEOM_EWKB

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 data for Country Regions
-- Category TRANSPARENT · Delivery class L
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE GEOT005S_LOC (
    MANDT,         -- Client [MANDT]
    LAND1,         -- Country/Reg. [LAND1]
    BLAND,         -- Region [REGIO]
    LONGITUDE,     -- Longitude [GEOLON]
    LATITUDE,      -- Latitude [GEOLAT]
    ALTITUDE,      -- Height [GEOALT]
    GEO_LOCATION,  -- GEOM_EWKB [GEOM_EWKB]
    PRIMARY KEY (MANDT, LAND1, BLAND)
);

Learn More