11-08-2007 1:22 PM
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
11-08-2007 1:31 PM
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.
11-09-2007 9:22 AM
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!
11-09-2007 9:29 AM
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.
11-09-2007 9:35 AM
Completely Agree!
This can even be done useing MS excel.. by using pivot table!