Skip to Content
author's profile photo Former Member
Former Member

Transform ABAP code to HANA SQLSCRIPT possible?

Hello All,


With regards to ABAP on HANA I have a question.



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(). 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

Sangamesh

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

1 Answer

  • Best Answer
    Posted on Jan 12, 2015 at 04:26 PM

    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.

    Cheers,

    Rich Heilman

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.