About Guillaume2

Guillaume2

Hello, I am trying to understand clearly what is the clean core strategy at SAP. My question is quite simple. When we need to add a custom field to do complex pricing calculation, in the former way we need to implement ABAP Code at least to transfe...

Guillaume2

Hello,I try to create a procedure (hdbprocedure) to randomly generate a point inside a Polygon. Here is My code: PROCEDURE "generate_points"( IN city NVARCHAR(30), IN npoints Integer, out ex_points table (id integer, newpoint ST_GEOMETRY)) LANGUAGE...

Guillaume2

Hello, I try to find a way to reverse geocode a lat/long to an address but using the address/geo directories from SAP HANA. I managed to do so with SDQ Flowgraphs using the geocode control. But I woud like to do the reverse geocoding directly fro...

Guillaume2

Hello, I am trying to set the SSO between the HANA Cockpit and 1 other SAP HANA systems (Registered Resources) with no success. HANA Cockpit: Hostname: SAPCPT, SID: SD1 (HANA Cockpit 2.0 SP12 on HANA 2.0 SP05) HANA DB1 : Hostname: SAPHANA3, SID...

Guillaume2

when trying to go to https://cap.cloud.sap to get the latest doc of CDS I get an error: 404 Not Found: Requested route ('cap.cloud.sap') does not exist.

Guillaume2

Mathias,Sorry, it works fine when I use the str_point I get into it 'POINT (2.3116883663460612 48.894058648496866)'; I was writing something else into my procedure and didn't see the other mistake.Thanks for your clear explanation.

Guillaume2

Hi Mathias,Thanks, for your quick answer. So if I understand well, I can do a point.ST_AsWKT() and the result will be a String (NVARCHAR(5000)).So I have added that, just for testing pupose:declare str_point NVARCHAR(5000); str_point = point.ST_AsWKT...

Guillaume2

Hello Mathias,I finally found how to solve my point. I understand (Thanks to Stefan) that I cannot do Reverse-geocoding, with the INDEX. At least, I find the way to use it in the Forward geocoding.Concerning the reverse Geocoding I will Ue my Flowgra...

Guillaume2

Hi Stefan,Thanks for your answer. So, ok INDEX GEOCODE will not work for reverse, I will try to search for other solution then.But for the direct Geocoding (Address => Geo Point), I have implemented it as the documentation says: using the GEOCODE IND...

Guillaume2

To be more precise, here is what I managed to do, and what I would like to do:What I managed to do: I have a table of POINTS: TEST_POINTS defined as Key: POINTID (Integer), LATITUDE (DOUBLE), LONGITUDE(DOUBLE).I want to get the 10th nearest address f...

User Statistics

User Activity

How to implement custom S/4HANA pricing procedure in the clean core way ?

HANA Spacial, Error when Using ST_AsWKT().

SAP HANA Spatial Reverse Geocoding

SAP HANA Cockpit SSO with HANA Ressource Impossible/error.

SAP CAP Website cap.cloud.sap not working/reachable...

Re: HANA Spacial, Error when Using ST_AsWKT().

Re: HANA Spacial, Error when Using ST_AsWKT().

Re: SAP HANA Spatial Reverse Geocoding

Re: SAP HANA Spatial Reverse Geocoding

Re: SAP HANA Spatial Reverse Geocoding