Find SAP-Query from transaction code

[Former Member]

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.

[Former Member]

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

[GauthamV]

Goto SE93 transaction, find program name.

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

Then ZTEST is user group and RFS is query name.

[Former Member]

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.

[Former Member]

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

[Former Member]

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.

[Former Member]

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

[Former Member]

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