topic Regarding ABAP Query authorization group in Application Development and Automation Discussions

Regarding ABAP Query authorization group

Former Member — Mon, 17 Oct 2011 11:15:03 GMT

Hi Team,

This is regarding ABAP Query!

I have created one authorization group, for testing i have assigned my id in authorization group.

After creation of ABAP query,standard program got generated. Now i have created one transaction code at the last for the ABAP Query.

Now the isse is even though i have deleted my id from the authorization group. I am able to execute the query from SQ01 and with the Transaction code .

It should not happen...i want who soever id is mapped to the transaction code ...that member should only be able to run that query, otherwise there is no use of authorization group.

Please help me out in this case.

Thanks & Regards,

Anil Kumar Sahni

Re: Regarding ABAP Query authorization group

arseni_gallardo — Mon, 17 Oct 2011 16:22:36 GMT

Are you sure that you don't have access to that authorisation group? Execute report RSUSR002. In the 'Authorization Object 1' block inform S_TABU_DIS in 'Auth.Object' and accept. Then inform Activity=03 and Auth.Gruop= your group.

You will get a list of all the users which, theoretically, will be able to execute the query. If you press 'Roles' or 'Profiles' in the toolbar of the listing you will get to know why you have authorisation. May be you have the SAP_ALL profile.

Also, one more thing to take into account: how have you created your transaction? Is it referring directly to the generated report? Then it is an error, you should execute program SAP_QUERY_CALL. Read this post: [;

Re: Regarding ABAP Query authorization group

Former Member — Thu, 27 Oct 2011 14:14:41 GMT

Thanks for sharing How to create the correct Transaction Code for Query!