Using a SQL View in SAP BusinessOne

Yes, it is  possible to use a view in Business one client and you can use it too.

 Please find below a sample format that you should be using to query the view in business one environment −

SELECT <Column Names> FROM [dbo].[<View Name>]

I have done the same and it is working for me.

Updated on: 13-Feb-2020


Kickstart Your Career

Get certified by completing the course

Get Started