Question Re: Table Name for finding the Manager for a Particular User in Enterprise Resource Planning Q&A

Table Name for finding the Manager for a Particular User

Former Member — Tue, 23 Oct 2007 03:25:32 GMT

Hi,

Is there any table to get the Manager details for a particular User.

Regards,

Ram

Re: Table Name for finding the Manager for a Particular User

kiran_k8 — Tue, 23 Oct 2007 03:28:29 GMT

Ram,

Try all HR related tables HR* in se11.

K.Kiran.

Re: Table Name for finding the Manager for a Particular User

Former Member — Tue, 23 Oct 2007 03:28:43 GMT

which kind of details you want?

check below

T77RCF_MANAGER Managers

T77RCF_MGRASS Manager-Assistant Assignment

T77RCF_MGRTC Manager-Talent Consultant Assignment

FMD1_F15_BEWIRT F15 Interface - Master Data Manager

FMD1_F15_TKZNKR F15 Interface - Number Range for Cash Reference Number

FMD1_F15_FIPO2BW F15 Interface - Commitment Item -> Manager

FMD1_F15 F15 Interface - Documents

CF003 Projects

Rewards if useful..........

Minal Nampalliwar

Re: Table Name for finding the Manager for a Particular User

Former Member — Tue, 23 Oct 2007 03:32:30 GMT

Hi Ram,

The better way is to use FM HR_STRUCTURE_GET.

You can get this detail .

Regards,

Atish

Re: Table Name for finding the Manager for a Particular User

Former Member — Tue, 23 Oct 2007 03:44:31 GMT

Manager in HR is not always stored in its own table. One common way to identify managers is to use relationships in the HR Organisation Structure. In this way a particular position may be identified as the manager for a given organisation unit.

So to find the manager for a user, the steps would be to find the users HR record (PA0105) and identify their position in the organisation structure (PA0001). Then identify which organisation unit the position belongs to (an HRP1001 relationship) and then find the manager (another HRP1001 relationship). Which relationships, etc depend on the setup of HR in your system.

If not using SAP HR, then you may need to maintain data in some custom table to identify managers for users. Possibly this could be done using fields on the user master record, or using a structure like the cost centre hierarchy. A lot depends on what you have available, and how up to date / accurate the data needs to be.

Andrew