Get plant using Organizational Unit or User ID

[laurent_burtaire]

Hello everybody,

Does anyone have an idea (use tables, functional modules, etc.)on how to get plant from an Organizationl Unit ID or a user ID ?

The aim is to have a final file in which for each user, we will have the plant to which is linked (by the organizational unit he belongs to).

If the need can can solve by any other solution, i wait for your suggestion.

Regards.

Laurent.

[Former Member · Accepted solution]

Hi. The function is the best way, but you can get it from tables HRT5502 and HRP5502.

It stores the plants business patrner, to find the actual plant code use table BBP_LOCMAP.

Regards,

Dave.

[laurent_burtaire · Accepted solution]

Hello,

Thank you Disha for your answer: it was very helpful.

Nevertheless, with tables given by David, it was possible for me to do a query in order to get data in a mass way.

Regards.

Laurent.

[Former Member]

Hi,

You can use the FM "BBP_READ_ATTRIBUTES" to fetch the plant details for a user.

Pass the user name and the attribute value(WRK for plant) and in import parameters IV_USER and IV_ATTR_SINGLE resp.In the exp parameter ET_ATTR,you will get the plant value .

BR,

Disha.

DO reward points for useful answers.