topic Re: Transaction Code for Query in Application Development and Automation Discussions

Transaction Code for Query

Former Member — Fri, 29 Feb 2008 09:27:36 GMT

Hi,

I have a QUERY name:ztest,Its infoset title is ztest1 and i want the transaction code as ZQR to be assigned to it.Please let me know the steps for the same.I have to use TCODE SQ01 for it??

Please guide me with this doubt.

Re: Transaction Code for Query

Former Member — Fri, 29 Feb 2008 09:32:32 GMT

Hi,

go to ur query...syste-->status. get the program name generated by SAP. Now you can use se93 to create a transaction code for the program of your query.

Re: Transaction Code for Query

JozsefSzikszai — Fri, 29 Feb 2008 09:34:10 GMT

hi,

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.: Pls. not that copying the generated program name directly into the tcode (as other commenters suggest), won't necessary work in other systems, if you transport the tcode.

Re: Transaction Code for Query

Former Member — Fri, 29 Feb 2008 09:34:52 GMT

Hi,

In order to create an ABAP query , one has to do the following.

1. Create an User group.

2. Create a Functional Area

3. Assign the User group to the Functional Area

4. Create the query based on the functional area created.

You can create or execute these, using the transactions below.

SQ01 for Query

SQ02 for Functional Area.

SQ03 for User Group.

Regards,

Priya.

Re: Transaction Code for Query

Former Member — Fri, 29 Feb 2008 09:35:45 GMT

Hi,

I hope the following links will help you.

Regards,

Harish

Re: Transaction Code for Query

Former Member — Fri, 29 Feb 2008 09:37:51 GMT

Hi,

1.Run the query .Goto tcode SE38 copy the program name.

2.Open tcode se93 .Enter tcode ZQR.

3. Give short description

4.Select secon radio button (Program and selection screen)

5.Enter program name(which is copied in se38.

6. Save .

<REMOVED BY MODERATOR>

Edited by: Alvaro Tejada Galindo on Feb 29, 2008 4:49 PM

Re: Transaction Code for Query

Former Member — Fri, 29 Feb 2008 09:44:36 GMT

hi,

create a tansaction code in SE93 and assign it to the query.

hope this helps u,

Arunsri

Re: Transaction Code for Query

Former Member — Fri, 29 Feb 2008 09:56:10 GMT

Thanks for all the prompt replis.I am not looking for creating transaction in SE93 for a Z PROGRAM.

But I am looking for a TCODE to be created for a QUERY in SQ01.Hope this would clear the doubt of people replying to this thread.

Re: Transaction Code for Query

Former Member — Fri, 29 Feb 2008 10:02:35 GMT

Hi,

a report will be created for the query u created using sq01 after running the query.

copy the report into zreport and then create tcode for report

using se93

Regards

Re: Transaction Code for Query

Former Member — Fri, 29 Feb 2008 10:14:39 GMT

hi,

Gotosystem--> Status in menu bar. Then note down the program name.

2) then goto se80 and open the program.

3) right click then create--> transaction.

4) then give tcode, with first option 'program and screen'.

then give the program name(same program name), screen number(initial screen) and

select all the check box under GUI SUPPORT.

thats it..

hope this helps u,

Regards,

Arunsri

Re: Transaction Code for Query

Former Member — Fri, 29 Feb 2008 11:23:20 GMT

Thanks for all the replis,folow these steps to come up with the solution.

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

After executing the query Goto SE38,there we find the program name of the query.Assign a tcode to it or thru SE93.

Run the query .Goto tcode SE38 - copy the program name.

Open tcode se93 .Enter tcode .

Give short description

Select second radio button (Program and selection screen)

Enter program name(which is copied thru SE38).

Save .

I am closing this thread now,thanks for the help.

Re: Transaction Code for Query

JozsefSzikszai — Fri, 29 Feb 2008 12:48:44 GMT

hi p317980,

you gave max. points to the answer, which did not answer your question at all

Re: Transaction Code for Query

Former Member — Mon, 03 Mar 2008 09:54:55 GMT

the reply formed the basis of my search,reason enough to give them points.