hi query

[Former Member]

hi

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

[Former Member]

Hello,

YOu can create a Tcode for ur Query:

Check this thread

Regards,

Vasanth

[Former Member]

Hi,

U can create in SE93....

Kishore.

[Former Member]

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.