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
- 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.
- 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