SAP CATS- Time booking for SD Order and Payroll Cost Booking

[atul_rajmane]

Dear All,

We would like to book a time sheet against a Sales Order line item in CAT2. Same will be using to run the payroll. Once, we run payroll, based on Hrs booked in time sheet, we would like to pass the payroll cost to respective sales order based on the time sheet for an emmployee.

Let me know how we can do this with CAT2 wherein we have SD order as the Receviver object.

Regards

Atul Rajmane

[former_member388328]

Hi Atul,

Certainly you can book time using cat2 and rec object as sales order. required config is that Sales order should be costing object , you have to setup sales order item category accordingly.

But the problem in above scenario is that you want book payroll costs to sales order based on time booked. Basically CATS are designed in such way that you know cost per hour even before you book the time in cat2. I would suggest first fix some temporary rate and book the cat2 timesheets accordingly and in the month end run a distribution cycle with difference of the temporary rate and actual payroll costs. There can many different solutions also.

Thanking you

Vengaiah

[atul_rajmane]

Dear Vengaiah,

Thank you reply.

As u mentioned we have sales order as a cost object in configuration. Now, if I understand correctly, we need to define an activity type rate in KP26 to get an allocation (i.e. temporary rate) on sales order from CAT2 time sheet. Let me know it this is correct. If yes, then how Hrs will be transferred? via using CAT7 to controlling?

Assuming, I have done that also, still cost distribution may be an issue since I need to transfer the cost from the master cost center to sales order based on actual hours booked on sales order for that particular employee. and in my case, there is more than 1 employee assign to master cost center. So this will difficult to transfer that particular cost SD order in Std Cost Distribution cycle.

Let me know your comment on this.

Regards

Atul Rajmane

[former_member388328]

Hi Atul,

No you can transfer using SKF. It should be actual payroll cost minus temporary rate for each employee. Sum of this difference for all employees plus total temporary rate posted for all empolyees should equal the master cost center. I sure you can find out payroll cost for each employee.

Thanking you

Vengaiah

[atul_rajmane]

Hi Venagiah,

I never use SKF before in CAT time sheet. Could you explain these steps in little more details with configuration, so I can configure and can check same by creating a test cycle.

Regards

Atul Rajmane

[former_member388328]

Hi Atul,

For example : if a employee has approx salary of 6400 usd. then you need to create activity type with 40 usd per hour. Now if this employee books time on four sales order 40 hours each(approx 160 hours per month). but actually payroll is 6600 usd for this employee in the month end . But you have already posted 6400 against different sales orders . Balance which is not posted 6600 - 6400 = 200 usd. Now we can post this 200 using SKF against all the sales orders he as booked time in the month end .

You can request your CO consultant to help you with this process.

Thanking you

Vengaiah

[atul_rajmane]

Dear Vengaiah,

Thank you for sharing input with an example.

It means balance 200 USD will be booked against respective SD order using Cost Distribution cycle. Let me know if I am correct.

Regards

Atul Rajmane