Symptom
“Image/data in this KBA is from SAP internal systems, sample data, or demo systems. Any resemblance to real data is purely coincidental.“
- How to extract employee clock in/out data in report (csv file)
- Which template / navigation need to use to extract employee Timesheet clock In/Out data .
Environment
- SAP SuccessFactors Employee Central - Time Sheet
- SAP SuccessFactors Time Sheet - Clock In Clock Out
Resolution
It is not possible to directly export time events in csv file, instead we have standard reporting function to report on time events as documented in Reporting of Time Events for Clock In Clock Out and Available Data (Schema) in Story Reports.
But if exporting to csv file is needed, the following workaround may be considered.
- Use the Import and Export data ,and have the export done for the Employee Time Object.
- Set the filter based on Attendance Time type relevant with the time events, which will contain the Start Time and End Time (Clock In/Out time).
- Refer screenshot below for sample data as seen in .csv file
Attention: With this workaround, the second of the time events will be discarded, because in time sheet we do not record seconds.
See Also
Keywords
Time Sheet, download, export, time data, excel, export, timeevents, time, event, clock, in, out, break, punch, ttr, tracking, report , KBA , LOD-SF-TTR-CIO , Clock In/ Clock Out , How To