Many times, we require to capture BW query output for calculation and Analysis purpose [Especially Results Rows]. Analysis Process Designer (APD) functionality is used for this.
If the query contains SUMCT, SUMRT functions, then it is difficult to capture correct query results using APD.
To overcome this, ABAP utility/Simple ABAP code has been written. This will capture query output including RESULT rows and characteristics descriptions in output. On that, we can perform operations such as capture and update to write optimized DSO or display in ALV.
Program code has been attached for reference.
Your thoughts/Suggestions are welcome.