3777101 - How to Round the Start or End Time of External Time Data to the Work Schedule Time

This KBA explains how to round the start and/or end time of imported External Time Data to the corresponding work schedule time when it falls within a specified interval. ''Image/data in this KBA is from SAP internal systems, sample data, or demo systems. Any resemblance to real data is purely coincidental.'' 

• SAP SuccessFactors HCM Suite
• SAP SuccessFactors Employee Central - Time Sheet
• SAP SuccessFactors Time Tracking

This KBA provides sample business rule configurations for reference only. The configuration should be adjusted to meet specific business requirements. 

The following example demonstrates how to round the start time of External Time Data to the employee's work schedule start time when the imported start time falls within 15 minutes before or after the scheduled start time.

1. Create an MDF Business Rule with the base object External Time Data and set the rule purpose to Evaluate.
   

2. In the IF section, use the rule function 'Calculate Duration in Seconds Between Two DateTime Values()' to calculate the time difference between the imported start time and the work schedule start time.

   • Set First DateTime to Get Start Time of Working Days().

   • Set Second DateTime to External Time Data Start DateTime.

3. Create two conditions:

   • >= -900 seconds, to cover imported start times up to 15 minutes before the scheduled start time.

   • <= 900 seconds, to cover imported start times up to 15 minutes after the scheduled start time.

4. In the THEN section, set the External Time Data Start DateTime to the value returned by Get Start Time of Working Days().
   
5. Assign the rule under object External Time Data, the start time of imported External Time Data will now be rounded to the work schedule start time when it falls within 15 minutes of the scheduled start time. 

• SAP Help Portal - Calculate Duration in Seconds Between Two DateTime Values()
• SAP Help Portal - Import of External Time Data

SuccessFactors, Employee Central, Time Tracking, External Time Data, External Time Data Import, Time Sheet, Business Rule, MDF Business Rule, Evaluate Rule, Work Schedule, Start Time, End Time, Time Rounding, Round Time, Time Alignment, Get Start Time of Working Days, Get End Time of Working Days, Calculate Duration in Seconds Between Two DateTime Values, Imported Time Data  , KBA , LOD-SF-EC-TMS , Time Sheet , LOD-SF-TTR-TMS , Time Sheet , LOD-SF-TTR , Time Tracking , How To

SAP SuccessFactors Employee Central all versions ; SAP SuccessFactors HCM Suite all versions ; SAP SuccessFactors Time Tracking all versions