RE:[sap-hr] Overtime Calculation for Two (2) Scenarios
Posted by
Admin at
|
Share this post:
|
|
0 Comments
 | Posted by Donna on Feb 18 at 11:45 PM |  Mark as helpful |
Irfan,
You can do this by creating an hourly rate in payroll based on your formula: (gross monthly salary X 12)/365/8. This will loaded into one of the available valuation bases; e.g. /009. Then assign this valuation basis to the wage types to be valuated on T512W. For overtime, valuation basis 09 at 200%. For holiday work, valuation basis 09 at 300%.
To create the value in the valuation basis, you can write a rule. If the employee's have a monthly salary on IT0008, you can use the following (assuming salary wage type = 1000).
Process WT 1000
ADDWT * -- Send it to IT as is
AMT*12
RTE=KZHOUR -- T511K constant ZHOUR holds value 4380 (365*8)
DIVID ARR
ZERO= A
ADDWT /009
This is compressing the formula into one rule. If salary is available on IT0008, a better method would be to follow the processing used in rules X010 and X015 with a modified formula similar to the one noted to create the new valuaiton basis.
If the monthly salary amount is not available on IT0008, you can still create one for use in the calculation of the rate by multiplying whatever value is offered by the appropriate factors to create the amount needed.
Donna
---------------Original Message---------------
From: Irfan Malik
Sent: Thursday, February 18, 2010 2:45 PM
Subject: Overtime Calculation for Two (2) Scenarios
> Hi SAP Gurus,<br/>I am currently on a new project implementing Pakistan specific SAP HCM. I've the following scenario for which I require your expert opinion. <br/>My client pays Labour employees for the overtime they perform based on the following formula. <br/>1st Scenario:<br/>Normal Overtime Calculation:<br/>((Gross monthly salary X 12) / 365 / 8)) * 2 = Per Hour Rate<br/>Per Hour Rate * no. of overtime hours worked = Overtime Amount<br/>We normally develop ABAP function to transfer overtime hours from ZL table to IT 0015 to create payment. Is there any standard way to cater this requirement?<br/>2nd Scenario:<br/>Client pays work on public holidays i.e. fixed and movable holidays as per the following formula.<br/>((Gross monthly salary X 12) / 365 / 8)) * 3 = Per Hour Rate<br/>Per Hour Rate * no. of overtime hours worked = Overtime Amount<br/>Again I want to know if there is a standard way to cater the 2nd scenario too?<br/>Your help will really be appreciated. <br/>Thanks,<br/>IRFAN MALIK<br/>SAP HCM Consultant <br/>SIEMENS Engineering Co. Ltd. Pakistan
__.____._ You can do this by creating an hourly rate in payroll based on your formula: (gross monthly salary X 12)/365/8. This will loaded into one of the available valuation bases; e.g. /009. Then assign this valuation basis to the wage types to be valuated on T512W. For overtime, valuation basis 09 at 200%. For holiday work, valuation basis 09 at 300%.
To create the value in the valuation basis, you can write a rule. If the employee's have a monthly salary on IT0008, you can use the following (assuming salary wage type = 1000).
Process WT 1000
ADDWT * -- Send it to IT as is
AMT*12
RTE=KZHOUR -- T511K constant ZHOUR holds value 4380 (365*8)
DIVID ARR
ZERO= A
ADDWT /009
This is compressing the formula into one rule. If salary is available on IT0008, a better method would be to follow the processing used in rules X010 and X015 with a modified formula similar to the one noted to create the new valuaiton basis.
If the monthly salary amount is not available on IT0008, you can still create one for use in the calculation of the rate by multiplying whatever value is offered by the appropriate factors to create the amount needed.
Donna
---------------Original Message---------------
From: Irfan Malik
Sent: Thursday, February 18, 2010 2:45 PM
Subject: Overtime Calculation for Two (2) Scenarios
> Hi SAP Gurus,<br/>I am currently on a new project implementing Pakistan specific SAP HCM. I've the following scenario for which I require your expert opinion. <br/>My client pays Labour employees for the overtime they perform based on the following formula. <br/>1st Scenario:<br/>Normal Overtime Calculation:<br/>((Gross monthly salary X 12) / 365 / 8)) * 2 = Per Hour Rate<br/>Per Hour Rate * no. of overtime hours worked = Overtime Amount<br/>We normally develop ABAP function to transfer overtime hours from ZL table to IT 0015 to create payment. Is there any standard way to cater this requirement?<br/>2nd Scenario:<br/>Client pays work on public holidays i.e. fixed and movable holidays as per the following formula.<br/>((Gross monthly salary X 12) / 365 / 8)) * 3 = Per Hour Rate<br/>Per Hour Rate * no. of overtime hours worked = Overtime Amount<br/>Again I want to know if there is a standard way to cater the 2nd scenario too?<br/>Your help will really be appreciated. <br/>Thanks,<br/>IRFAN MALIK<br/>SAP HCM Consultant <br/>SIEMENS Engineering Co. Ltd. Pakistan
Copyright © 2010 Toolbox.com and message author.
Toolbox.com 4343 N. Scottsdale Road Suite 280, Scottsdale, AZ 85251
Toolbox.com 4343 N. Scottsdale Road Suite 280, Scottsdale, AZ 85251
DonnaSAP HR Enthusiast
Contributed 100 posts in a group to earn a Bronze Achievement
Related Content
In the Spotlight
White Papers
In the Spotlight
Earn Recognition for Your Contributions at Toolbox for IT. Gain Points for Community Achievements
View this thread online
Manage group e-mails
Create an FAQ on this topic
Tell us what you think
Unsubscribe from discussion
Manage group e-mails
Create an FAQ on this topic
Tell us what you think
Unsubscribe from discussion
