Time Eval – calculate consecutive working days via standard accumulate

In the another document Time Eval – calculate consecutive days for absence I have manually accumulated Total Consecutive WORKING Days.

In the document I would like to share how we achieve the same result but using the SAP standard accumulate via configuration in T555A. I believe this one would be much easier that the solution I mentioned in the above document.

I. SOLUTION for WORKING DAY

(1) Time type ZABS: all is 1, so SAP will automatically accumulate via function CUMBT in time schema.

(2) The 1^st pcr: if absence type is 1211, assign 1 into Time Type ZABS

(3) The 2^nd pcr:

    If Time type ZABS = 0 (it means that employee is NOT on leave):

          (i )  Plus with all total consecutive leave until the previous date (HRS+MZABS).

          (ii)  Multiple with (-1) to have negative value

          (iii) Add back value to ZABS

               => with the above step we will CLEAR the standard accumulative in Time Type ZABS.

   If Time type ZABS > 0 (it means employee is on leave).

          (i )  Plus with all total consecutive leave until the previous date (HRS+MZABS).

          (ii)  Comparing with 7

          (iii) If it is bigger than 7, raise information message.

(4) Calling the 2 pcr in time schema:

II.TESTING

TC01:

INPUT: Employee is on-leave from 24.08.2015 to 27.08.2015 and 31.08.2015 to 03.09.2015.

Expected result is that system should NOT raise the information message.

OUTPUT:

System does NOT generate any message anymore because time type ZABS has not reached 7 consecutive days yet.

We can see that system accumulate from 24.08.2015 to 27.08.2015 as 4 days. But Fri 28.08 does NOT have any absence, so system reset the counting and restart again from next Mon on 31.08.2015.

So when checking cumulative value, we can see 1 days for Aug and so far 4 days for Sep:

TC02:

INPUT: Employee is on-leave from 26.08.2015 to 29.08.2015 and 31.08.2015 to 03.09.2015.

Expected result is that system should raise the information message on 03.09.2015

OUTPUT:

System generate message on 03.09.2015

Time type ZABS

Accumulate Time type ZABS

Message:

III. CONCLUSION

With new approach, we are able to achieve same results without requiring manually carry forward value on Fri to the following Mon as I did another document. The key NOTE is that whenever employee is NOT on leave, we have to clear the value ZABS immediately. Therefore on Mon we don’t need to worry whether on the last Fri employee is on leave or not anymore.

Hope now we have many options to handle a specific requirements as well as a chance to deeply understand Time Eval. Thanks.

Best Regards,

Woody