program for SAP query

Former Member — Mon, 02 Jul 2007 06:39:54 GMT

hi experts,

I have created a SAP query in sq03.Now i have to create a tcode for it.where shall i get the program name and screen name for it .when i enter the tcode it has to go to the selection screen of my SAP query.

Re: program for SAP query

Former Member — Mon, 02 Jul 2007 06:46:46 GMT

To create a TCODE for Query

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.

<b>Reward points for useful Answers</b>

Regards

Anji

topic Re: program for SAP query in Application Development and Automation Discussions

program for SAP query

Re: program for SAP query