Building a query based on the result of another query?

[Former Member]

Dear Gurus,

Is there a way in BEx where i can build a query which takes its data from the result of another query. Please give your thoughts.

Thanks

raj

[former_member188975 · Accepted solution]

Hi Raj,

I think the ResultSet query scenario may address your reqt. Using a char variable processed by replacement type you can have the results of one query used as an input for another query.

http://help.sap.com/saphelp_nw04/helpdata/en/2c/78a03c1178ad2ce10000000a114084/content.htm

Hope this helps...

[Former Member]

Hi YSS and Bhanu,

Thanks for all the help. i think the result set query is what i need.

Thanks a lot again

Raj

[Former Member]

Hi Raj

You can do that by RRI (Report to report interface). You have to define Sender/Receiver Assignments for your queries in BW.

here is link for Sender/Receiver Assignments help

http://help.sap.com/saphelp_erp2005/helpdata/en/c9/bc2d38c4b3f205e10000009b38f8cf/frameset.htm

I hope it will help