How to execute a native sql query from abap program o...

[Sandra_Rossi]

How can I execute a select from abap over a hana calculation view? supposing that my calculation view is in the schema "_SYS.BIC" and its name is "test/my_view", so how can I select its data from abap?

[Sandra_Rossi]

I searched quickly: there's a matter of exposing the view and a matter of parameters, also a blog post, what is your situation?

Solved: HANA Calculation View - With Parameter - Call from... - SAP Community

Consuming HANA Views, Procedures, External Views i... - SAP Community

[roland_szajko]

Some examples that you could do:

• Use EXEC SQL: https://help.sap.com/doc/abapdocu_750_index_htm/7.50/en-US/abapexec.htm
• Use an AMDP class: https://help.sap.com/docs/SAP_NETWEAVER_750/6811c09434084fd1bc4f40e66913ce11/3e7ce62892d243eca44499d...
• Embed the HANA CV into an HCPR and use the RSDRI_INFOPROV_READ: https://help.sap.com/docs/SUPPORT_CONTENT/bwplaolap/3361383473.html?locale=en-US