Line Manager in SRM

[Former Member]

Hi,

I want to see the list of line managers present in the system.The people with a cap.

Can you help me on this with some table/Report?

Thanks

Rajendra

[Former Member]

You need to understand the Org Structure relationships. Table HRP1001 contains all the required information. There are two fields that you care about: RSIGN and RELAT. RSIGN is either A (bottom-up) or B (top-down). RELAT contains the type of the relationship. The value you are looking for is '012' (manages or is-managed-by depending on whether it is top-down or bottom-up).

So, first find all positions that manage all the different org units. This means something like:

  SELECT objid "this is the position number in this case
    FROM hrp1001
    INTO   TABLE lt_pos_id
    WHERE otype = 'S'
    AND      plvar = '01' "make sure this is the actual plan version in your system
    AND      rsign = 'A'
    AND      relat = '012'.

Then, once you find these, do a similar SELECT statement looking for otype = 'S' (the positions you just read), objid = <the list of positions itself>, relat = '008' (holder), and SCLAS = 'P'. The person numbers will be in SOBID field.

[poovancheerirajendra]

Dear

If you are following any standard procedure like possition name is starting with Manager or MXX (Object Abbreviation & Object name) in Org Structure you can get the list with search option (Find by) under possition in PPOMA_BBP.

Thanks & Regards

Rajendran