Application Development Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Showing results for 
Search instead for 
Did you mean: 

program for SAP query

Former Member
0 Kudos

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.

1 REPLY 1

Former Member
0 Kudos

Hi

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