SAP Knowledge Base Article - Public

3287499 - How to report end date of a time recording in Time Sheet

Symptom

It is expected to report the end date of a time recording in Time Sheet, but there is no field endDate in Employee Time Sheet Entry.

Environment

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

Cause

There is no field endDate in Employee Time Sheet Entry object definition.

Resolution

Please consider reporting the endDate in Employee Time instead.

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. And in this Employee Time instance, the endDate is a non transient field to hold the end date value.

So please report on the endDate (EmployeeTimeSheetEntry.EmployeeTime.endDate) field in Employee Time as a workaround.

Furthermore, there is also a new MDF view provided for reporting Absence and Attendance. 
Details can be found from blogpost New Reporting Capabilities for Absences and Attendances in SAP SuccessFactors Time Tracking

See Also

3287193 - Start Time, End Time, and Start Date of a time recording in Time Sheet are returned empty in reports
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 
3629038 - Is it possible to report attendance and absence data combined ?

Keywords

canvas, reporting, tms, UI, start, end, time, advanced, return, blank, empty, extract, retrieve, ttr, tracking, sheet, story, view, mdf, date, seconddate , KBA , LOD-SF-EC-TMS , Time Sheet , LOD-SF-TTR , Time Tracking , How To

Product

SAP SuccessFactors Employee Central all versions ; SAP SuccessFactors HCM Core all versions