SoD Analysis , tables to relate roles, transactions and auth objects

[Former Member]

Hi everyone,

I am analyzing my company SAP roles in terms of segregation of duties, however I having a problem.

I need a table/report to give me for each role, every transactions and for each transaction in the role every authorization objects.

For example I want to know for Role B that have transaction C which have the follow authorization object D with values X and Y.

Therefore I want to know for each role and respective transactions which are only display or/and execute or/and editable. How can I do that?

Thanks!

[koehntopp]

Have a look at AGR_1251

Frank.

[Former Member]

Thanks I will try that

[Former Member]

or use SUIM

[Former Member]

Hi,

There is no default report/table which gives you the required information. However, you can achieve this by using SQVI. Join the tables, and create a tcode for the same. Refer the below link:

Alternatively, you can download all the data into spreadsheet and create Pivots to plot the information.

The other alternative is to have a custom program built which takes the information from AGR_DEFINE, AGR_AGRS, AGR_1251, AGR_1252, AGR_TCODE tables.

Hope this helps!!

Regards,

Raghu