Role, Transaction Assignment & TCode text Table or Report

[Former Member]

Is there any Report or Table which can give me all the z roles in the system and their corresponding TCode assignment with the TCode descriptions.

Thanks

[Former Member]

write a query to connect table AGR_TCODES to TSTCT

there are some reports under transaction SUIM as well, but they don't have everything in one report

cheers,

Ben

[Former Member]

Thanks for he helpful reply. I have'nt effectively used it the way you intended ... I did not use the query linking. How do I write the query (SQVI?) and how do I get a ALV with only Role name, Tcodes & their descrptions in them. Thanks

[Former Member]

Prashanth,

Creating SAP queries is an involved process. Take a look at some of the tutorials and other info on the net.

http://www.thespot4sap.com/Articles/SAP_ABAP_Queries_Create_The_Query.asp

http://www.saptechnical.com/Tutorials/SAPQuery/SimpleQuery/SQ1.htm

However, neither of the tutorials looked particularly good to me.

Cheers,

Ben

[Former Member]

Thanks Ben, It did help.

[Former Member]

Hi prashanth,

Get into transaction pfcg and go to utilities-overview status..Execute it u will be getting all the roles in the system and transaction code and the users too..

Reward if it's useful..

Reg'

Zeemaaaaa...

[Former Member]

Thanks Manoj, Was getting some runtime errors when I execute the overview status. Ben's post did help. Thanks anyway.