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.
Challenge: Sales report with BP info - SAP ERP Tutorial
From the course: SAP Business One: Reporting and Customization
Challenge: Sales report with BP info
(upbeat music) - [Instructor] It's time for another challenge. My marketing person comes to me and wants a tool to see the sales for a product by bill-to state. There's a few records that don't have a state. So, you'll need to mark those as unknown state. Also, spell out the name of the state. See if you can write a report to give that based on an invoice. To save you some time and give you one hint, you'll need the OCST table, which has a key named code for the state code and a column name for the name. Okay, give this one a try.
Practice while you learn with exercise files
Download the files the instructor uses to teach the course. Follow along and learn by watching, listening and practicing.
Contents
-
-
-
-
-
-
(Locked)
Plan your report with good questions2m 5s
-
(Locked)
Add comments for readability4m 14s
-
(Locked)
Text editors with SQL2m 38s
-
(Locked)
Date and string functions6m 13s
-
(Locked)
Handling NULL values4m 58s
-
(Locked)
Use INNER JOIN for two tables6m 5s
-
(Locked)
Use JOIN for multiple tables5m 47s
-
(Locked)
Group data with GROUP BY5m 27s
-
(Locked)
Use aggregate functions5m 11s
-
(Locked)
Challenge: Sales report with BP info42s
-
(Locked)
Solution: Sales report with BP info5m 3s
-
(Locked)
-
-
-
-
-