cancel
Showing results for 
Search instead for 
Did you mean: 

Daily Work Schedule table

Former Member
0 Kudos

Dear Expert,

I am trying to get the daily work schedule and work break schedule schedule for the employee. I just have the personal number. Anyone know if there is any view or table that listed the employee personal number and the daily work schedule / work break schedule schedule?

If there is no such view, can you let me know which tables should i access in order to obtain the information E.G. Pa0007->???

Thanks.

Regards,

Bryan.

Accepted Solutions (0)

Answers (5)

Answers (5)

nbys
Explorer

Hi Guys,

Recently I faced the same problem. The problem was solved by using FM: CATT_PERSONAL_WORKING_TIMES.

Importing structure contains fields from table t550a (daily work schedule)

CALL FUNCTION 'CATT_PERSONAL_WORKING_TIMES'

    EXPORTING

      pernr         = iv_p2002-pernr

      date          = iv_p2002-begda

    IMPORTING

      r550a         = cs_tazpl

    EXCEPTIONS

      error_occured = 1

      OTHERS        = 2.

With regards,

Nikolay

saravanakumar_mac
Participant
0 Kudos

Dear Ji,

Thank you...

****Calender Days

     CALL FUNCTION 'HR_AUPBS_MONTH_DAY'

       EXPORTING

         BEG_DA     = PN-BEGDA

         END_DA     = PN-ENDDA

       IMPORTING

*       NO_DAY     =

*       NO_MONTH   =

*       NO_YEAR    =

         NO_CAL_DAY = LV_NO_DAYS.

******Calender Days

     LS_OUTPUT-KDAYS = LV_NO_DAYS.

******Payroll Days

     LV_COUNT = 0.

     DO LV_NO_DAYS TIMES.

       LV_DATE = PN-BEGDA + LV_COUNT.

       LV_COUNT = LV_COUNT + 1.

       CALL FUNCTION 'CATT_PERSONAL_WORKING_TIMES'

         EXPORTING

           PERNR         = PERNR-PERNR

           DATE          = LV_DATE

         IMPORTING

           R550A         = LS_R550A

         EXCEPTIONS

           ERROR_OCCURED = 1

           OTHERS        = 2.

       IF SY-SUBRC <> 0.

* Implement suitable error handling here

       ENDIF.

       IF LS_R550A-TPROG NE 'OFF'.

******Payroll Days

         LS_OUTPUT-PDAYS =   LS_OUTPUT-PDAYS + 1.

       ENDIF.

     ENDDO.

former_member193652
Active Contributor
0 Kudos

Dear Bryan,

Take a look at PT63. Hope it helps you.

Cheers,

Omid

Former Member
0 Kudos

Bryan,

After you've looked at Infotype 7, try tables T508A and T550A.

Howard

Former Member
0 Kudos

Hi Bryan,

Unfortunately it is not straight forward in SAP. The sequence of steps is as following

1. Read work schedule rule from PA0007

2. Read daily work schedule from T508A

3. Read breaks from T550A

Cheers!

Former Member
0 Kudos

Hi Semvladigo,

I am not even to get the work schedule rule as it need the ES grouping for time, Holiday Calendar ID, PS grouping for time which cannot be found in the PA0007.

Can you advise on this?

Thanks.

Regards,

Bryan.

Former Member
0 Kudos

If you use unique names of WSR, that shouldn't a problem.

In any case I think standard function module is better solution.

Cheers!

sikindar_a
Active Contributor
0 Kudos

Try

Infotype 0007 in PA30 double Click on the Work schedule ICON later in that Click on DWS you will find Planned working time along with Breaks

Check the structure PSHFT

Former Member
0 Kudos

Hi Sikindar,

Thanks for your reply. The problem is i need to retrieve the value in the program.

Thanks.

Regards,

Bryan

gctl
Contributor
0 Kudos

pls try to use function module HR_GET_PERSONAL_WORK_SCHEDULE or HR_GET_WORKING_TIMES

the function modules will be useful

these can also be retrieved using T-code PT63