Application Development Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

tables to find relation between transaction code ,companycode and user name

Former Member

‎04-07-2006 5:32 PM

0 Kudos

Hi

Is there any table to find relation between transaction code ,companycode and user name

Regards

Shiva

3 REPLIES 3

former_member181966
Active Contributor

‎04-07-2006 5:41 PM

0 Kudos

Well I don’t think .. What is the relation ship between this entity .. Company code and user name make sense .!!

You can say in company code , users and the user use transactions .

Then you have to see tables USR02 , TSTC ..

Well . you can also see list of reports in T-code SUIM

Hope this’ll help .. Don’t forget to reward points

Thanks

Message was edited by: Saquib Khan

RichHeilman
Developer Advocate
Developer Advocate
In response to former_member181966

‎04-07-2006 6:11 PM

0 Kudos

There is no direct relation between any of them.

Regards,

RIch Heilman

Former Member

‎04-07-2006 9:11 PM

0 Kudos

Tha way it looks like to me is that he is looking for the authorization values. All the user authorization values are stored in the table UST12. You can get the values of say tcode for which the user is authorized, by calling the function module SUSR_USER_AUTH_FOR_OBJ_GET and passing user name and 'S_TCODE' for 'SEL_OBJECT'.

But for company code, this becomes very complicated because, you may authorized to perform a certain action for a certain company code, in a particular transaction. But for the same company code, in another transaction, you may not be able to do any aciton. You really need to know which authorization object each transaction is checking that has BUKRS as field.

Srinivas