06-28-2007 10:24 PM
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
06-29-2007 6:20 AM
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...
06-28-2007 10:34 PM
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
06-29-2007 6:09 PM
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
06-29-2007 6:25 PM
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
06-29-2007 8:45 PM
06-29-2007 6:20 AM
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...
06-29-2007 8:49 PM
Thanks Manoj, Was getting some runtime errors when I execute the overview status. Ben's post did help. Thanks anyway.