Mastering SQL Queries for SAP Business One

Query for marketing documents

Marketing Documents is the term used in SAP Business One to represent both purchasing and sales documents. They also include A/P and A/R documents such as A/P Invoice or A/R Credit Memo. This category is one of the most targeted areas for query. Based on the chart shown in the first part of the chapter, it represents more than 60 percent of the query questions, which I have dealt with in the past.

Case 4-M1: Overview of BP with selection of realized balance

Here is an example request to get an overview of all customers which realized sales greater than 1,000 for the current year. The columns in need are the business partner's name, address, zip code, city, and email address.

The following is the solution query:

SELECT ...