topic Re: Company Code based on User in Application Development and Automation Discussions

Company Code based on User

Former Member — Tue, 10 Dec 2013 14:37:29 GMT

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

Re: Company Code based on User

FredericGirod — Tue, 10 Dec 2013 14:38:40 GMT

Hi,

there is no table for this (I don't speak about HR)

you will have maybe to check authorization

regards

Fred

Re: Company Code based on User

Former Member — Tue, 10 Dec 2013 14:44:16 GMT

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

Re: Company Code based on User

Former Member — Tue, 10 Dec 2013 15:10:15 GMT

Hi,

Please check if function BAPI_USER_GET_DETAIL may be useful for you.

Regards,

Boris

Re: Company Code based on User

rosenberg_eitan — Wed, 11 Dec 2013 04:34:08 GMT

Hi,

Do you mean the export company parameter ?

Regards.

Re: Company Code based on User

Former Member — Wed, 11 Dec 2013 06:56:11 GMT

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.

Re: Company Code based on User

RaymondGiuseppi — Wed, 11 Dec 2013 08:32:49 GMT

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

Re: Company Code based on User

Former Member — Wed, 11 Dec 2013 09:03:52 GMT

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

Re: Company Code based on User

Former Member — Fri, 13 Dec 2013 09:41:18 GMT

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.

Re: Company Code based on User

RaymondGiuseppi — Fri, 13 Dec 2013 10:40:20 GMT

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

Re: Company Code based on User

venkateswaran_k — Fri, 13 Dec 2013 21:14:40 GMT

Can you please check the tables USRM1, USRMM

These tables have Userid and Company code relations..

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