Authorization in standard adhoc query.

[Former Member]

Hi ,

We have the standard adhoc query called s_ph0_48000510. There are two custom infosets in them and one of them has a query which is required in our monthly payroll activities. However the transaction s_ph0_48000510 cannot be given to the user. I am now left with the option to give access to the user to execute only that particular query. Is it possible to copy this query to a Z transaction? If so, how?

[paul_davidson]

Hi Anita,

Couple of possible solutions -

First possible solution, you could create a User Group (SQ03) and assign the Payroll User to it and assign only the Payroll infoset.  Thus, the user could be given access to the Ad Hoc transaction but could only run queries against that one infoset.  Also, remember, the person cannot run queries containing any field from an infotype for which the individual does not have atleast "display" access already.

Second solution - all Ad Hoc Queries are ABAP reports and can be given transaction codes via SE80.  Security can then assign the transaction to the person via PFCG.  After saving your query in Ad Hoc, go to SQ01and select your infogroup in the standard area.  Look for your query, highlight it and go to Query --> More Functions --> Display Report Name to see the program name for the query.  Copy the name and then go to SE80 and enter it as the Program name.  Highlight the name and right click and select Create --> Transaction.  You may need an ABAPer with a developer key to do this.  Once you have the transaction set, Security can add it to a role assigned to the user.

So several ways to resolve your issue.

Paul

[Former Member]

Take the Program name of Query & in se93 add program & assign z name as your tcode.

[former_member184702]

Hi Anita,

Please find the below link.

http://scn.sap.com/docs/DOC-35463

http://scn.sap.com/community/erp/hcm/blog/2008/06/16/sap-adhoc-query-sq01-sq02-sq03

Thanks

Siva