SGEOCITY

Transparent Table Application Table
5 Fields 2 CDS Views

Geographische Lage einer Stadt

SGEOCITY is an SAP database table in S/4HANA. Geographische Lage einer Stadt. It contains 5 fields. 2 CDS views read from this table.

CDS Views using this table (2)

ViewTypeJoinVDMDescription
demo_cds_sgeocity4graph view_entity from SGEOCITY View for AMDP Graph
S_CityAirport view left_outer Cities

Fields (5)

KeyField Data ElementDescription DomainTypeLength
KEY mandt s_mandt Client
KEY city s_city City
KEY country land1 Country/Reg.
latitude s_lati Latitude
longitude s_long Longitude

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.

-- Geographische Lage einer Stadt
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE SGEOCITY (
    MANDT,      -- Client [s_mandt]
    CITY,       -- City [s_city]
    COUNTRY,    -- Country/Reg. [land1]
    LATITUDE,   -- Latitude [s_lati]
    LONGITUDE,  -- Longitude [s_long]
    PRIMARY KEY (MANDT, CITY, COUNTRY)
);

Learn More