topic Re: hi query in Application Development and Automation Discussions

hi query

Former Member — Wed, 07 Mar 2007 09:05:05 GMT

i have created query in sq03, sq02, sq01, and to run this i go to sq01 and execute.

my question is, can i create TC for my query so that enduser will run query by TC and not from sq01.

thanx

rocky

Re: hi query

Former Member — Wed, 07 Mar 2007 09:07:24 GMT

Hello,

YOu can create a Tcode for ur Query:

Check this thread

Regards,

Vasanth

Re: hi query

Former Member — Wed, 07 Mar 2007 09:09:21 GMT

Hi,

U can create in SE93....

Kishore.

Re: hi query

Former Member — Wed, 07 Mar 2007 09:15:11 GMT

chk this from other thread

No need to use small report

No need to use generated program name (it really can change)

Just create a parameter transaction with reference to START_REPORT transaction. When creating a parameter transaction you have to set the following parameters:

D_SREPOVARI-REPORTTYPE = AQ

D_SREPOVARI-REPORT = precisely the first 12 characters - query user group (including trailing spaces), 13-th character is G for global queries

D_SREPOVARI-EXTDREPORT = Query name as shown in SQ01.

That's it.

Well, and do not forget to check the flag "Skip first screen".

To all others interested: just try to add some SAP query into a role via PFCG, then run it, and then via System -> Status look into the definition of the transaction generated, and you'll see the answer.