relation between PERNR and ARBPL

[Former Member]

please tell me if i can maintain any relationship between PERNR and ARBPL. I need to develop a report in which i've to calculate the employee efficiency .

selection-screen field : PERNR.

output fields:

header: pernr

items: arbpl , aufnr , confirmed qty ,

i am confirming the production order in [CO11N].

i am fetching workcenter (arbpl) , production order ( aufnr) from table AFRU, but i am unable to find any relation b/w ARBPL and PERNR.

please help me out.

thanks,

Sid

Edited by: Siddhartha Prakash on Sep 13, 2008 2:57 PM

[Former Member]

Hi,

Do the following way.

GOTO SE85

Click on ABAP Dictionary Tree and then Click on Fields Tree and there after you can enter table field name and press F8, it will give the name of all tables corresponding to the field you entered.

[Former Member]

PERNR is already there in AFRU , what are you searching for.

using ARBID get the ARBPL from CRHD table, AUFNR and PERNR is already there in AFRU table.

[Former Member]

thanks for your reply,but i have already done this, i was trying to get a direct relation b/w pernr and workcenter.

that is possible , but HR module has to be their.

anyway thanks a lot.

[Former Member]

may be you can find some information in infotype 0001. there you have werks and costcenter from there you can derive the workcenter. you can check the Table CRCO

Edited by: Vijay Babu Dudla on Sep 14, 2008 7:51 AM