SAP Knowledge Base Article - Public

2561209 - How to calculate Consecutive days in Time Sheet


For Some scenarios you may need to do a special treatment of the overtime if the employee is working for 7 days consecutively.

In such cases for example if employee works from Sunday to Saturday you would like to have the overtime for Saturday calculates as 3.0.



Employee Central 2.0


Reproducing the Issue

  1. go to any employee;
  2. register time sheets for the employee for the whole week (including Sun and Sat);
  3. on the last day of your Time Sheet the overtime should be calculated differently;


Important Note: This is only possible inside the same week, which means that the system won't be able to determine if the employee worked for 7 days consecutively when these days start in a week and ends in another.

In order to achieve this you'll need to:

  1. Count the number of days worked. This can be achieved by using the Valuation Type "Compare Threshold with Input Groups and Count Events", see one example below on how this valuation 


Notes on DAYSWKD valuation:

    • the count event method compares the input with a threshold value or group and will count as 1 event (in the time type group above) whenever that threshold is reached, for example in the threshold value you can define a minimum number of hours to consider that day as a working day. In this example here, whenever the employee records more than one hour, then the day will be counted as a working day;
    • the valuation method here must be valuate per day then it will be able to count 1 event per day of the week; 
    • it is not mandatory to have the time type group as a time collector but the Time Category of this group must be "Counted Events";
    • for more information about this valuation, please refer to Setting Up Time Valuations for Time Collectors;

Refer below to an image for the group 05DAYSWKD in this example:


  1. Filter the hours recorded for the last day of your week (this will depends on how your time sheet week is configured for more info refer to Defining the First Day of the Week), to achieve this you'll need to make use of Time Records Filters, see below how this can be achieved:
    1. Create the Time Record Filter:


    1. Create a valuation to separate only Saturday hours:


Notes on SATVAL valuation:

    • The input group here depends on your scenario, in this case the input group is only the overtimes generated during the week;
    • The value that falls under the filter must be sent to the Time Type Group Below;
  1. Now you need to rout your times recorded on the last day to the time type group you desire, but this must be done only if the employee worked the 7 days of the week, to achieve this you can make use of the valuation type "Compare Threshold with Comparison Group to Route Input", see below one example on how this valuation can be configured:


Notes on OVR3.0 valuation:

    • For this valuation to work you need a comparison group, this comparison group will be the Time Type Group Above of the valuation explained in the first step (DAYSWKD);
    • The input group here depends on your business need, in this example here it would be my filtered Saturday hours (Time Type Group Below of the valuation explained in the second step (SATVAL);
    • Threshold Value was set to 6 this means that whenever I have the 7º day registered, it will then make the route. This is important because if the employee does not work the 7 days but for some reason does an overtime on Saturday, then this special handling should not happen.

By applying the above steps you should be able to make special calculations based on consecutive days.


Timesheet implementation scenario, consecutive days calculation , KBA , LOD-SF-EC-TMS , Time Sheet , How To


SAP SuccessFactors HXM Core all versions