topic Re: tcode for Query in Application Development and Automation Discussions

tcode for Query

Former Member — Mon, 25 Feb 2008 09:45:51 GMT

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

Re: tcode for Query

JozsefSzikszai — Mon, 25 Feb 2008 09:47:37 GMT

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

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).

Re: tcode for Query

Former Member — Mon, 25 Feb 2008 09:48:48 GMT

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

Re: tcode for Query

Former Member — Mon, 25 Feb 2008 09:54:09 GMT

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

Re: tcode for Query

Former Member — Mon, 25 Feb 2008 10:02:51 GMT

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.