Syntax error Using a SQL View in SAP BusinessOne

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: 2020-02-13T07:16:30+05:30

469 Views

Kickstart Your Career

Get certified by completing the course

Get Started
Advertisements