Chapter 4. Query Examples
In the previous chapter, you learned about Query Manager and the most commonly-used statements and functions. That gave you a necessary tool to create any SQL queries within SAP Business One system freely. However, it may not be that easy to create a query to meet your specific needs.
This chapter will show you the following:
- The most widely used query examples to give you more powers to build your own queries. These include:
- Query variables
- Date selection
- Drill-down arrows
- Subtotals
- Detailed solution examples give all readers an idea about how business intelligence works within SAP Business One and breaks it down into three primary categories:
- Marketing documents
- Inventory transactions
- Financial transactions
- Alert query examples ...
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.
