How many times did you want to create and run a SQL query in the service layer? Now you can!
The Service Layer for both MS SQL and SAP HANA was enhanced with the ability to generate highly flexible SQL Queries and reduce the manual effort to deploy views.
Want to know more? Check out this video for a detailed tutorial and example:
https://www.youtube.com/watch?v=CNNv4y8mPQc
Available in SAP Business One 10.0 FP 2011 and SAP Business One 10.0 FP 2011, version for SAP HANA.
Subscribe to the Official SAP Business One YouTube channel and stay informed – Remember, it’s available for everyone
This tip and all the other tips are available on SAP Business One Tips by SuperNova Solutions.
