topic Re: Get Authorization Object and Tcode in Application Development and Automation Discussions https://community.sap.com/t5/application-development-and-automation-discussions/get-authorization-object-and-tcode/m-p/5522105#M1262052 <HTML><HEAD></HEAD><BODY><P>Hi, </P><P></P><P>From TSTCT We get TCode Description</P><P></P><P>but it is not possible to join with AGR_USERS and AGR_1251 in SQVI</P><P></P><P></P><P>Regards</P><P></P><P>Nausal</P></BODY></HTML> Thu, 16 Apr 2009 09:27:22 GMT Former Member 2009-04-16T09:27:22Z Get Authorization Object and Tcode https://community.sap.com/t5/application-development-and-automation-discussions/get-authorization-object-and-tcode/m-p/5522102#M1262049 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>I have a requirement to get a report of </P><P></P><P>Role Name, Date of Validity, Authorization Object in User Master Maintance (TCode) and Description of Tcode</P><P></P><P>I used SQVI</P><P></P><P>and joined Tables</P><P></P><P>AGR_USERS, AGR_1251, USTSTCAP</P><P></P><P>From the first two tables I get all most all fields Except the description of T-Code for that I used the table USTSTCAP but it is not working. </P><P></P><P>is there any table to get text description. please give guidence</P><P></P><P>Regards</P><P></P><P>Nausal</P></BODY></HTML> Thu, 16 Apr 2009 09:14:55 GMT https://community.sap.com/t5/application-development-and-automation-discussions/get-authorization-object-and-tcode/m-p/5522102#M1262049 Former Member 2009-04-16T09:14:55Z Re: Get Authorization Object and Tcode https://community.sap.com/t5/application-development-and-automation-discussions/get-authorization-object-and-tcode/m-p/5522103#M1262050 <HTML><HEAD></HEAD><BODY><P>Hi Use TSTCT to get transaction texts.</P></BODY></HTML> Thu, 16 Apr 2009 09:18:11 GMT https://community.sap.com/t5/application-development-and-automation-discussions/get-authorization-object-and-tcode/m-p/5522103#M1262050 Former Member 2009-04-16T09:18:11Z Re: Get Authorization Object and Tcode https://community.sap.com/t5/application-development-and-automation-discussions/get-authorization-object-and-tcode/m-p/5522104#M1262051 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>Tcode description can be retrieved from table <STRONG>TSTCT</STRONG></P><P></P><P>Cheers,</P><P>Aditya</P></BODY></HTML> Thu, 16 Apr 2009 09:18:50 GMT https://community.sap.com/t5/application-development-and-automation-discussions/get-authorization-object-and-tcode/m-p/5522104#M1262051 Former Member 2009-04-16T09:18:50Z Re: Get Authorization Object and Tcode https://community.sap.com/t5/application-development-and-automation-discussions/get-authorization-object-and-tcode/m-p/5522105#M1262052 <HTML><HEAD></HEAD><BODY><P>Hi, </P><P></P><P>From TSTCT We get TCode Description</P><P></P><P>but it is not possible to join with AGR_USERS and AGR_1251 in SQVI</P><P></P><P></P><P>Regards</P><P></P><P>Nausal</P></BODY></HTML> Thu, 16 Apr 2009 09:27:22 GMT https://community.sap.com/t5/application-development-and-automation-discussions/get-authorization-object-and-tcode/m-p/5522105#M1262052 Former Member 2009-04-16T09:27:22Z Re: Get Authorization Object and Tcode https://community.sap.com/t5/application-development-and-automation-discussions/get-authorization-object-and-tcode/m-p/5522106#M1262053 <HTML><HEAD></HEAD><BODY><P>Thanks to all</P></BODY></HTML> Tue, 09 Jun 2009 11:30:56 GMT https://community.sap.com/t5/application-development-and-automation-discussions/get-authorization-object-and-tcode/m-p/5522106#M1262053 Former Member 2009-06-09T11:30:56Z