Skip to Content
0
Aug 02, 2017 at 12:27 PM

Service Layer - Call procedure or view from database

4343 Views Last edit Aug 02, 2017 at 12:38 PM 4 rev

Hi Experts,

Suppose that I have an Add-on for SAP Business One Hana version, and for this I use UI API and Service Layer. What is the correct approach if I need call a procedure or view from my hana database?

Update:

I found on Service Layer documentation, that "Business object RecordSet (direct SQL) is not supported."

Then I'm not sure, if there are some approach on service layer for this situation, or maybe I need create a function on Hana XSJS that call the view or procedure.

Thanks for your attention.

Kind Regards,

Diego Lother