cancel
Showing results for 
Search instead for 
Did you mean: 

Late coming day's & Late hours calculation

Former Member
0 Kudos

Dear All,

I want to calculate late coming days and late hours for the particular day.

Requirement:-

The planned shift timings is 9:30 - 18:30. If employee Punch IN is after 10:10 (10:11 onward) then it should mark as late come and late hours should be count from planned start time (09:30)

Time Type 9000 = Late hours

Time Type 9001 = Late come day

1. Suppose 1st day punch In 10:30 then


Time Type 9000 = Late hours will be (9:30 - 10:30 = 1 hours)

Time Type 9001 = Late come day will be 1

1. Suppose 1st day  punch In 10:15 then


Time Type 9000 = Late hours will be (9:30 - 10:15 = 0.75 hours)

Time Type 9001 = Late come day will be 1

Best Regards,

Deepak


Accepted Solutions (1)

Accepted Solutions (1)

venkateshorusu
Active Contributor
0 Kudos

Use the operation SNTB to query the planned working time it will work .

Regards

Venkatesh

Former Member

Hi Venkatesh,

Can you tell me where to use SNBT in PCR and how it will work. Pls see my PCR after change.

It is not processing in the evaluation run. Pls see this processing screen shot.

Best Regards,

Deepak

venkateshorusu
Active Contributor
0 Kudos

As communicated earlier use the operation SNTB and change HRS=PBEG instead of PEBG it will work.

Regards

Venkatesh

Former Member
0 Kudos

Dear All,

Sorry all of you. I have wrote mistaken PEBG instead of PBEG.

Yes, now its working but I have one problem i can put only one PCR just after P2011. When I'm putting late coming PCR ZLT2, then its calculating late days and late hours, but its not calculating my daily working hours and shortfall of hours PCR ZFX1 & vice versa.

Pls guide me what needs to be done for getting both the calculation.

Best Regards,

Deepak

venkateshorusu
Active Contributor
0 Kudos

Can you paste your ZFX1 PCR.

Regards

Venkatesh

Former Member

Hi Venkatesh,

Pls see my ZFX1 PCR.

Best Regards,

Deepak

venkateshorusu
Active Contributor
0 Kudos

Can you paste your schema where exactly you placed your PCR's.

Regards

Venkatesh

Former Member

Hi Venkatesh,

Pls see that part of schema where I placed those PCR's.

Best Regards,

Deepak

venkateshorusu
Active Contributor
0 Kudos

Can you check and paste log whether ZFX1 is processing or not.?

Regards

Venkatesh

Former Member

Hi Venkatesh,

If I put PCR ZFX1 after PCR ZLT2 then, It is not processing in the evaluation run. Pls see the ZFX1 processing screen shot.

But ZLT2 is processing.

Pls guide what to do?

Best Regards,

Deepak

venkateshorusu
Active Contributor
0 Kudos

Can you place this PCR after ACTIO TD30 with function RTIP and check whether it is working or not.?

Regards

Venkatesh

Former Member
0 Kudos

Hi Venkatesh,

Its not working that place also.

Best Regards,

Deepak

Sanky
Active Contributor
0 Kudos

Hi Deepak,

Insert PCR after P2002 function.

What's the value of TGMAX?

Regards,

Sankarsan

venkateshorusu
Active Contributor
0 Kudos

When you look at your out put table TIP of ZLT2 PCR it is saying that no entry in table since it is not processing for further try to use the operation COLOP* it may work.

As far i understand the output of one line in schema will become the input of next line, ZLT2 Output(No entry in table) will become Input to ZFX1.

Regards

Venkatesh

Sanky
Active Contributor
0 Kudos

Hi Deepak,

Can you tell me your designed PCR logic.

I have applied the below sample PCR as per your requirement and it's working and what's the TGMAX value?

Sample PCR design,

9.6667 it's 09:40 am. For my case planned working time starts on 9am. Time Type 9998 is late hours and TTy9999 is counting late day's.

Schema Placing:-


Employee has come on 09:41 am.

