07-02-2007 7:39 AM
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.
07-02-2007 7:46 AM
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