12-10-2013 2:37 PM
Hi all,
i want to know which user belong to which company code.Which table i should use?
I have a list of users name with me.
Help me.
Thanks & Regards
Munu
12-10-2013 2:38 PM
Hi,
there is no table for this (I don't speak about HR)
you will have maybe to check authorization
regards
Fred
12-10-2013 2:38 PM
Hi,
there is no table for this (I don't speak about HR)
you will have maybe to check authorization
regards
Fred
12-10-2013 2:44 PM
I agree Fred, but even with authoristion there is the potential to 'belong' to multiple Company Codes, or within certain module not have Company Code authorisation at all.
The problem is that (as you say, outside of HR) the concept of a user belonging to a company code does not exist in the system.
Regards,
Nick
12-10-2013 3:10 PM
Hi,
Please check if function BAPI_USER_GET_DETAIL may be useful for you.
Regards,
Boris
12-11-2013 4:34 AM
12-11-2013 6:56 AM
Hi,
User means which task you are using .
SU01D ,User display . we wont get there user company code. there is no table to get these
combination.
Check users implies as cusotmer , vendor ...in our data.
let me know if im wrong...
thanks.
12-11-2013 8:32 AM
The "company code" displayed with SU01/SU01D is only a (list of) address, so wont be of much help if there is no strict rule to create those address.
Else you could check with HR Infotype 105 or similar Infortype to link user id (check with functional) and then Infotype 001 to get company code.
Regards,
Raymond
12-11-2013 9:03 AM
Hi Munu,
You may get Personal number with USR21 if maintained. And with Personal number you can get company code from table PA0001.
Thanks,
Chirdip
12-13-2013 9:41 AM
Hi All,
Thanks for all your replies.
Actually I have a list of user (usr02-bname) and i have to display that this users belong to this company code(s).
For that how to connect this two.
If we can achieve this by authorization/roles, then how?
Help me.
12-13-2013 10:40 AM
You should start asking BC and HR team for the procedure used in creation of users/employee, that would give you the hints required, this can vary from company to company, so no "absolute" answer.
Regards,
Raymond
12-13-2013 9:14 PM
Hi
Can you please check the tables USRM1, USRMM
These tables have Userid and Company code relations..
Or
From PA0001 table and you can find the Personnel numbers (Pernr) by company code. From the Pernr you can find the user id from infotype PA0105.
PS: (From USRM1 table .... you can get atleast plant (werks) of the User.. From plant you can get the company code)
Regards,
Venkat