User Assigned to Org.unit

[Former Member]

Hi all...

I have list of user ..i want to find these users assigned to org.unit ?

i need the list in production.. so i can't write the code...

how can i find? any view or direct table which will list these stuff..

thanks...

[former_member1146130 · Accepted solution]

Hi

You can use table BUT050 (BP relationships/role definitions: General data)

Here enter RELTYP as BUR010 and get the list.

In this PARTNER1 is BP of Department & PARTNER2 is BP of User

Later you can get detials of both the BPs from table BUT000 (BP: General data )

Regards

Madhuvanti

[laurent_burtaire]

Hello,

Use HRP1001 table:

SELECT objid FROM hrp1001 WHERE sobid = 'user ID' AND plvar = 'active PLVAR'

SELECT sobid FROM hrp1001 WHERE objid = objid

SELECT sobid FROM hrp1001 WHERE otype = 'S' AND objid = sobid AND sclas = 'O'.

Regards.

Laurent.

[Former Member]

HI...

Is there any other way.. beacuse i can't write coding bcz its Production Server....

Help me on this...