find SAP Query using Tcode

[Former Member]

Hi All,

I have TCode of SAP Query, i need to find out SAP Query.

things i followed:

1) Executed TCode and menu bar --> System --> Status. I got Program.

2) I went to SE93 --> TCode --> Display --> bottom i got UserGroup, Query but when i try to check that Query in SQ01 it is saying Query has not created.

3) Executed program using FM RSAQ_DECODE_REPORT_NAME, got UserGroup n Query. but same issue as above.

Query is working but when i check in SQ01, it has not created is showing.

My requirement is - functional has created 4 SAP Queries. i need to merge all the SAP Queries into 1 report program.

i need how can we check those SAP Queries in SQ01 using TCode.

Regards,

Naresh.

[Former Member]

Hi Naresh.

You can check in two different query areas, the standard area and the global area.

Regards,

Boris.

[Former Member]

Hi Boris,

what ever the Query i got from FM, does not created it is showing in SQ01 but TCode is working.

May i know, any another process to find excat Query?

Regards,

Naresh.

[Former Member]

Hi,

Please check using user group. Find the Info Set assigned to that user group.

Then check Infoset where it is used in Query.

Hope this will help.

Thanks,

Ketul

[paul_davidson]

Hi Naresh,

You did not explain how the reports were created, but if they can be accessed directly via a transaction code individually, they were probably manually created by a programmer via ABAP and were not created via SQ01.  Thus, you cannot find them in the SQ01 table.  Only if they were created via Ad Hoc Query (PQAH) or directly in SQ01, would they be available via SQ01.

If they were created in SQ01 in a Development system and transported to your Productive system, they can be found in the Global Area as indicated above by Boris.  If they were created directly in the Productive system, they can be found in the Standard Area.  And again, each area has its own set of User Groups, so you may be looking in several areas.  The key is to learn how and where the queries you are searching for were created.

Paul