Plant wise users list

[Former Member]

Hi,

Is there any possibility to get the list of users by plant wise?

Thanks & Regards,

KKRao.

[Former Member]

What have you tried so far?

Cheers,

Julius

[Former Member]

Hi Julius,

I have checked the tables AGR_1252 and AGR_USERS and doing excel method.

Is there any other possibility for this? Please advice.

Thanks & Regards,

KKRao.

[morten_nielsen]

Hi

There are no Plant field allocated directly to your UMR, so based on that, no it's not possible.

On the other hand, depending on your data, you might be able to deduct the Plant information:

1. If you have created and assigned a Company pr plant you can of c orse use that

2. If you have maintained the users parameter ID you can use that (PARID = WRK)

3. You can merge AGR_USER with AGR_1252(with VARBL = $WERK)

This will however not give an accurate picture.

If you have HR inplace you might be able to deduct from There. The connection between the user ID and the HR Data can be found in infotype 0105 subtype 0001 (table PA0105). and from there you might, if you are lucky, be able to extract the allocated plant

Regards

Morten Nielsen

[Former Member]

Hello,

SUIM is the best method to do so. SUIM --> USERS --> USERS by complex selection criteria

Under which you can find an option called "selection by field name".

Enter WERKS (plant) and name of the plant you want to find.

Regards,

Gowrinadh

[Former Member]

Chances are good this will list all users who are able to order stationary or lunch vouchers etc...

For a "simple list by plant" I would probably use the address data (telephone number, building, location, etc) to find out who is where, or am I reading the broad question too narrowly?

Cheers,

Julius

[Former Member]

If its general question like, I use what Julius suggested.

Also, having user id's by location name like XXXGowri. where as XXX is the country code. It can be two or three characters. If not such a location is used, then use user groups.

Regards,

Gowrinadh

[arpan_paik]

This kind of request is vague. Though this is often asked by business users. From location/department point of view we should rely on user address data if it is maintained in user master record.

From authorization point of view it will better to say for what transaction or report user have access to specific plant. However that also depends that the transaction/report should have plant as authorization checking. Then through suitable object (from SU24/USOBT_C) we can figure out to which plant a certain user have access.

[Former Member]

USR21 u get person number & address number

go to adrp table u get person details &

T001W in u get plant and address number using address number u get which person in which plant & which person is available in plant user details thorough adrp

use 3 query for reporting...

[Former Member]

In SRM,

Run T-code Zattribute--> put attribute (WRK) for plant and value -->1449 (plant Number)

we get the user list which have access to specific plant ,you can export from the user list in Excel

if you want to have the user list for specific Roles in that plant:

Run T-code SUIM--> users---> By Complex selection ---> put the user list from above and Specific role in the user & Role field and execute..you will get the desired result.