Community
Application Development and Automation Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Read only

Join SAP queries

Former Member

‎2011 Feb 21 4:15 PM

0 Likes
500

Hi,

I created one query and a set of variants. Now I want to execute the different variants and get only the number of entries from each query execution in one overview.

is there a way to get the result of different sap queries in one separate query?

Thanks in advance

3 REPLIES 3
Read only

Former Member

‎2011 Feb 21 5:20 PM

0 Likes
457

I am not sure if this is really feasible... You could potentially create a report program or see if you can work with coding blocks in infosets (SQ02 -> Extras) or get the results into spreadsheet and go from there

Read only

madhu_vadlamani
Active Contributor

‎2011 Feb 22 5:13 AM

0 Likes
457

Hi,

I do not think it is possible. Better to go for Zreport.

Regards,

Madhu.

Read only

Former Member

‎2011 Feb 22 5:59 AM

0 Likes
457

Hi Torsten,

Technically it is possible. You would have to use the Code exits(SQ02->Display Infoset->Goto->Code) in the infoset of the query that you would want to display the output.

In the code you would have to find the ABAP program names of your other queries (SQ01->Query->More Functions->Display Report Name) and using the SUBMIT statement (USING SELECTION-SET variant ) to run the other queries and then collect the output for your count of hits.

This though would be tedious and would involve a lot of hardcoding (program names and variant names). I would suggest using a Z program to keep it more dynamic.

Hope this helps.

Dominic