Technology Blogs by Members
Explore a vibrant mix of technical expertise, industry insights, and tech buzz in member blogs covering SAP products, technology, and events. Get in the mix!
cancel
Showing results for 
Search instead for 
Did you mean: 
Rushikesh_Yeole
Contributor
1,716

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.

8 Comments
Former Member
0 Kudos

Hi, there is a standard function module available "RRW3_GET_QUERY_VIEW_DATA" .Is there any added functionality in the custom program ?

Thanks

BenedictV
Active Contributor
0 Kudos

Nice, but I see the DSO name is hard coded in the program :smile: . Making it a input parameter with error handling for incompatible fields would be good to have.

Benedict

Rushikesh_Yeole
Contributor
0 Kudos

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.

Rushikesh_Yeole
Contributor
0 Kudos

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 Kudos
 

Hi,

Do you know where I would find the Program code?
Rushikesh_Yeole
Contributor
0 Kudos
 

HI,

I think Attachments have been removed by SCN. I will try to attach again. regret for inconvenience caused.
0 Kudos
 

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.
rashmi_11
Explorer
0 Kudos
Hi Rushikesh,

Were you able to attach the document again by any chance?

Regards,

Rashmi
Labels in this area