From the course: SAP Business One: Reporting and Customization

Unlock the full course today

Join today to access over 22,600 courses taught by industry experts or purchase this course individually.

Solution: Sales report in SQL

Solution: Sales report in SQL - SAP ERP Tutorial

From the course: SAP Business One: Reporting and Customization

Start my 1-month free trial

Solution: Sales report in SQL

“

(upbeat music) - [Instructor] For this solution, there's several ways to go. But it's best to start in the Query Generator. So let's go to Tools, Queries, Query Generator and you're going to put in RDR1 and hit Tab. Never hit Return without having fields in otherwise things get really messy really fast. So make sure you hit Tab. And you'll get descriptions of fields here and so from those, you can probably figure out most of these. If you go down far enough, you will find one that's called the base code which is the BaseCard or Base BP Code. And I'll pick that one and double click it. And next, I'll find the Posting Date which is right above it here. And then scroll up a bit and you'll find Item Number and Item Description somewhere in here. There's Item Number. And right underneath it is Description. And just below that, you'll find the Unit Price and then Unit Quantity is above it and finally, we want the Row…

Contents