In that blog I want to share approach to display Sales Item Configuration in CDS-way. The approach could be used both in new reporting technology (like Fiori RAP-reporting (managed and unmanaged), Embedded Analytics) and in classical (ALV classic Dynpro, SE16N, SE16H etc.)
Technically, the approach is using the following:
- Table Function with HANA SQL with scalar and table variable declaration
- Functions STRING_AGG for row concatenation, CAST for casting to target type, CASE for conditional logic in HANA SQL
- Window function for grouping and splitting the logic inside SQL-procedure
- Sorting inside database procedure
So, it can be used both for Sales Item Configuration and as a cheat-sheet for HANA SQL in AMDP-classes.
The blog is dedicated to Natalya Yakimenko; really encouraging and supportive person especially for Analytical Tools in Big Data / HANA.
Read More Technology Blog Posts by Members articles
#abap