Call AMDP or any abap object from within HANA Stored Procedure or Flowgraph

[ruchirsaxena]

There are blogs and solutions available online for consuming native HANA objects like SQL Stored Procedure in AMDP (Native HANA). However, I am working on a research, wherein I am left wondering, if there is a possibility of calling an ABAP object like AMDP/Table Function or any other ABAP object, from a native HANA object like Stored Procedure or Flow Graph, which can possibly interact with an ABAP RFC, and return control to HANA at the end. Regardless of the requirement, is there a way or possibility of achieving the same? Advance Apologies if my question lacks proper clarity/concepts. Just attempting to search for an innovative solution.

[henrique_pinto · Accepted solution]

technically, you'd need to write an AFL function in HANA (using L Lang, similar to C) that would implement the RFC call to the ABAP app layer. Not sure if it would be worth the trouble...

Notice HANA SQLScript is within the DB layer, and it doesn't make a lot of sense from a design pattern perspective to call an app server from the DB server. If you have a requirement to embed some app logic within a HANA native app, you could then either embed that logic in your own App code in HANA XSA, or implement the RFC Call within the XSA app layer (e.g. by developing a XSA Java app and using JCo to call an RFC).

[pfefferf]

From within a stored procedure you cannot call an ABAP object. From a technical perspective it would be possible to call the procedure generated for an AMDP implementation, but this is absolutely not recommended, because such an object would be managed by the ABAP layer (e.g. generated by the first execution, removed if AMDP implementation is removed ...).

[ruchirsaxena]

Thank you Henrique and Florian. I had a similar understanding. Thank you for clarifying, and letting me know about the AFL approach, even though I will not be using it.