topic Steps for creating T.code for SAP Query in Application Development and Automation Discussions

Steps for creating T.code for SAP Query

Former Member — Mon, 03 Nov 2008 04:53:27 GMT

Hi Friends,

I have developed and SAP Query through SQ01, i want to assign an T.code for that.

What are the steps we have to do in SE93.

Regards

Kumar M

Re: Steps for creating T.code for SAP Query

Former Member — Mon, 03 Nov 2008 04:59:38 GMT

Create a report pgm with the following code & create a T.Code for this pgm in se93.

data: gv_test type sy-repid.

DATA: GV_USERGROUP TYPE AQADEF-BGNAME VALUE 'FI',
      GV_QUERY TYPE AQADEF-QUNAME VALUE 'ZCON_FI_QUERY',
      GV_RNAME TYPE AQADEF-PGNAME .

CALL FUNCTION 'RSAQ_REPORT_NAME'
  EXPORTING
    WORKSPACE        = ''
    USERGROUP        = GV_USERGROUP
    QUERY            = GV_QUERY
 IMPORTING
   REPORTNAME       = GV_RNAME
          .
* For the dynamic excution of the called query assisgn GV_RNAME to <gv_test>.
gv_test = GV_RNAME.
submit (gv_test) via selection-screen and return.

Re: Steps for creating T.code for SAP Query

Former Member — Mon, 03 Nov 2008 05:34:59 GMT

for that you have to choose the option Parameter Transaction,

after giving the description,

in the default value section, give the transaction code as START_REPORT, check skip initial screen

check all the Gui related check boxes.

D_SREPOVARI-REPORTTYPE = AQ

D_SREPOVARI-REPORT = User group

D_SREPOVARI-EXTDREPORT = Query name

Re: Steps for creating T.code for SAP Query

Former Member — Mon, 03 Nov 2008 05:45:38 GMT

"1)In menu bar click on Query~~>More Functions~~>Generate Program

"2)Then, in menu bar click on Query~~>More Functions~~>Display report name

"3)Copy the program name.

"4)Go to SE93, create Tcode for report with selection screen option and enter the above copied report name.

Re: Steps for creating T.code for SAP Query

Former Member — Mon, 03 Nov 2008 09:16:54 GMT

Hi Vijay Babu,

I have tryed , but its giving me an error "The User Group 'XXXX' has not yet been created".

Regards

Kumar M

Edited by: mukesh kumar on Nov 3, 2008 10:17 AM

Re: Steps for creating T.code for SAP Query

Former Member — Tue, 04 Nov 2008 04:38:56 GMT

Thanks for the replies