ZES table result:-

Hope so you are clear and will rethink about your designed PCR.

Regards,

Sankarsan

Former Member
0 Kudos

Hi Sankarsan,

You only given me the solution for my below requirement and as per your suggestion I have maintained TGMAX value as 9 in table V_T511K and inserted PCR ZFX1 just after P2011.

I have applied the PCR ZFX1 for Daily working hours & Shortfall hours just after function P2011, then its working and giving me the Daily working hours & Shortfall hours correctly.

Please see the below link.

Now I want to calculate Late hours & Late coming days, along with Daily working hours & Shortfall hours and its calculating both the things correctly but only one PCR is working at a time.

So as per your suggestion I have written PCR ZLT2 and inserted after function P2011, but my problem start from here. If I have applied the PCR ZFX1 after function P2011 then its not calculating PCR ZLT2 and vise versa.

Please see the ZES table result:-

when I applied ZFX1 just after P2011 as below

Please see the ZES table result:-

when I applied ZFX1 just after P2011 as below

I hope now you will be remembering all the things.

Best Regards,

Deepak

Sanky
Active Contributor
0 Kudos

Hi Deepak,

For your vice versa case. You have to use COLOP* operation in your 1st pcr which you are processing 1st in Schema.

As per your current Schema structure ZLT2 are processing 1st so in the PCR you have to use COLOP* in every resultant stage because in you 2nd pcr is not getting TIP entry in input table and due to this it's not processing further.

Please see the below PCR for your reference.

Hope so you got and understand the error.

Regards,

Sankarsan

venkateshorusu
Active Contributor
0 Kudos

As i communicated When you look at your out put table (TIP) of ZLT2 PCR it is saying that no entry in table since it is not processing for further try to use the operation COLOP* it may work.

As far i understand the output of one line in schema will become the input of next line, ZLT2 Output(No entry in table) will become Input to ZFX1.

Regards

Venkatesh

Former Member
0 Kudos

Hi Sankarsan,

Again many thanks to you. My issue got resolved.

I understood the use of operation COLOP* now.

Best Regards,

Deepak

Former Member
0 Kudos

Hi Vankatesh,

Many thanks to you. My issue got resolved.

I'm closing this issue.

Best Regards,

Deepak

Sanky
Active Contributor
0 Kudos

Good.

Regards,

Sankarsan

Answers (2)

Answers (2)

vianshu
Active Contributor
0 Kudos

Hi Deepak,

Please go through the below document which gives step by step explanation regarding late coming scenario.

Let me know if you require any further information on this.

Thanks and regards,

Vivek Barnwal

Sanky
Active Contributor
0 Kudos


Hi Deepak,

Write the below PCR and use PTIP funtion. Apply this PCR just after P2011 function in time schema.

Regards,

Sankarsan

sai_siva
Active Participant
0 Kudos

hi Deepak,

In addition to the above solution, you can able to pull the report from the PT_ERL00 & RPTBAL00.

Both these report will able to provide information about the late coming hours for that day for the whole group of employees or Personal Area level.

Regards,

Sai

Former Member
0 Kudos

Hi Sankarsan,

It is not working, nothing is coming in ZES table. Please see the processing of the PCR.

Best Regards,

Deepak

Sanky
Active Contributor
0 Kudos

Hi Deepak,

Send me your DWS screenshot.

and Change the PCR littele bit i think HRS-SNTB (i ithink i have given wrong operation).

Check once.

Regards,

Sankarsan

Sanky
Active Contributor
0 Kudos

Hi,

Have you checked?

Regards,

Sankarsan

Former Member
0 Kudos

Hi Sankarsan,

I have checked but its not working.

Best Regards,

Deepak

venkateshorusu
Active Contributor
0 Kudos

As communicated earlier use the operation SNTB and change HRS=PBEG instead of PEBG it will work.

Regards

Venkatesh

Former Member
0 Kudos

Hi Sankarsan,

Can you help me.

What needs to be done for getting both the calculation.

Best Regards,

Deepak