How to execute a native sql query from abap program over a HANA calculation view?

[mrj_marcelo]

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

[Cocquerel · Accepted solution]

you have to embed your HANA Calculation view into an ABAP CDS view that you will be able to consume from ABAP programs. You can refer to the following blog https://community.sap.com/t5/technology-blogs-by-members/how-to-consume-hana-calculation-views-in-s-...

[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