Benefitting from built-in system queries
Besides Query Generator and Query Wizard, there is another powerful tool for you to learn SQL Query in SAP Business One. That is: System Queries.
System queries enable you to generate additional reports and retrieve data that is not available by running the other reports. You may access system queries either from the different modules—in each module the relevant system queries appear as entries under report menu, identified with the icon ? or by choosing them from Tools | Queries | System Queries.
The following screenshot shows you the names of all the available system queries. You may find as many as 18 queries here. Most queries are related to finance and banking.
You can see the query results from one ...
Get Mastering SQL Queries for SAP Business One now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
