/ISDFPS/GEOLOC

Transparent Table Application Table
30 Fields 1 CDS Views

Geolocation Database Table

/ISDFPS/GEOLOC is an SAP database table in S/4HANA. Geolocation Database Table. It contains 30 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
I_FrcElmntOrgAddrGeoLocation view from BASIC Interface View for Force Element Address Geo Location

Fields (30)

KeyField Data ElementDescription DomainTypeLength
KEY mandt MANDT Client
KEY location_code /ISDFPS/LOCATION_CODE Location Code
location /ISDFPS/LOCATION Location Desc.
nation /ISDFPS/NATION Country/Region
province_state /ISDFPS/PROVINCE_STATE Region
location_type /ISDFPS/LOCATION_TYPE Location Type
air_mot /ISDFPS/AIR_MOT Air
sea_mot /ISDFPS/SEA_MOT Seaway
iww_mot /ISDFPS/IWW_MOT Inland Waterway
road_mot /ISDFPS/ROAD_MOT Road
rail_mot /ISDFPS/RAIL_MOT Rail System
pipe_mot /ISDFPS/PIPE_MOT Pipeline
utm /ISDFPS/UTM UTM Grid
longitude /ISDFPS/LONGITUDE Longitude
latitude /ISDFPS/LATITUDE Latitude
national_ref /ISDFPS/NATIONAL_REFERENCE National Ref.
remarks /ISDFPS/REMARKS Comments
date_entered /ISDFPS/DATE_ENTERED Date Entered
pin_entered /ISDFPS/PIN_ENTERED PIN Entered
date_updated /ISDFPS/DATE_UPDATED Date Changed
pin /ISDFPS/PIN PIN
userremarks /ISDFPS/USERREMARKS User Comments
modified /ISDFPS/MODIFIED Changed Manually
version_created /ISDFPS/VERSION_CREATED Created by Version
version_changed /ISDFPS/VERSION_CHANGED Changed by Version
creadat /ISDFPS/CREADAT Created On
creaby /ISDFPS/CREABY Created by
chngdat /ISDFPS/CHNGDAT Changed on
chngby /ISDFPS/CHNGBY Changed by
logsys /ISDFPS/LOGSYS Logical System

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.

-- Geolocation Database Table
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE /ISDFPS/GEOLOC (
    MANDT,            -- Client [MANDT]
    LOCATION_CODE,    -- Location Code [/ISDFPS/LOCATION_CODE]
    LOCATION,         -- Location Desc. [/ISDFPS/LOCATION]
    NATION,           -- Country/Region [/ISDFPS/NATION]
    PROVINCE_STATE,   -- Region [/ISDFPS/PROVINCE_STATE]
    LOCATION_TYPE,    -- Location Type [/ISDFPS/LOCATION_TYPE]
    AIR_MOT,          -- Air [/ISDFPS/AIR_MOT]
    SEA_MOT,          -- Seaway [/ISDFPS/SEA_MOT]
    IWW_MOT,          -- Inland Waterway [/ISDFPS/IWW_MOT]
    ROAD_MOT,         -- Road [/ISDFPS/ROAD_MOT]
    RAIL_MOT,         -- Rail System [/ISDFPS/RAIL_MOT]
    PIPE_MOT,         -- Pipeline [/ISDFPS/PIPE_MOT]
    UTM,              -- UTM Grid [/ISDFPS/UTM]
    LONGITUDE,        -- Longitude [/ISDFPS/LONGITUDE]
    LATITUDE,         -- Latitude [/ISDFPS/LATITUDE]
    NATIONAL_REF,     -- National Ref. [/ISDFPS/NATIONAL_REFERENCE]
    REMARKS,          -- Comments [/ISDFPS/REMARKS]
    DATE_ENTERED,     -- Date Entered [/ISDFPS/DATE_ENTERED]
    PIN_ENTERED,      -- PIN Entered [/ISDFPS/PIN_ENTERED]
    DATE_UPDATED,     -- Date Changed [/ISDFPS/DATE_UPDATED]
    PIN,              -- PIN [/ISDFPS/PIN]
    USERREMARKS,      -- User Comments [/ISDFPS/USERREMARKS]
    MODIFIED,         -- Changed Manually [/ISDFPS/MODIFIED]
    VERSION_CREATED,  -- Created by Version [/ISDFPS/VERSION_CREATED]
    VERSION_CHANGED,  -- Changed by Version [/ISDFPS/VERSION_CHANGED]
    CREADAT,          -- Created On [/ISDFPS/CREADAT]
    CREABY,           -- Created by [/ISDFPS/CREABY]
    CHNGDAT,          -- Changed on [/ISDFPS/CHNGDAT]
    CHNGBY,           -- Changed by [/ISDFPS/CHNGBY]
    LOGSYS,           -- Logical System [/ISDFPS/LOGSYS]
    PRIMARY KEY (MANDT, LOCATION_CODE)
);

Learn More