topic Re: tables to find relation between transaction code ,companycode and user name in Application Development and Automation Discussions

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

Former Member — Fri, 07 Apr 2006 16:32:01 GMT

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

Regards

Shiva

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

former_member181966 — Fri, 07 Apr 2006 16:41:38 GMT

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

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

RichHeilman — Fri, 07 Apr 2006 17:11:08 GMT

There is no direct relation between any of them.

Regards,

RIch Heilman

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

Former Member — Fri, 07 Apr 2006 20:11:56 GMT

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