FTRL_FS_GEOT005

Transparent Table Temporary Data
5 Fields 1 CDS Views

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)
);

Learn More