SAP Knowledge Base Article - Public

3152213 - How to extract Timesheet clock In/Out in .csv file

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.

  1. Use the Import and Export data ,and have the export done for the Employee Time Object.
  2. 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).
  3. Refer screenshot below for  sample data as seen in .csv file 
    Exportdata.PNG
    Attention: With this workaround, the second of the time events will be discarded, because in time sheet we do not record seconds.

See Also

3147194 - How to check all Time Sheets assigned to one employee in a CSV file?

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

Product

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