- SAP Community
- Groups
- Interest Groups
- Application Development
- Discussions
- SAP Query SQ01 restriction at Plant level
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
SAP Query SQ01 restriction at Plant level
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
08-16-2011 12:10 PM
Hello All,
Is possible to restrict SAP SQ01 Query report at Plant level? I mean if it can be restricted through Auth object at Role level?
- SAP Managed Tags:
- Security
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
08-16-2011 12:51 PM
I think query can be restricted by user group level (SQ03/02?). And there can have a suitable naming for groups by plant name. Am I too blunt? Just a thought.
Regards,
Arpan Paik
- SAP Managed Tags:
- Security
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
08-16-2011 12:32 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
08-16-2011 1:16 PM
Thanks Alex.As we have lot of queries and User groups available in system so it can be large development that's the reason i am looking if we can restrict it through Security level rather than huge development.
- SAP Managed Tags:
- Security
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
08-16-2011 12:51 PM
I think query can be restricted by user group level (SQ03/02?). And there can have a suitable naming for groups by plant name. Am I too blunt? Just a thought.
Regards,
Arpan Paik
- SAP Managed Tags:
- Security
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
08-16-2011 1:26 PM
That works, you can hard code the data selection parameters & apportion queries that way. Is OK as long as people can't change the queries.....
- SAP Managed Tags:
- Security
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
08-16-2011 1:35 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
08-16-2011 1:53 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
08-16-2011 2:37 PM
About this one "That works, you can hard code the data selection parameters & apportion queries that way. Is OK as long as people can't change the queries."
- SAP Managed Tags:
- Security
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
08-16-2011 3:36 PM
Hi,
OK, when a query is created you can hard code selection parameters into the query itself (i.e. default in the company code). That way you have have queries:
ZQ_SHIP_LIST_1000
ZQ_SHIP_LIST_2000
ZQ_SHIP_LIST_3000
Where the 1000, 2000, 3000 represents a data element by which you are separating them.
As Arpan mentioned you could tie this in with your user group policy to make sure users in certain groups (e.g. arranged by plant) are only allocated queries for their respective area.
A downside of this is that you will potentially have a lot more queries. Depending on how your S_QUERY auths are set up, the selection screen entries could be modified.
Ultimately both methods are a faff and my POV is that if you want to report on business data then it's best to code reports from scratch (including the required auth checks) or use something like BW with restrictions tied to the data model.
- SAP Managed Tags:
- Security
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
08-16-2011 3:40 PM
