ABAP Query

[Former Member]

Can anyone tell how to create a TCODE for an ABAP Query

using Transaction with parameters and how to assign a program to it

[siddharth_mishra2]

run the sap query from sqvi and when your input field will come then click on (menus) system->status

then copy the program name from there.

and then go to transaction se93

there u put the program name that u copied and click 3 check boxes (of gui support) then save the transaction by giving your customised tcode.

by this u can attach ur query to a tcode.ok

bye

tc

[JozsefSzikszai]

hi Lohita,

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

ec

PS.: Don't assign program name to trnasaction code in case of queries, because they are generated and may vary system by system.

[Former Member]

hi Eric!

After providing all those values in start_report and pressing ENTER, the query is getting executed.But where do we give TCODE name ?How to save that Tcode name?Please explain in detail.What is that user group? I am giving the value which is there in the description of the query.Is it correct?

[Former Member]

You can try this.

After completing your ABAP Query,

go to SQ01 and here navigate to...

Query > More functions > Generate Program.

This will generate the report.

now to see the report name you may go to

Query > More functions > Display Report Name.

Copy the report to ur own zreport and now you can create

a Tcode as always.

Reward if useful.

[Former Member]

hi

Go to se93 tcode and select second radio button (report transaction)

and put ur query generated prog name in the prog field.

reward points if helpful

Sunny

[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 and program name there to which u want to attach this transaction then save that data and execute the transaction it will work.

Hope it helps !!!

Sonia.

[Former Member]

Were u able to get an answer for this ABAP Query question tht u posted? I gave the answer and has also worked for me.

[Former Member]

Were u able to get an answer for this ABAP Query question tht u posted? I gave the answer and has also worked for me. would u like to have the info?