05-10-2006 11:00 AM
Hi ,
How do I assigne a SAP Query to a transaction ?
Please advise.
Thanks very much.
05-10-2006 11:04 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-10-2006 11:04 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-10-2006 11:37 AM
10-28-2009 1:48 AM
I defined a t-code below. But I met message 'User group ZATH_3 has not yet been saved'. Please let me know your suggestion or solution. Thank you.
T-code:zath_4,
package, $tmp
Transaction: start_report
skip initial screen is checked.
D_SREPOVARI-REPORTTYPE: AQ
D_SREPOVARI-EXTDREPORT: ZATH_1
D_SREPOVARI-REPORT: ZATH_3
10-28-2009 1:53 AM
The root cause is I missed G at the end of the user group as the user group is one global area. So the system gave such message. while I add the G, it is OK. This issue is solved. Thank you.
05-10-2006 11:09 AM
Hai Sandeep
SET PARAMETER ID 'BES' FIELD IT_EKKO-EBELN.
CALL TRANSACTION 'ME23' AND SKIP FIRST SCREEN.
Thanks & regards
Sreenivasulu P
05-10-2006 11:14 AM
Hi,
first generate the program for your Query, then Use the Program name and create the tranaction code from SE93
Regards
vijay
05-10-2006 11:27 AM
HI
GOOD
GO THROUGH THIS LINK I HOPE THIS WILL HELP YOU TO SOLVE YOUR PROBLEM
http://help.sap.com/saphelp_nw04/helpdata/en/7a/ed7a38f7da1404e10000009b38f842/content.htm
http://help.sap.com/saphelp_nw04/helpdata/en/7a/ed7a38f7da1404e10000009b38f842/content.htm
http://www.sappoint.com/abap/ab4query.pdf
THANKS
MRUTYUN
05-10-2006 11:37 AM
Hi Sandip,
Just follow these simle steps:
1. Create a transaction with Parameters.
2. Define Transaction START_REPORT
Select Skip initial Screen
3. Select all options for GUI Support.
4. Define the following three fields:
Screen Field Value
D_SREPOVARI-REPORTTYPE AQ
D_SREPOVARI-REPORT User Group
D_SREPOVARI-EXTDREPORT Query Name
That's it
Regards
Sumit Bhutani
Ps Reward points if helpful
10-10-2019 7:47 AM
D_SREPOVARI-REPORT must have letter 'G' on the 13 position.
i.e. your group name is "MY_GROUP" then
MY_GROUP(4 spaces)G
i.e. your group name is "MY_GROUPLONG" then
MY_GROUPLONGG
Regards