This website is not affiliated with, sponsored by, or approved by SAP AG.

Role/Transaction matrix report

SAP Security

Moderators: Snowy, thx4allthefish, jurjen

Role/Transaction matrix report

Postby dave_c1 » Thu Feb 14, 2013 6:14 pm

Is there any utility program available that can query SAP and produce user friendly reports/spreadsheets of the role to transaction matrix? Also a report on data level restrictions (eg. Org levels) would be nice.

Thanks
dave_c1
 
Posts: 3
Joined: Fri Feb 02, 2007 12:30 am

Re: Role/Transaction matrix report

Postby jurjen » Fri Feb 15, 2013 3:01 am

I am not aware of ready made programs but a lot of VBA code for Excel is available on the web. If you look for VBA scripts using RFC_READ_TABLE you should get some interesting hits. The tables you want to query are: AGR_1251 filtered on S_TCODE for transaction access and AGR_1252 for orglevels.
For transactions there is also table AGR_TCODES but that only reports transactions from the role menu. These values may differ from the actual content of the S_TCODE authorizations.

Hope this helps,

Jurjen
jurjen
 
Posts: 298
Joined: Wed May 17, 2006 8:17 am
Location: The Netherlands


Return to SAP Security

Who is online

Users browsing this forum: No registered users and 6 guests





loading...


This website is not affiliated with, sponsored by, or approved by SAP AG.