Skip to Content
author's profile photo Former Member
Former Member

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

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!

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

3 Answers

  • author's profile photo Former Member
    Former Member
    Posted on Oct 13, 2010 at 03:38 AM

    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:

    sap-query-in-sqvi-transaction

    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

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Oct 13, 2010 at 05:41 AM

    or use SUIM

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Oct 13, 2010 at 06:49 AM

    Have a look at AGR_1251

    Frank.

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.