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 declarationFunctions STRING_AGG for row concatenation, CAST for casting to target type, CASE for conditional logic in HANA SQLWindow function for grouping and splitting the logic inside SQL-procedureSorting 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.
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 declarationFunctions STRING_AGG for row concatenation, CAST for casting to target type, CASE for conditional logic in HANA SQLWindow function for grouping and splitting the logic inside SQL-procedureSorting inside database procedureSo, 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
#SAP
#SAPTechnologyblog
