topic Re: how to create a tcode for abap query in Application Development and Automation Discussions

how to create a tcode for abap query

Former Member — Fri, 28 Mar 2008 07:58:49 GMT

how to create a transaction code for abap query,

i used a single table , my requirment is as i enter the tcode i should get the selectioin screen of my query.

Re: how to create a tcode for abap query

Former Member — Fri, 28 Mar 2008 08:02:38 GMT

Follow this

. Make a transaction with parameters transaction from se93 .

2. Put START_REPORT in the transaction

3. Check the skip intial screen checkbox

4. in the table control in the end of screen put these values

D_SREPOVARI-REPORTTYPE = AQ

D_SREPOVARI-REPORT = <USER GROUP in WHICH THE QUERY IS CREATED> G

(G stands for GLOBAL AREA:)(Entered after a space)(G should come after 9

chanracters(8 char for user group,one space and then G)

D_SREPOVARI-EXTDREPORT = <QUERY NAME>

refer this:

http://sap.ittoolbox.com/groups/technical-functional/sap-dev/how-to-assign-a-tcode-to-a-sap-query-579623

Regards

Shiva

Re: how to create a tcode for abap query

Former Member — Fri, 28 Mar 2008 08:03:40 GMT

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

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

Reward If useful

Regards

Ravi

Re: how to create a tcode for abap query

Former Member — Fri, 28 Mar 2008 08:04:11 GMT

check this link

Re: how to create a tcode for abap query

Former Member — Fri, 28 Mar 2008 08:05:12 GMT

It is simple.

Just follow the instructions in the link

http://www.alterego7.com/2008/01/attach-tcode-to-your-sap-query.html

Re: how to create a tcode for abap query

Former Member — Fri, 28 Mar 2008 08:08:47 GMT

go to se93 give your <name> say create.

then you will get a pop up select the first option.

and say enter.

then in transaction box enter start_report.

below the gui support you will find three check boxes select all of them and then below these check boxes you will find

name of screen field and value

there you must enter the following

D_SREPOVARI-REPORTTYPE AQ

D_SREPOVARI-EXTDREPORT QUERY NAME

D_SREPOVARI-REPORT INFOSETNAME

Re: how to create a tcode for abap query

Former Member — Fri, 28 Mar 2008 08:09:21 GMT

Hi,

1. execute the query.

2.After executing the quey Goto tcode SE38,therecopy the name of the program of the query which is created by query execution.

Go to tcode se93 enter tcode and ---create

-->descripton --radio button second(program and selection screen)

--->Enter program name which you got in se38 save.