Combine, combine

In the last four lessons, you have learned important aspects of each of the building blocks of SELECT queries. These can also be virtuously combined to create larger and more complex queries. In the following example we will determine for each task in status 1, 2, 3 or 4 the first and last name of the assignee and with a small detour via the project also the first and last name of the project manager and then determine for these combinations the total effort and the number of tasks.

With the shown modules SQL is extremely expressive and one can say without exaggeration that more than 90% of all transformation routines programmed in ABAP in a SAP BW can be replaced with these simple means in SQLScript. However, you will learn how to use these in a cleanly structured way in AMDP transformation routines in the SQLScript Basics and AMDP Transformation Routines for SAP BW/4HANA training courses.