FTRL_FS_GEOT005

Transparent Table Temporary Data

Geo-location data for countries

FTRL_FS_GEOT005 is an SAP database table in S/4HANA. Geo-location data for countries. It contains 5 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
I_TrsyFinStsCountryGeoPoint view_entity from BASIC Geographical Center of a Country/Region

Fields (5)

KeyField Data ElementDescription DomainTypeLength
KEY client mandt Client
KEY country land1 Country/Reg.
longitude geolon Longitude
latitude geolat Latitude
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 countries
-- Category TRANSPARENT · Delivery class L
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE FTRL_FS_GEOT005 (
    CLIENT,        -- Client [mandt]
    COUNTRY,       -- Country/Reg. [land1]
    LONGITUDE,     -- Longitude [geolon]
    LATITUDE,      -- Latitude [geolat]
    GEO_LOCATION,  -- GEOM_EWKB [geom_ewkb]
    PRIMARY KEY (CLIENT, COUNTRY)
);