topic Re: HR database table--emp code & work schdeule--shift in Application Development and Automation Discussions

HR database table--emp code & work schdeule--shift

Former Member — Fri, 03 Nov 2006 14:14:30 GMT

i want to know the database table which is havin EMPLOYEE CODE & DAILY WORK SCEDULE--SHIFTS.....can any one help me...

Re: HR database table--emp code & work schdeule--shift

Former Member — Fri, 03 Nov 2006 22:27:27 GMT

hi Dheeraj,

tables - PA2003 (OR PA2004) & T550A

The daily work schedule shifts are maintained using infotype 2003/2004; Correspondingly you get thye employee code and daily work schedule shifts from

1.PA2003(SUBSTITUTION)->PERNR (Employee code)

2.PA2004 (AVAILABILITY)

Get MOTPR TPROG VARIA from PA2003/2004 and read table T550A for the daily work schedule shifts.

hope this helps

Sajan.

Re: HR database table--emp code & work schdeule--shift

Former Member — Sat, 04 Nov 2006 06:09:59 GMT

thanyou vry much sajan,

u have solved my problem.

Actually m new for HR module.

Can u tell me the use of these three tables:

T550A

PA2003

PA2004

I have to prepare one project........pl. help me in this..

Thnx ones again....

Re: HR database table--emp code & work schdeule--shift

Former Member — Sun, 05 Nov 2006 11:55:25 GMT

Look for PA0007 & T508A to know work schedule ****.

Re: HR database table--emp code & work schdeule--shift

Former Member — Sun, 05 Nov 2006 12:05:14 GMT

Its mainly used for Employee's time record from pa2001 to pa2007, pa2010, pa2012 & pa2013.