topic Re: how to create t.code for a sap query in Application Development and Automation Discussions

how to create t.code for a sap query

Former Member — Tue, 12 Feb 2008 10:52:06 GMT

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.

Re: how to create t.code for a sap query

Former Member — Tue, 12 Feb 2008 10:55:28 GMT

Hi ,

Create a TCODE in SE93 and include ur query.

Thanks.

Note:Reward Points if you find useful.

Re: how to create t.code for a sap query

Former Member — Tue, 12 Feb 2008 10:57:09 GMT

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.

Re: how to create t.code for a sap query

Former Member — Tue, 12 Feb 2008 10:57:42 GMT

what is the program/report name to assign,

explain me.

i couldnot able to get it.

Re: how to create t.code for a sap query

Former Member — Tue, 12 Feb 2008 10:58:05 GMT

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,

Re: how to create t.code for a sap query

Former Member — Tue, 12 Feb 2008 10:58:43 GMT

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

Re: how to create t.code for a sap query

Former Member — Tue, 12 Feb 2008 11:00:05 GMT

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.

Re: how to create t.code for a sap query

Former Member — Tue, 12 Feb 2008 11:01:43 GMT

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

Re: how to create t.code for a sap query

Former Member — Tue, 12 Feb 2008 11:24:02 GMT

thanks

i received reply

Re: how to create t.code for a sap query

Former Member — Wed, 06 Jul 2011 07:15:55 GMT

Hi,

abap query and normal report program.

please use se93 for the same.

Thanks,

sagar dev