Can SAP Business One Query a View?

1.1k views Asked by At

I built a view on MSSQL Management Studio and then I have a query to reference that view. It works fine on Management Studio. However, it would appear that B1 cannot query a view. Is that true? If there is a way, how?

1

There are 1 answers

0
Peter Canale On

Yep, you sure can use views in a query within the SAP Business One client. Format your query as follows:

SELECT * FROM [dbo].[view_name]