Skip to Content
Actions

Read Query Output using ABAP (To Overcome APD constraints)

September 22, 2015 | 111 Views |
 sap bisap business explorer (bex)sap bw
Follow RSS

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.

To report this post you need to login first.

6 Comments

You must be Logged on to comment or reply to a post.

    1. RUSHIKESH YEOLE Post author

      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.

      (0) 
  2. Former Member

    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

    (0) 
    1. RUSHIKESH YEOLE Post author

      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.

      (0) 

Leave a Reply