topic Re: ABAP Query in Application Development and Automation Discussions

ABAP Query

Former Member — Wed, 23 Jan 2008 11:14:15 GMT

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

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

Re: ABAP Query

siddharth_mishra2 — Wed, 23 Jan 2008 11:21:44 GMT

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

Re: ABAP Query

JozsefSzikszai — Wed, 23 Jan 2008 11:21:55 GMT

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

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

Re: ABAP Query

Former Member — Wed, 23 Jan 2008 11:21:57 GMT

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

Re: ABAP Query

Former Member — Thu, 24 Jan 2008 13:48:46 GMT

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.

Re: ABAP Query

Former Member — Fri, 01 Feb 2008 07:49:36 GMT

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.

Re: ABAP Query

Former Member — Fri, 01 Feb 2008 07:50:07 GMT

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?

Re: ABAP Query

Former Member — Fri, 01 Feb 2008 09:00:28 GMT

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?

Re: ABAP Query

Former Member — Fri, 01 Feb 2008 09:37:21 GMT

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.