Read Query Output using ABAP (To Overcome APD constraints)
Dear All,
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.
Hi, there is a standard function module available "RRW3_GET_QUERY_VIEW_DATA" .Is there any added functionality in the custom program ?
Thanks
Hi,
Thanks...I have used same FM to capture data. Data has been converted as per the Query output structure.
Main purpose is to convert as per query format and use it for further calculations.
Nice, but I see the DSO name is hard coded in the program 🙂 . Making it a input parameter with error handling for incompatible fields would be good to have.
Benedict
Yes, It can be more dynamic. Based on customer requirements, Query output will be converted and DSO structure can be designed; and it will vary. So I have just added sample code.
Hi,
Do you know where I would find the Program code?
HI,
I think Attachments have been removed by SCN. I will try to attach again. regret for inconvenience caused.
Hi Rushikesh,
Were you able to attach the document again by any chance?
Regards,
Rashmi
Hi,
How can I find the program code. I am in a similar situation where we want to fetch the result rows of the query as SUMCT functions are used. Appreciate your help.