How to retrieve daily work calendar from EC Timesheet through API?

[AlanWaters]

Hi there,

We are pretty new to Time Valuations, still very much learning. We have a scenario where we need to export (using API through SAP Cloud integration) the daily hours per employee based on their Work Schedule, i.e. the Planned Time section of the Timesheet:

e.g. Mon 02 Sept - 7.75 hours
Tue 03 Sept - 7.75 hours
Wed 04 Sept - 7.75 hours
Thu 05 Sept - 7.75 hours
Fri 06 Sept - 7.5 hours
Sat 07 Sept - 0 hours
Sun 08 Sept - 0 hours
Mon 09 Sept - 7.75 hours
etc. (from the Work Schedule)

These employees are not clocking in or recording time through the Timesheet - we simply need to export their daily working hours for each month.

We've tried setting up a Time Valuation to read a Time Type Group with Time Category = Scheduled Working Time, and the weekly hours appear on the "Summary" section of the Timesheet (see attached: "A"),

We then tried feeding the results of that Time Valuation to another Time Valuation, to see if that made a difference, and that also appears on the Timesheet ("B" above)...

...but the data (daily or weekly) is NOT then available through the employeeTime OData API entity. It seems that the Time Type Groups that hold the results of the Time Valuations are not available through employeeTime.

Can someone please advise how we can retrieve the employee's daily work calendar, as defined by the Work Schedule and as displayed on the Timesheet, through API?

(For info, we have another set of employees who DO clock in and out, and we are able to obtain their recorded working hours through the employeeTime entity.)

Many thanks,
Alan

[Volker_Ruof · Accepted solution]

Hi, 

not quite clear what you want to achieve. We have currently only internal apis that query the planned working time, no public available APIs. However, you can report on the planned working time if this helps - check my last blog where I explained this.

But if you just need the planned working time for whatever reasons in the integration center there are multiple options:

1) Make this employees to negative time recorders. If they don´t record anything on a day the planned working time is used as recorded working time. And you can create then with 1 simple time valuation a time type group set as pay type. This is then stored on the database and you have the data per any day in the integration center as time valuation result.

2) You can also fill a time container. This should have the same effect. But probably most easiest is Option 1

best regards

Volker

[AlanWaters · Accepted solution]

Hi Volker, You have solved our problem in one go. "negative time recorders. If they don´t record anything on a day the planned working time is used as recorded working time" - we were not aware of this, but this is the key to the answer. Once we changed it to negative, the employee's standard working hours from the Work Schedule were instantly available in the employeeTime OData object. Very much appreciated - thank you. Kind regards / LG, Alan

[Volker_Ruof · Accepted solution]

Ahhh, perfect. Thanks for the feedback !