Skip to content

ABAP Keyword Documentation →  ABAP - Dictionary →  Built-In Data Types in ABAP Dictionary →  Attributes of the Predefined Dictionary Types →  Special Dictionary Types 

Geodata Types

The geodata type GEOM_EWKB is a built-in data type in ABAP Dictionary that describes the geometric position in a given coordinate reference system.

It represents fields in the database that contain geometric data in the EWKB (Extended Well-Known Binary) format. This type is currently only supported on SAP HANA databases and references the database type ST_GEOMETRY.

The internal representation of the geodata type GEOM_EWKB is a BLOB (Binary Large Object) and the same rules and restrictions largely apply as to the type RAWSTRING. The type GEOM_EWKB is mapped to the ABAP type xstring.

There is no semantic representation for geometric data at the ABAP level and ABAP can merely manage the transfer of geometric data between the application and the SAP HANA database. The SAP HANA database functions for geometric data types can be implemented using AMDP.

The data type GEOM_EWKB requires a coordinate reference system (a Spatial Reference System), namely a defined space in which geometric positions are described. Every spatial reference system has a unique spatial reference identifier (or SRID). This SRID is appended as an attribute of a table column with geometric data. The annotation @AbapCatalog.geo.spatialRefSystem and the corresponding SRID can be used to assign every coordinate reference system available in the specified SAP HANA database to a GEOM_EWKB column.

If the SRID is not assigned to a GEOM_EWKB column as an attribute, the system assigns the default value "0”to the annotation @AbapCatalog.geo.spatialRefSystem, which represents a Cartesian coordinate system.

Once a table is activated, however, the coordinate reference system of a geodata type cannot be changed.

Other versions: 7.31 | 7.40 | 7.54


Notes

  • NOT NULL cannot be set for a column of the type GEOM_EWKB.

  • Coordinate reference system information provided by a given SAP HANA database is saved in the SAP HANA system view ST_SPATIAL_REFERENCE_SYSTEMS. In the class CL_DD_DATATYPE, ABAP Dictionary provides the method get_spatial_reference_systems for extracting information about available coordinate reference systems.