Skip to Content
avatar image
-1
Former Member

Can we consume HANA SQL logic in ABAP Perspective ?

Hi,

I am using HANA Studio and writing code in SQL console and building simplified logic against traditional code used in SE38.

Since HANA SQL have more options, i am writing simplified code and everything is good.

For Ex: - I have written select query in SQL Console like below :

SELECT NOVEL_ID NAME POET from Schemaname. Table name;

But, can I consume them in ABAP Perspective ?

In Other words, I want to write logic in HANA Studio (SQL console using HANA SQL and SQL script ) and then use some method/ way to consume it in ABAP perspective.

I feel I am missing a link somewhere, any help or suggestion will be appreciated!


Best Regards,
KC

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Best Answer
    Dec 21, 2017 at 08:16 AM

    In the ABAP Perspective there's also a SQL Console. You can copy/paste your HANA SQL statement and test it there.

    If everthing is correct, create an ABAP programm and add "INTO TABLE @DATA(result)" to your statement.

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member Uwe Fetzer

      Hi Uwe Fetzer,

      One last query from the above answer,

      Suppose, Scenario : - I use all HANA Tables (Which are not available in SE11) to build SQL --> Create VIEW --- > Expose this View to ABAP perspective.

      When i execute (In ABAP perspective) can it still have access to data stored in HANA tables/ Views ?

      I mean I understand we cannot check them in SE11 but will the SQL query run without any errors.. Will it be able to access the data which is in HANA Tables in ABAP perspective..?

      Can you please provide any clue or something, if there is any possibility in the above scenario...?

      Thank you so much for your time and answering my query so far...

      Best Regards,
      KC

  • Dec 21, 2017 at 10:15 AM

    Look up ABAP Managed Database Procedures (AMDP) and ABAP Database Connectivity (ADBC).

    Add comment
    10|10000 characters needed characters exceeded