How to create TCode for Sapquery

[Former Member]

Hi Everyone,

I would like to create a Tcode for a SapQuery i would like my users to use.

Is it possible? Can i use SE93 for this and it is, how do i use it?

Thanks in advance

[Former Member]

GO TO SE93....

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.

[andreas_mann3]

Bernhard,

you can use se93 - report transaction

Andreas

[Former Member]

Hi Kishan,

Thanks for your reply. It was very helpful, i'm almost done with it.

But i'm having trouble with the parameter:

<i>

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

</i>

My query user group only consist of 3 characters and the query area is a Standard Area. How do i cater for this?

Thanks.

Points awarded for your help.

[Former Member]

JUST TRY GIVE 9 SPACE BLANK AFTER USER GROUP(3 CHARACTER) AND 13 PLACE WRITE 'S' FOR STANDARED AREA....

[Former Member]

Hi Folks,

After creating the parameter transaction, how do i save the parameters such that I do not need to enter these parameters every time i execute the transaction?

I use start report and once the testing is over and i go back, the parameters are gone.

Best Regards,

Junwen

[Former Member]

Refer to Kishan Negi 's comment. Please remember to check the box that says Skip initial Screen

[srikrishna_narasimhan2]

Is there anyway we can give authorization for accessing specific divisions / dist channels when running a query transaction?

[Former Member]

Hi Kishan,

What is the difference in D_SREPOVARI-REPORT parameter been given as 'S' or "G'.

I gave 'S' for the T Code and transported the queries. all went fine but when I give T Code in the Quality system it says 'User Group BSS not created'.

I had transported all the user group, infoset and the queries.. Redone once more..

After the import in Quality system, In Query area -> when I give Standard area only I'm able to see the infoset and queries.. I'm able to see , run the queries.. But not with the T code transported..

Is this something wrong with the Global .. Standard Flag..

All the other values I had given as suggested..