topic Re: Tcodes description table in Application Development and Automation Discussions

Tcodes description table

Former Member — Wed, 19 Jan 2011 08:00:21 GMT

Hello, I am looking to find the desc of all the tcodes present in a single role. Please suggest if there is any table for it. I tried to find through agr_tcodes but it display only the transactions and not the description. Through SE93 this is possible, but have to do individually for every transaction.

Please suggest if any single table from where to see the transactions and the desc for any particular role.

Sameer.

Re: Tcodes description table

Former Member — Wed, 19 Jan 2011 08:06:02 GMT

You can use TSTCT to find the tcode description but not specific to a role. You may get all tcodes added in role menu/manually added S_TCODE from Tables AGR_TCODES/AGR_1251 and plugin to TSTCT to get description of the tcode.

I am wondering if you have tried to google it or even simply look up in SE16 to identify the table

Thanks

Sandipan

Re: Tcodes description table

Former Member — Wed, 19 Jan 2011 08:16:24 GMT

If VIRSA tool 4.0 is installed you can use the transaction code /VIRSA/ZVRMT_U06 - List roles and transactions

Re: Tcodes description table

Former Member — Wed, 19 Jan 2011 08:43:41 GMT

Sandipan, I already tried TSTCT table, but the problem is it displays all the transaction, not specific to any role. I understand that the 2 tables have to be combined to get the required output. But this is where i am struggling how to do it. I believe this required more of a excel skills rather than SAP.

Re: Tcodes description table

Former Member — Wed, 19 Jan 2011 08:54:31 GMT

Hi Sameer,

You could try combining the tables in SQVI transaction and obtaining an output as per your specifications.

No need to use excel when you can create a query in SAP.

Re: Tcodes description table

Former Member — Wed, 19 Jan 2011 09:29:32 GMT

Salaam Sameer

I am sorry if i did not comprehend your requirment correctly but to get the description of each transaction code in a specific role try using:

suim->Roles->By Role Name->select 'single role' check box->enter your role->execute->in the next screen highlight your role and select 'Transaction Assignment' tab on the top.

This Should provide you the description of the transacton code text.

Regards

Imran.

Re: Tcodes description table

Former Member — Wed, 19 Jan 2011 09:52:38 GMT

Imran....that was the easiest way to do it. It worked.

I was looking after all the agr* tables and found the answer here. I know there will be a way to join the tables through SQVI as mentioned earlier and have to learn that to be useful in future. But for now your suggestion worked.

Thanks all.

Re: Tcodes description table

Former Member — Wed, 19 Jan 2011 10:09:25 GMT

Hi Sameer,

You can use AGR_HIER tabke.

Enter role names in field AGR_NAME and execute. You will get a field named "TEXT". That's what you are looking for.

Regard,

Mohit

Re: Tcodes description table

Former Member — Wed, 19 Jan 2011 10:51:41 GMT

Mohit,

Table AGR_HIER also provides the transaction desc as required, but i found that if the transactions exist more than once due to SAP menu structure, it gets repeated in table. This will again be required to removed. Also I found lot of entries with blank spaces in report/transaction column due to which the total transaction list increased by 100 transactions more than the original list. I still think the suggestion provided by Imran is the easiest to follow. Thanks for your reply.

Re: Tcodes description table

Former Member — Wed, 19 Jan 2011 11:02:06 GMT

Hi Sameer,

Ofcourse Imran's solution is best if your requirement is to check transaction text for single role.

If you want the list for more than one Tcode then that will not work. In that case using tables AGR_TCODES + TSTCT or AGR_HIER are the best ways.

Regards,

Mohit

Re: Tcodes description table

Former Member — Wed, 19 Jan 2011 12:47:07 GMT

AGR_TCODES, AGR_HIER, method suggested via SUIM only lists the tcodes added to role menu and doesnot takes into account any manually added S_TCODE values inside the role. Just for your information. To be on the safer side, you may want to look at S_TCODE values from table AGR_1251 as well. You cannot join AGR_1251 and TSTCT in SQVI though since these table have no common key fields

Edited by: Sandipan Choudhury on Jan 19, 2011 6:19 PM

Re: Tcodes description table

Former Member — Wed, 19 Jan 2011 13:16:20 GMT

Hi Sandipan,

Good point. AGR_1251 + TSTCT is the best combination to look for the required information.

I guess VLOOKUP function of excel would be much easier way

Regards,

Mohit

Re: Tcodes description table

Former Member — Wed, 19 Jan 2011 19:33:43 GMT

If I take your post as you want to find all transactions in a SINGLE role and not lots of single roles then SUIM, Transactions, Transactions executable for role would give you the descriptions for transactions that can really be run:

e.g.

AL08 Users Logged On

OADR SAP ArchiveLink: Print list search

OAER SAP ArchiveLink: Document search

OAOR SAP ArchiveLink: Stored documents

OAWD SAP ArchiveLink: Store documents

But only one role at a time or maybe I`ve fallen foul of a playground prank?

Regards

David

Edited by: David Berry on Jan 19, 2011 7:38 PM