how to create t.code for a sap query

[Former Member]

i have created a sap query.

user wants this as a t.code.

how to assign a t.code for teh sap query.

kindly explain me.

[Former Member]

Hi ,

Create a TCODE in SE93 and include ur query.

Thanks.

Note:Reward Points if you find useful.

[Former Member]

what is the program/report name to assign,

explain me.

i couldnot able to get it.

[Former Member]

hi,

to create a tcode for query, pls. follow the steps:

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, Do reward.

[Former Member]

No difference in creating Tcode for ABAP Query and Normal report program.

Please use SE93 for the same.

Reward please if answer is useful

Thanks,

[Former Member]

Hi,

Go to transaction SE93 put the name of transaction you want to create then click on create and put the respective description .

Type the generated program name there to which you want to attach this transaction then save that data and execute the transaction it will work.

Reward Points if Useful.

Anita

[Former Member]

hi,

The other way of doing it.

1. Instead of creating your queries in SQ01, use SQVI. Create a query in your production system.

2. Now execute the query. When you have reached the selection screen, go to System > Status.

3. Copy the program name.

4. Now create a Z executable program in your development client. Put this one line of code in it:

submit program_name_copied_fr_production via selection-screen and return.

5. Create a TCode and assign the Z program to the TCode.

6. Transport the Z program and TCode over to Production system.

Hope this works for you, Do reward.

[Former Member]

Hi,

Go to SE93 -> enter transaction code name (it should start with Z) -> click on 'Create' -> in Start Object Section of the pop up window, please make the appropriate selection -> in case of Module Pool program, enter the Porgram Name and the First Screen of the module pool program -> In GUI Support, check the SAPGUI for Windows if your frontend is Windows -> Click Save.

Reward if helpful.

Edited by: prosenjit chaudhuri on Feb 12, 2008 12:03 PM

[Former Member]

thanks

i received reply

[Former Member]

Hi,

abap query and normal report program.

please use se93 for the same.

Thanks,

sagar dev