how to get one report with t.codes assigned to each role

Question: Hi,

I have to generate a report for finding all t.codes assigned to each of the role. Esp. the roles that we have assigned to users in our environment. I need this as one report.

I can do this individually for each role, but this way I have to work long hours. Is there any better way.

I need better method than the following:

-SUIM
-Role
-Role by complex selection criteria
-at the role field - type in all roles that are used in the environment
-execute
-it displays all roles
-select a role and then click trans. assignment

This way I have to do for each of the role. Which is time consuming.

Is there any better way??

Thanks
_________________
SLS
Better be late than never

Answer:
On roles, take a look at table AGR_TCODES.

Profiles, Take a look at table UST12

Answer:
The following SQL statement will generate the information you need:

SELECT AGR_TEXTS.AGR_NAME, AGR_TEXTS.TEXT, AGR_TCODES.TCODE, TSTCT.TTEXT
FROM AGR_TEXTS, AGR_TCODES, TSTCT
WHERE AGR_TEXTS.MANDT = '' AND
AGR_TEXTS.SPRAS = '' AND
AGR_TEXTS.LINE = 0 AND
AGR_TCODES.MANDT = '000' AND
AGR_TCODES.AGR_NAME = AGR_TEXTS.AGR_NAME AND
TSTCT.SPRSL = '' AND
TSTCT.TCODE = AGR_TCODES.TCODE
ORDER BY AGR_TEXTS.AGR_NAME, AGR_TCODES.TCODE;

Answer:
Try AGR_1251 and limit selection by "settings -> list format -> choose fields and save as ....?...

Answer:
Guest68,

Your method does not provide the role description or the transaction description. Usually the reason this kind of information is needed is so that the functional SAP team members can select specific roles for job titles in the company. They need more information than just the transaction code itself.