Work center and personnel number Assignment Table

[manoj_kalluri]

Hi Guys

Please tell me the table name to refer the list of persons assigned to a particular work center and one more thing I want to know a particular person assigned to how many work centers. How can i achieve that

[peter_atkin]

See tables HRP1000 and HRP1001.

Also have a look at function module CR_PERSONS_OF_WORKCENTER.

PeteA

[manoj_kalluri]

Hi Peter

Thanks for Reply

I know the above mapping table, in HRP1000, I can find only the Personnel Numbers which are assigned to HRMS link mainly used in WorkCenter Main view, but I can assign the persons to the capacity of Workcenter through Capacity Header. I want those persons assignment/mapping to work center list.

Regards

Manoj

[peter_atkin]

You can use FM HR_PERSON_READ_ASSIGNMENT to find which work centres are assigned to a specific HRMM record.

Populate PERS_TAB_RAN as follows:

• FILGRU = 00
• FELD = PERNR
• SIGN = I
• OPTION = EQ
• LOW = 01024263 (HRMM number)
• HIGH (blank)

.

In the CONNECT_TAB table use the SOBID to link with CRHD-KAPID.

PeteA

[vineeth_varghese]

I thought to add the missing link between SOBID and ARBID, as it might be helpful if someone is looking for same information again.

Pass SOBID value and OTYPE= "LA" (Workcenter Logistics) into Table: HRP1001 and get value of ARBID.

Pass value of ARBID into Table: CRHD to get ARBPL (Workcenter)

Regards

Vineeth

[thiago_valadao]

thanks Vineeth, that worked for me!

[thiago_valadao]

That worked with

[Former Member]

Hi Manoj,

In opinion there wouldn't be any standard table for Personnel no. in respect to work center however you could try to get PENR with respect to cost center.

ie.

CRHD-OBJID = CRCO-OBJID

CRCO-KOSTL = PA0001-KOSTL => PA0001-PERNR

or

PA0001-PERNR

PA0001-KOSTL= CRCO-KOSTL

CRCO-OBJID = CRHD-OBJID ==> CRHD-ARBPL

Regards,

Rajnish

Regards,

Rajnish

[manoj_kalluri]

Hi Rajnish

The Problem is we have one company code, 10 Plants and nearly 20 Maint workcenters to each plant and in each Maint workcenter nearly 200-225 people are assigned to it. If a person is transfering to other Workcenter. I need to go to each workcenter and search for the ID. For me tracking is gettting more difficult.

Regards

Manoj