Application Development Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Showing results for 
Search instead for 
Did you mean: 

Can we append spatial data types to SAP standard tables?

raveeshsaurabh3
Active Participant
0 Kudos

Hi Gurus,

We want to append one field to AUFK, but the type of this field should be similar to ST_GEOMETRY. I see these data types are available at HANA DB level and can be accessed via HANA Studio, but these are not available in SE11 data types. Has some one tried something like this before? Any thoughts on the options we have? It does not seem possible as per the data types available in Se11, or via ABAP perspective of in HANA Studio.

Thanks in advance!

Warm Regards,

Raveesh

1 ACCEPTED SOLUTION

horst_keller
Product and Topic Expert
Product and Topic Expert

Up to now, the ABAP Dictionary does not support built-in types that are mapped to spatial types of the DB. Also, there are no such types in the ABAP Language. One thing, that comes to my mind would be a RAW field, that is then handled respectively by the application.

4 REPLIES 4

horst_keller
Product and Topic Expert
Product and Topic Expert

Up to now, the ABAP Dictionary does not support built-in types that are mapped to spatial types of the DB. Also, there are no such types in the ABAP Language. One thing, that comes to my mind would be a RAW field, that is then handled respectively by the application.

Former Member
0 Kudos

Is it possible to use ABAP to call a HANA function to use the spatial data. Our scenarios are as follows:

scenario 1: A polygon is drawn to identify an area where an incident has occurred. This needs to be stored somewhere. When a customer calls we need to verify whether the customers property is within the polygon. The client has an existing solution that uses the GIS system to identify all the properties within the polygon using the GIS system and hold them in a table in SAP ECC. The query is then performed against the table. We would like to be more innovative an simply verify whether the location of customer property is inside the polygon.

Scenario 2: Every time a job is created its location is recorded (X,Y). When a new customer calls the system needs to identify all known jobs within a defined radius of the call customer. Again an innovative approach would be to identify all jobs that are less than or equal to a defined distance from the location of the calling customer.

GIS systems can do this, but I was hoping to use the spatial capability of Hana.

horst_keller
Product and Topic Expert
Product and Topic Expert
0 Kudos

Should be possible with AMDP.

raveeshsaurabh3
Active Participant
0 Kudos

We were able to achieve this via AMDP. Thanks to Horst for providing the solution.