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

[Former Member]

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

[Former Member]

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.

[Former Member]

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....

[Former Member]

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

[Former Member]

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