tcode for Query

[Former Member]

Hi All,

Can any body tell me how to create Tcode for SQL-Query.

I created query and it is giving out put also .But I am unable to giveing Tcode.

plz send imediatly urgent.

thanks & regards.

venkat

[JozsefSzikszai]

hi Venkat,

Create a transaction calling transaction START_REPORT with the following parameters/attributes filled :

D_SREPOVARI-REPORTTYPE= AQ "parameter indicating Abap Query

D_SREPOVARI-REPORT= 'ZGRP' "Query User group

D_SREPOVARI-EXTDREPORT= 'ZNAME' "Query name

hope this helps

ec

PS.: 'Solutions' like include the generated program name into the tcode, won't work if client numbers differ between systems (i. e. if you want to transport the query and the tcode).

[Former Member]

Hi

If you want to assign the TCode to query then take the system generated program by going system->status then goto se93 and create a Tcode assigning the program name

Regards

Shiva

[Former Member]

Venki,

After executing the program Goto tcode SE38,ther you will find the program name of the query.

Go to tcode se93 enter tcode and ---create

-->descripton radio button second->Enter program name which you got in se38

[Former Member]

Hi,

Query will generate a program automatically. goto system->status and get that program.

now using se93 t code, you can create a Transaction code for that QUERY.