SAP Knowledge Base Article - Public

3287193 - Start Time, End Time, and Start Date of a time recording in Time Sheet are returned empty in reports

Symptom

A report is created to return the Start Time, End Time, and Start Date of a time recording in Time Sheet, but it is noticed these fields are empty. 

Environment

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

Reproducing the Issue

  1. Create a report to extract start time, end time, and start date of a time recording by using the fields of startTime, endTime, and  startDate in Employee Time Sheet Entry.
  2. Execute this report and it is found the start time, end time and start date are returned blank.

Cause

This is the standard behaviour, because the startTime, endTime and startDate fields in Employee Time Sheet Entry object are all transient. So the values are not saved in DB, but generated in runtime. As a result, it is not possible to report on such transient fields. 

Resolution

Please report on startTime, endTime and startDate fields in Employee Time instead.
The startTime, endTime and startDate fields in Employee Time object are not transient fields.

Employee Time is embedded in Employee Time Sheet Entry as Generic Object type field employeeTime.
Whenever a time recording is created in Time Sheet UI, an Employee Time Sheet Entry instance will be generated with an Employee Time instance generated and saved in the employeeTime field.
Within this Employee Time instance saved in the employeeTime field, start time, end time and start date are saved in startTime, endTime and startDate fields respectively.

So please use these startTime (EmployeeTimeSheetEntry.EmployeeTime.startTime) , endTime (EmployeeTimeSheetEntry.EmployeeTime.endTime) and startDate (EmployeeTimeSheetEntry.EmployeeTime.startDate) fields in Employee Time to report start time, end time and start date as a workaround.

See Also

2443541 - How To Report On Time Off / Time Sheet - Advanced Reporting
2826581 - Employee Time Sheet Entry Export Returns With Empty Values For Some Fields
3100458 - Error query preview in Employee Time Sheet report - Advanced Reporting/Canvas

Keywords

canvas, reporting, tms, UI, start, end, time, advanced, return, blank, empty, extract, retrieve, ttr, tracking, sheet , KBA , LOD-SF-EC-TMS , Time Sheet , LOD-SF-TTR , Time Tracking , Problem

Product

SAP SuccessFactors Employee Central all versions