05-23-2006 6:04 AM
Dear All,
Could someone tell me the steps to create a transaction for a query?
Thanks,
DM
05-23-2006 6:06 AM
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.
05-23-2006 6:06 AM
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.
05-23-2006 6:25 AM
Hi,
Thank you very much for the answers, much appreciated. One more question....how can the generated program name change? When I was going through that option.....it make me wonder.
Cheers,
DM
05-23-2006 6:27 AM
Don't bother answering that question. I got it.....it's coz the query can change and we might have to regenerate the program. Am I right?
05-23-2006 6:17 AM
HI
GOOD
GO THROUGH THESE LINKS
http://www.sappoint.com/abap/ab4query.pdf
http://www.howforge.com/how-to-create-user-groups-for-abap-4-query
THANKS
MRUTYUN