/SAPAPO/LOCGC

Transparent Table Application Table
14 Fields 2 CDS Views

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. 2 CDS views read from this table.

CDS Views using this table (2)

ViewTypeJoinVDMDescription
I_LocationGeoCoordinatesLevel view from BASIC Geo coordinates of a location per level
R_LocationGeoCoordinatesLevel view_entity from BASIC Location Geo Coordinates 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)
);

Learn More