Table to get the details of all transaction codes for which user is authori

[Former Member]

Dear Friends,

My requirement is to prepare a user authorisation matrix report.Can anyone provide me the details of the tables which contain the user value/name and the transaction codes for which he is authorised. As shown below.

User----

---

> T.code

U1----

---

> qm10

U2----

---

> Va01

U3----

---

> IP11,ik01,mb21

etc.,

Expecting experts answer

Regards,

M.M

[GauthamV]

This program will give you all transaction codes for which user is authorised.

RSUSR010

[Former Member]

Hi,

Have a look at the documentation of standard report RSUSR010. Check if it helps. It gives List of transactions that can be started by a user.

Regards

[Former Member]

Dear Friends,

Thank you for mentioning the report name. Actually my requirement is to build a report in BI i.e., all the users in R/3 and their respective authorisation should be reported in BI.

I checked for standard datasource but invain. Hence i have decided to make a report using R/3 tables. hence i had posted this message.

Can you kindly provide me the table details

Regards,

M.M

[GauthamV]

You can use these tables to get transactions for which users are authorised.

AGR_DEFINE

AGR_USERS

AGR_TCODES.

[former_member333737]

Hi,

Check tables:

This program will give you all transaction codes for which user is authorised.

RSUSR010

Some of the tables associated with SAP Authorizations.

TACT        Activities which can be Protected
TACTZ      Valid activities for each authorization object
TSTCA      Values for transaction code authorizations

Regards,

Nikhil.

[Former Member]

Hi,

Can you check this table will hepl you

Tabls name : TSTC.

Regards

Thiru