topic Re: Find SAP-Query from transaction code in Application Development and Automation Discussions

Find SAP-Query from transaction code

Former Member — Thu, 16 Jul 2009 10:39:48 GMT

Hi All,

I want to find the query related to transaction code.

Someone has created query and assined t-code to same.

I want to make changes in the same query but i m not getting that query.

I dont know the infoset or user who created it.

Suggest me the way to find it .

Regards,

Deepak.

Re: Find SAP-Query from transaction code

Former Member — Thu, 16 Jul 2009 10:42:36 GMT

Hi,

Get the program name from the transaction code and pass it to function module RSAQ_DECODE_REPORT_NAME. This will give the details

Regards

Re: Find SAP-Query from transaction code

GauthamV — Thu, 16 Jul 2009 10:45:20 GMT

Goto SE93 transaction, find program name.

For example AQZZZTEST======RFS=========== is program name.

Then ZTEST is user group and RFS is query name.

Re: Find SAP-Query from transaction code

Former Member — Thu, 16 Jul 2009 10:48:39 GMT

Use SE93, entr T-code and get the program name. Or you can also use TSTC to get the program name.

The program name will give you the query details.

Hope this helps!!!

Cheers,

Shailesh.

Re: Find SAP-Query from transaction code

Former Member — Thu, 16 Jul 2009 10:59:38 GMT

If ur tcode is a parameter transaction, display ur tcode in se93. you can check the screen field name D_SREPOVARI-EXTDREPORT and the value against it is ur query name.

Regards

Sathar

Re: Find SAP-Query from transaction code

Former Member — Thu, 16 Jul 2009 11:32:29 GMT

Hi,

I have use the function module RSAQ_DECODE_REPORT_NAME and passed the name of query prog to it.

After that i got query name and user group but when i see that query in SQ01 its showing me that

"Query SERVICE_REPORT has not yet been created" .

I have seen it in quick viewer also but no use.

I change the query area also - Client specific and cross client but i m not getting the query.

But the transaction is running fine.

Re: Find SAP-Query from transaction code

Former Member — Thu, 16 Jul 2009 11:44:33 GMT

Hi,

I guess it is a parameter transaction in your case.

Just execute the transaction, then in the selection screen menu SYSTEM --> Status (You can find the program name).

Pass the name to the function module i mentioned

or the screen field D_SREPOVARI-EXTDREPORT should hold the query name

Can you paste the full program name here (just to make sure you are passing the correct program name)

Regards

Edited by: Rajvansh Ravi on Jul 16, 2009 1:46 PM

Re: Find SAP-Query from transaction code

Former Member — Thu, 01 Oct 2009 10:32:58 GMT

Hi,

1.Goto SE93 and enter your transaction code.

2. Screen Fields :

I. D_SREPOVARI-REPORTTYPE : should be 'AQ' in case of SQ01 queris.

II. D_SREPOVARI-REPORT: Gives the name of the user group and query areas/environment

for ex. D_SREPOVARI-REPORT = TEST G

Means user group 'TEST' from 'Global Area' i.e. 'G' stands for global area and if G is not there then user group is in 'Standard

area'

III. D_SREPOVARI-EXTDREPORT : Gives the name of the query.

3. Then from SQ01 select the respective area global or standard.

4. Select respective user group by clicking on 'Other User Group ' button (Ctrl + F7 ) and then you can find out the required query in that user group.

Let me know if this suffices your requirements.

Regards,

Priya Bhat