Skip to Content

Scenario: Overtime Calculation

Employee’s overtime, which is entered in employee remuneration info should be paid correctly in his payroll.

OT Rate has to be calculated as per the below logic.

OT Rate = (Basic * 12) / 2496.       

Using standard schema, we cannot achieve this.

We will create a custom rule and add that rule in custom schema.

Copying Standard Schema:

TCODE: PE01.

Enter Schema name and click on Copy button. Enter TO Schema.

Copy SAP Standard Schema (XT00) to Z Schema (Z003).

/wp-content/uploads/2012/03/l10_82033.png

Rule Creation:

TCODE: PE02.

Enter Rule name and click on Create button. In Attributes, enter Program Class ‘C’ (Payroll).

/wp-content/uploads/2012/03/l1_82039.png

Create a Rule (Z002) for calculating OT Rate.

Each rule contains operations to process payroll data in internal tables. In the below rule we have used AMT, ADDWT and FILLF operations.

AMT*12: Amount of the current wagetype is multiplied with 12.

ADDWT 9010: The Current wagetype values are added to wagetype 9010 into OT table.

FILLF: This will reset the value of current wagetype.

ADDWT *: Adding current wagetype to OT table.

/wp-content/uploads/2012/03/l2_82043.png

Create another rule(Z004) to send amount of wagetype 9010 to wagetype 9020.

/wp-content/uploads/2012/03/l3_82045.png

Create a rule(Z005) to multiply Rate with Number to get Amount.

/wp-content/uploads/2012/03/l4_82049.png

Insert the newly created rules into schema Z003.

/wp-content/uploads/2012/03/l6_82050.png

Data Maintenance:

Now enter wagetype 9020(Overtime) and number of hours in Employee Remuneration Info (2011) infotype.

/wp-content/uploads/2012/03/l7_82051.png

Executing Payroll:

/wp-content/uploads/2012/03/l8_82055.png

Check Payroll Results:

/wp-content/uploads/2012/03/l9_82056.png








To report this post you need to login first.

12 Comments

You must be Logged on to comment or reply to a post.

  1. Binu Philipose

    Hi Pradeep,

    Keep up the good work. This is an amazing document. However the screenshots are not clear. Is there any way you could update the same??

    Regards,

    Binu

    (0) 
      1. Binu Philipose

        Hi Upendra,

        I have tried several methods to chk the screen shot, the issue is, the moment u enlarge the size, the content gets blurred and become unreadable.

        Was hoping to read the functions used in the rule…

        (0) 
        1. Upendra Krishna

          Hi Binu,

          Then I would not be of any help here, because I have suggested what I have done, may be it is something with your OS, I am not sure.

          (0) 
  2. praneeth kumar m

    Hi,

    i done according to document stepwise only

    but if i give OT hours in IT 2010 as 5 in salary also it is 5 only not multiplying with hour rate * 5 (OT hours)

    what is the issue can anyone please clarify.

    thanks and regards,

    praneeth kumar

    (0) 

Leave a Reply