Application Development Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Showing results for 
Search instead for 
Did you mean: 

access to a specific company code and plant

Former Member
0 Kudos

Hi,

I need a report that shows who has access to a specific company code and plant

for example

company code 9500

plant RSH

This should include all transactions that can be performed by each user

with access to the plant and/or company code.

They are looking for an audit report to help them look at possible

segregation of duties issues.

Any help would be appreciated.

Regards

Balaji.P

4 REPLIES 4

Former Member
0 Kudos

There is no standard report that gives this.

Someone with reasonable MS Access skills can create a report based on the following:

Users to Roles: AGR_USERS

Transactions to Roles: AGR_1251 filtered on object S_TCODE

Org Levels for the roles: AGR_1252

It is much harder if you want to list the particular org levels for each transaction rather than at a role level.

Former Member
0 Kudos

Go to se16 -> agr_1252 table

Give the org level codes ($BUKRS for company code, $WERKS for plant) with necessary values and execute.

From there you will get the list of roles that have those accesses.

Now go to suim -> users by complex selection criteria -> By role

Give the list of roles and you will get the list of users having that access.

Hope this helps!

Award points if it helps!

Thanks!

0 Kudos

The advantage of doing this in MSaccss is that with a set of clever queries and a good report it will show all you need by printing a single report.

0 Kudos

Completely Agree!

This can even be done useing MS excel.. by using pivot table!