/SAPAPO/LOCGC

Transparent Table Application Table

Location Geo Coordinates per GeoCoding Level

/SAPAPO/LOCGC is an SAP database table in S/4HANA. Location Geo Coordinates per GeoCoding Level. It contains 14 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
I_LocationGeoCoordinatesLevel view from BASIC Geo coordinates of a location per level

Fields (14)

KeyField Data ElementDescription DomainTypeLength
KEY mandt mandt Client
KEY locid /sapapo/locid Location ID
KEY gc_level /sapapo/gc_level Geocoding Level
strategy /sctm/de_strategy Strategy
prec /sapapo/geoprecis Precision
xpos /sapapo/loc_ic_longitude Longitude
ypos /sapapo/loc_ic_latitude Latitude
match_gc /scmb/de_gc_match Match (%)
srcid geosrcid Data Source
zpos /sapapo/c_altitude Altitude
geo_validity_end /scmb/geo_data_validity_end Validity End
gis_zone /scmb/de_gis_zone_id GIS Zone
precisid geoprecis Precision
sdm_version sdm_status_value_done status value done

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.

-- Location Geo Coordinates per GeoCoding Level
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE /SAPAPO/LOCGC (
    MANDT,             -- Client [mandt]
    LOCID,             -- Location ID [/sapapo/locid]
    GC_LEVEL,          -- Geocoding Level [/sapapo/gc_level]
    STRATEGY,          -- Strategy [/sctm/de_strategy]
    PREC,              -- Precision [/sapapo/geoprecis]
    XPOS,              -- Longitude [/sapapo/loc_ic_longitude]
    YPOS,              -- Latitude [/sapapo/loc_ic_latitude]
    MATCH_GC,          -- Match (%) [/scmb/de_gc_match]
    SRCID,             -- Data Source [geosrcid]
    ZPOS,              -- Altitude [/sapapo/c_altitude]
    GEO_VALIDITY_END,  -- Validity End [/scmb/geo_data_validity_end]
    GIS_ZONE,          -- GIS Zone [/scmb/de_gis_zone_id]
    PRECISID,          -- Precision [geoprecis]
    SDM_VERSION,       -- status value done [sdm_status_value_done]
    PRIMARY KEY (MANDT, LOCID, GC_LEVEL)
);