topic Re: How to create TCode for Sapquery in Application Development and Automation Discussions

How to create TCode for Sapquery

Former Member — Mon, 03 Jul 2006 07:10:14 GMT

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

Re: How to create TCode for Sapquery

Former Member — Mon, 03 Jul 2006 07:12:36 GMT

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.

Re: How to create TCode for Sapquery

andreas_mann3 — Mon, 03 Jul 2006 07:29:10 GMT

Bernhard,

you can use se93 - report transaction

Andreas

Re: How to create TCode for Sapquery

Former Member — Mon, 03 Jul 2006 07:45:50 GMT

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.

Re: How to create TCode for Sapquery

Former Member — Mon, 03 Jul 2006 08:01:25 GMT

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

Re: How to create TCode for Sapquery

Former Member — Thu, 01 Mar 2007 06:31:44 GMT

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

Re: How to create TCode for Sapquery

Former Member — Thu, 22 Mar 2007 16:43:04 GMT

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

Re: How to create TCode for Sapquery

Former Member — Mon, 24 Sep 2007 14:13:26 GMT

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..

Re: How to create TCode for Sapquery

srikrishna_narasimhan2 — Wed, 13 Feb 2008 12:20:39 GMT

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