KALTech’s Utilities Solution to a CATS challenge

The requirement:
The client, a big player in the utilities space had chosen SAP CATS (Cross Application Timesheets) as their time sheeting tool of choice. They wanted to allocate as much of their labour cost as possible to capital expenditure (capex) projects. Simply put, they wanted all the salary and allowance cost to be allocated to the projects (work orders) that the employees had performed work on.
The timesheet was to consist of 3 major components: Normal time (ordinary hours), Overtime (hours in excess of normal hours) and allowances.
In addition to this, each category of employees could have different charge out rates associated with them. For example the normal time rate associated with employee category X could be $100 whereas another category Y could be $130.
And if this wasn’t complicated enough, all of this labour cost allocation needed to happen as soon as the timesheet entries were approved.
The issues faced and solution provided:
Surely SAP Payroll would rescue us from this rather complex requirement……
Normal time, overtime as well as allowances are calculated via payroll and are usually allocated to the employee’s master cost centre. But this would mean waiting up to a fortnight for the payroll to run for the costs to flow through. Also this would mean that the costs would not be allocated to the project/s that the employee had worked on. So of course that option was shot down as quickly as a duck during hunting season.
With no other way out of this jam we decided to turn to activity types (our saviour). We cleverly set up activity types with the required rates and had them default to each timesheet line item. The activity types associated with each line item would provide a rate multiplier (price) to the number of hours entered. So if an employee belonging to category A and associated with an activity type X (with rate $100) worked 4 hours on a project, the project would be charged $400. To make this possible each employee would be associated with an activity type in Infotype 0315 Timesheet defaults. The activity type rates would be set up using transaction code KP26. Too easy. But an impromptu KALTech brainstorming session soon made us realise that we had only catered for normal time and not for overtime and allowances.
Using standard Infotype 0315 allows you to default only a single activity type for any given employee. But we needed two more types of activity types, one each for overtime and allowances to be defaulted as well. In other words, we needed to find a way to allocate activity types for normal time, overtime and allowances (wage types) to each employee’s timesheet record. In the absence of a standard SAP solution, this would have to be achieved using a custom table, a few CATS user exits and Infotype 0315. With this custom solution, every time an employee entered a line into CATS, the user exit would read Infotype 0315 and the custom table to identify and auto-populate the relevant activity type into the CATS database. This would enable us to attach separate activity types for normal time, overtime and allowances to each employee record during data entry. The auto-populated and hidden activity type field would also ensure that the employee did not select an incorrect activity type.
Here’s how we at KALTech designed the solution…
Each employee is associated with a normal time activity type in Infotype 0315.
Each normal time activity type is associated with an overtime activity type in the custom table.
Each timesheet allowance is associated with a corresponding allowance activity type in the custom table.
During timesheet entry in CATS, notice that the following activity types get automatically defaulted
• Normal time activity type – based on the employees Infotype 0315 master data record.
• Overtime activity type for the overtime attendance code – based on the normal time activity type in the custom table.
• Allowance activity type based on the allowance entry – based on the allowance code in the custom table.
Want to know more?
Contact us at KALTech!
KALTech SAP/Successfactors Consultant

This entry was posted on July 23rd, 2015.
Discussing 1 Comment
  • online timesheet December 20, 2017 at 4:24 pm

    Thanks for sharing this. Extremely useful as always!


Name *

E-Mail (will not be published) *



Please feel free to post a comment about a post. All feedback is welcomed but will be moderated. Try to keep it constructive!

Thanks for your feedback.

KALTech Group