weekly Overtime issue

[Former Member]

Hi Expert,

issue is based  on overtime on weekly basis , if exceed more than 40 hours overtime wagetype has to be created , am using +ve TM.

here is the Pcr which calculate overtime wagetype

even if there is no overtime in a particular week zl table is showing as below

11th of aug employee has taken 2 hours overtime

ZL table

DWS is 8 hours and zl table showing everyday as 8 hours as overtime , how do i resolve this issue

looking forward for your suggestions

Regards,

Bhama

[Former Member · Accepted solution]

Hi sankar,

changed the PCR as above but the its not processing correctly

TES

Saldo

its showing as -ve value..

[Sanky · Accepted solution]

Hi Bhama,

Go through my document which i have already shared and  will give you an idea step by step. Please check once again which will clear your doubt through below steps which i have modified for you in my document.

9996-Will store the difference of 9997 & 9998

9997- Storing Planned Working time

9998- Storing Actual Working time

For this I have written below  PCR and kindly find the four below PCR details.

1. Storing Planned working time daily.

Suppose your planned working hours is 8.5 then 8.5 will be added to Ttyp 9997 and at the same cumulating in the SALDO table of Ttyp9997 as a monthly balance which we will as the weekend for weekly purpose.Every day planned working time will add to time type and cumulate upto Weekday=7.

2. Storing Actual working time.

Same like planned working time type actual working hours will also be adding to Ttyp9998 and Every day actual working time will add to time type and cumulate upto Weekday=7.

Now we have to place this above pcr in schema. We will place this two pcr just after the P2011 function in time schema.

3. In this PCR i will check the current day is Weekday=7 or not?

4. Update Overtime with time type.

ZOTC

*

  ****

        HRS=M9998

        HRS-M9997

        ADDDB9996

        HRS?0

             *

               HRS=0

               ADDMB9997Z

               ADDMB9998Z

               ADDDB9996Z

             >

                HRS=D9996

                ADDZL 9999   (Here 9999 is the time wage type which will be carrying OT no of hours)

                HRS=0

                ADDMB9997Z

               ADDMB9998Z

               ADDDB9996Z

Above PCR placing in schema.

Now testing:-

Planned working time 8.5 hours(09:00 am to 17:30pm) and employess has worked daily 9 am to 19:00 pm and where sunday os weekly off.

From 1st Sept2014 to 07th Sept 2014 employee's total working hours (6*10)= 60 hours and total Planned working hours for week (6*8.5)=51 hours. So 9.5 hours will be moved to WT9999.

Check and let me know.

Regards,

Sankarsan

[Former Member]

Please find the screen short

[Former Member]

i made the changes as above still its not working, overtime pcr is not processing

[Sanky]

Hi Bhama,

Check the PCR ZWEK is processing. Share the Schema and PCR details.

It's working fine in my system.

Regards,

Sankarsan

[Former Member]

Hi sankar

i tried out above link but zl table is not showing any data..

PWTD is planned working time

AWTH- actual time

STDF- difference b/w pwd and awth

please do let me know how do i go about 

[Sanky]

Hi Bhama,

Your OT PCR is wrong.

There should be like

HRS=MAWTH

HRS-MPWTD

Check and let me know.

Regards,

Sankarsan

[Sanky]

Hi,

What is ZH02 day time type. What's storing on day basis. You have to design your pcr like above mentioned doc

1st you have to query that week has start and week end and during that period compare with actual working hours and planned working hours

Check and tell me.

Regards,

Sankarsan

[Former Member]

Hi sankar,

i have already query the pcr for looking for 1st day of the week

ZH02 is weekly hour and ZH01 is daily hour

[Sanky]

Hi Bhama,

Check the below link document which will give you an idea.

http://scn.sap.com/docs/DOC-58739