Tables to show users id from the position or the position with the user in SAP HR

[former_member349600]

Hi All,

Is there any table which I can refer if I need to know the user id from the position or position from the user id .

I can still manage to get this information using PA20 or P013 but I can get that information one user at time.Is there any table from where I can get this information.

Please suggest

[Colleen · Accepted solution]

If you are after "User to Person to Position", then PA0001 with PA0105 tables will give you the information

HRP1001 is OM relationships. You can get AG (roles), US (Users) to position, org unit, etc from this table. SOBID field for object type to filter.

However, if the user is assigned to a person which holds a position, you will not see a Position to US relationship. You will see a Position to Person relationship instead.

Enter a Position Id in HRP1001 and whilst you have PP01 or PO13/PO13D open on relationships. You can the have al look at the data and see the relationships.

[Colleen]

your friendly tables are PA0105 and HRP1001

PA0105 to give person to user for subtype 0001 (PA20 data)

then there is HRP10001 that does the OM relationships where you will S (Position) to US (User) if the user is directly assigned to the position (PP01 or PO13, etc data)

[former_member349600]

Does HRP1001 gives that data . I have always used it for the position details purpose . Can you please tell me specifically how HRP1001 can help me the getting the user id from position