topic Re: Role, Transaction Assignment & TCode text Table or Report in Application Development and Automation Discussions

Role, Transaction Assignment & TCode text Table or Report

Former Member — Thu, 28 Jun 2007 21:24:44 GMT

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

Re: Role, Transaction Assignment & TCode text Table or Report

Former Member — Thu, 28 Jun 2007 21:34:57 GMT

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

Re: Role, Transaction Assignment & TCode text Table or Report

Former Member — Fri, 29 Jun 2007 05:20:46 GMT

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...

Re: Role, Transaction Assignment & TCode text Table or Report

Former Member — Fri, 29 Jun 2007 17:09:38 GMT

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

Re: Role, Transaction Assignment & TCode text Table or Report

Former Member — Fri, 29 Jun 2007 17:25:24 GMT

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

Re: Role, Transaction Assignment & TCode text Table or Report

Former Member — Fri, 29 Jun 2007 19:45:45 GMT

Thanks Ben, It did help.

Re: Role, Transaction Assignment & TCode text Table or Report

Former Member — Fri, 29 Jun 2007 19:49:42 GMT

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