课程: SAP Business One: Reporting and Customization
今天就学习课程吧!
今天就开通帐号,24,700 门业界名师课程任您挑!
Challenge: Sales report with BP info - SAP ERP教程
课程: 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.
随堂练习,边学边练
下载课堂讲义。学练结合,紧跟进度,轻松巩固知识。
内容
-
-
-
-
-
-
(已锁定)
Plan your report with good questions2 分钟 5 秒
-
(已锁定)
Add comments for readability4 分钟 14 秒
-
(已锁定)
Text editors with SQL2 分钟 38 秒
-
(已锁定)
Date and string functions6 分钟 13 秒
-
(已锁定)
Handling NULL values4 分钟 58 秒
-
(已锁定)
Use INNER JOIN for two tables6 分钟 5 秒
-
(已锁定)
Use JOIN for multiple tables5 分钟 47 秒
-
(已锁定)
Group data with GROUP BY5 分钟 27 秒
-
(已锁定)
Use aggregate functions5 分钟 11 秒
-
(已锁定)
Challenge: Sales report with BP info42 秒
-
(已锁定)
Solution: Sales report with BP info5 分钟 3 秒
-
(已锁定)
-
-
-
-
-