cancel
Showing results for 
Search instead for 
Did you mean: 

Work center and personnel number Assignment Table

manoj_kalluri
Explorer
11,039

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

View Entire Topic
peter_atkin
Active Contributor
0 Kudos

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
Active Participant

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
Explorer
0 Kudos
thanks Vineeth, that worked for me!
thiago_valadao
Explorer
0 Kudos
That worked with