topic Re: Join SAP queries in Application Development and Automation Discussions

Join SAP queries

Former Member — Mon, 21 Feb 2011 16:15:43 GMT

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

Re: Join SAP queries

Former Member — Mon, 21 Feb 2011 17:20:36 GMT

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

Re: Join SAP queries

madhu_vadlamani — Tue, 22 Feb 2011 05:13:11 GMT

Hi,

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

Regards,

Madhu.

Re: Join SAP queries

Former Member — Tue, 22 Feb 2011 05:59:35 GMT

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