Transform ABAP code to HANA SQLSCRIPT possible?
With regards to ABAP on HANA I have a question.
We have a situation where we are implementing a business logic on SAP HANA. In the process, we do have a complex ABAP function module that is to be called, which takes significantly longer execution time and send back the response back to CAR HANA DB. We also realized that this function module is too complex and involves long development time to implement on HANA at this point of time. But what we would like to have is one single platform for all business logic. So, I would like to know if there is any way(transformation engine) to transform ABAP code into HANA specific language(SQLSCRIPT) which not only saves time but also increases efficiency.
What I found out?(The following is just my understanding. Kindly correct me if I am wrong.)
I did my search on SCN/Google and realized that there in no such transformation engine that could transform the code to HANA SQLSCRIPT, but what is possible could be building the business logic in ABAP and call HANA stored procedures with data intensive logic within the ABAP code(Call ABAP function modules from HANA). So, if I have to achieve the same, then ABAP code needs significant modifications(optimization) as I understand. So, kindly let me know if this the only solution or maybe there is a better way to deal from perspective of HANA DB.
Kindly share me your opinion/views on the same.
Thanks and Regards
Rich Heilman replied
Yes there is no automated way to convert ABAP code into SQLScript. This is a manual effort. And yes, the recommended way to do code push down from ABAP, is to use AMDP(ABAP Managed Database Procedures), which is where you write SQLScript code directly in an ABAP method.