Showing results for 
Search instead for 
Did you mean: 

Service layer with userdefined query

Former Member

Dear all,

Currenly i had used service layer to populate or manipulate data of hana system. The filter of api is not strong enough when coming to some customize query like Join multiple tables or get from store procedure, i have not found any api to support that.

It like when we using DI, recordset do query, it very useful.

Please share if you have any solution for this case.

Thank you and best regards,

Accepted Solutions (0)

Answers (2)

Answers (2)

Active Contributor

i think the XS would be an easier approach as you can do a couple diff things:

1) odata - will allow you to query the data models, filters, filter operators, etc

2) if you can call a REST service, you have access to make it more customizable ... using either xsjs or if you have xsa, possibly nodejs or Java - this is a little more complicated as you have to do programming unlike if you used odata

0 Kudos

Sergio is it avalable for HANA 1?

Active Contributor
0 Kudos

yes, xsjs and xsodata is availabe in HANA 1 and HANA 2 as well

Product and Topic Expert
Product and Topic Expert

Hi Khanh,

SL 9.3 PL02 has been just released and contains a new feature that allows to run Semantic Layer views from Service Layer (system or custom views added to B1 Semantic Layer). Here you can access the blog with more details and a pointer to the documentation:

In B1H 9.2 version the only options are to use either the B1 xApp Framework:
1858188 – Extreme App Framework for SAP Business One: Samples and Documentation (S-user required)

or to create a HANA XS xsodata access.

Hope it helps

Former Member
0 Kudos

Dear Maria,

I will research your topic. It way is a lot helpful.

Thank you for your answer!

0 Kudos

Hello Maria,

Is it planned for the future to have some sort of user defined queries support in the service layer ? Otherwise what would be the best practices to extend the Service Layer in order to use it with custom queries.

We tried using the Script Engine for service layer to create extensions and deploy them using the extension manager, but it wasn't very practical to us, since every single object needed to have its own script and testing each script required us to create the ard file and deploy the script

Thank you very much,