Transaction Code for Query

[Former Member]

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.

[Former Member]

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.

[JozsefSzikszai]

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

ec

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.

[Former Member]

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.

[Former Member]

Hi,

I hope the following links will help you.

Regards,

Harish

[Former Member]

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

[Former Member]

hi,

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

hope this helps u,

Arunsri

[Former Member]

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.

[Former Member]

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

[Former Member]

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

[Former Member]

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.

OR

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.

[JozsefSzikszai]

hi p317980,

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

ec

[Former Member]

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