Roles with their list of transations

[Former Member]

Hello,

Is there a report that I can run that would give me a roles (composite or single) with their list of transations?

I have find the list for 75 roles

Many thanks

[Former Member]

Use the search for the following terms and you will get enough information to work out how to get the information: SUIM, AGR_TCODES, AGR_1252

[jurjen_heeck]

> AGR_1252

That'll be AGR_1251 as AGR_1252 only holds the organizational field values.

cheers

Jurjen

[Former Member]

>

> > AGR_1252
> That'll be AGR_1251 as AGR_1252 only holds the organizational field values.
> 
> cheers
> 
> Jurjen

Thankyou for the correction Heeck You are correct as usual!

[Former Member]

i can not find any useful thread related to my query,

Can any one help me, Is it possible to find the list of Tcodes for selected 75 roles at once.

[jurjen_heeck]

> i can not find any useful thread related to my query,

>

> Can any one help me, Is it possible to find the list of Tcodes for selected 75 roles at once.

Okay, not really a report, but you'll find it in table AGR_1251 with the following selection criteria:

AGR_NAME your 75 roles

OBJECT S_TCODE

DELETED not equal to 'X'

[Former Member]

no output but the error " No table entries found for the specified key"

[jurjen_heeck]

And if you try it without the DELETED selection criterium?

[Former Member]

Still the same error

[jurjen_heeck]

Ah, wait!

The solution I gave only works for single roles, so if you've entered composites you'll be left blank.

You can try table AGR_TCODES instead. This may not return a complete list as the content for authorizatons (AGR_1251) may differ from the menu content (AGR_TCODES). If the composite roles' menus aren't filled properly this method will not work.

For a more reliable result sit with someone who knows how to use SAPquery and join tables AGR_AGRS and AGR_1251 on AGR_AGRS-CHILD_AGR and AGR_1251-AGR_NAME. If you execute that query, filtered on AGR_1251-OBJECT=S_TCODE you should get what you want.

[Former Member]

table AGR_1251 with the following selection criteria:

AGR_NAME your 75 roles

OBJECT S_TCODE

DELETED not equal to 'X'

is the aboev solution a reliable one for single roles?

[jurjen_heeck]

> is the above solution a reliable one for single roles?

Yes, it is.

[Former Member]

>

> i can not find any useful thread related to my query,
> 
> Can any one help me, Is it possible to find the list of Tcodes for selected 75 roles at once.

There was plenty of information there. If you had mentioned that you wanted that information all at once then that changes things. I would add SQVI to your search criteria.

[Former Member]

Hi,

Chkout in Table AGR_TCODES.you willl find all the role along with Tcodes.

Thanks

Ramakrishna.

[Former Member]

AGR_TCODES is limited in that it tells you transactions in the role menu, but not transctions in the S_TCODE object.

[Former Member]

Many thanks for all your helps

My question has been answered