Skip to Content
Author's profile photo @ Dey Sankarsan

Salary Calculating based on Actual working hours and there after calculate Over time

Hi Everybody,

When i was started my career all most 4 years back on that time i did not think so one day i would be publised my document on this site.

This is my 1st document which i am going to discuss about “postive time managment integration with payroll and salary calculation would be based on actual working hours”.

From this topic line we can easily understand that we have to calculate employee’s actual working time in the month and there after we will pass this information to Payroll section in SAP which will calculate the salary payment for the employee for that month. So it has two sections.

1st Part Time Managment Section:-

1. Calculate Actual Work time.

To find the acctual work time we will create one time types . This time type will have the day balance as well as month balance.

/wp-content/uploads/2014/10/1_555688.png

So in this time type we will store daily working hours through below pcr. This pcr will add after P2011 function with PTIP finction in TM00 schema.

/wp-content/uploads/2014/10/1_555688.png

This pcr is calculating every working day’s hours and will add to time type and accumulate in the month balance. (please add colop * after ADDDB9998).

Now to transfer the time type value to payroll we need to create a time wage type say WT5000. In the end of the month we will generate this time wage type and will move to payroll as a cumulative value. So for below pcr need to write and will insert in the schema with IF ENDIF condition of EOM.

/wp-content/uploads/2014/10/1_555688.png

This is upto time managment calculation part and we have generated time wage type which is stored with monthly actual working hours and it will evaluate further in payroll.

2. 2nd Part Payroll Section:-

IMPRT B2 function will bring the time wage type value to payroll and provide it in the input table in payroll. This wage type is carrying NUM value where we will change it to RTE value because we will use it to calculate in INP1 pcr modification.

Change NUM to RTE of time wage type and also calculating OT if he had worked more than schedule monthly working hours.

/wp-content/uploads/2014/10/1_555688.png

Insert this pcr in XT00 sub schema just before X020 standard pcr. WT 5001 is the overtime wage type and if OT wage type is generating then we can write the OT calculation pcr and insert it just after above mention pcr but before X020 standard pcr.

Now will modify INP1 pcr according to our requirement and will use WT5000 for calculation. Because it’s holding the actual working hours. In this we are taking that all basic pay infotype permissiblity wage type having processing class 10 as 9.

/wp-content/uploads/2014/10/1_555688.png

After done this we will modify the value pay element pcr in INAL subschema.

/wp-content/uploads/2014/10/1_555688.png

After that you will get the required result in your payslips.

Here, I come to the end of this knowledge sharing. Thanks for your patience to go through it. I hope with this understanding of positive time managment to payroll integration, you will be in a better position to write PCRs to achieve various integration related requirements in time managment & payroll.

Regards,

Sankarsan

Assigned Tags

      25 Comments
      You must be Logged on to comment or reply to a post.
      Author's profile photo Former Member
      Former Member

      Hi Sankarsan,

      Good document and i hope more documents from you.

      Best Regards,

      Praneeth kumar

      Author's profile photo @ Dey Sankarsan
      @ Dey Sankarsan
      Blog Post Author

      Hi Praneeth,

      Thanks!! Sure i will ...

      Regards,

      Sankarsan

      Author's profile photo Rama Rani Rana
      Rama Rani Rana

      Hi Sankarsan,

      You have outpoured a valuable information in your first document and I hope this is going to help many of us in our assignments.

      Congratulations on your first writing

      This is indeed a very informative document and looking forward to read more posts from you.

      Your contribution is really appreciated.

      Thanks

      Rama Rana

      Author's profile photo @ Dey Sankarsan
      @ Dey Sankarsan
      Blog Post Author

      Thanks Rama!!!

      Regards,

      Sankarsan

      Author's profile photo Babu Kolkata
      Babu Kolkata

      Hi Sankarsan,

      Thanks for the nice document. I'm expecting some more documents on Positive Time Managemt.

      Santosh

      Author's profile photo @ Dey Sankarsan
      @ Dey Sankarsan
      Blog Post Author

      Thanks Santosh!!

      Sure i will do some on +ve time managment.

      Please rate the document.

      Regards,

      Sankarsan

      Author's profile photo Former Member
      Former Member

      Good One Sankarsan

      BR

      Anil

      Author's profile photo @ Dey Sankarsan
      @ Dey Sankarsan
      Blog Post Author

      Thanks Anil.

      Please rate the document.

      Regards,

      Sankarsan

      Author's profile photo Former Member
      Former Member

      Hi Sankarsan,

      Good document, come up with some more documents like this ..

      Author's profile photo @ Dey Sankarsan
      @ Dey Sankarsan
      Blog Post Author

      Thank Sba01 b.

      I will.

      Regards,

      Sankarsan

      Author's profile photo Former Member
      Former Member

      Hi Sankarsan,

      A very good document

      pls provide some more scenarios also like the same...

      Vijay

      Author's profile photo @ Dey Sankarsan
      @ Dey Sankarsan
      Blog Post Author

      Hi Vijay,

      Thank you. Please rate the document.

      Regards,

      Sankarsan

      Author's profile photo Bhabagrahi Sahu
      Bhabagrahi Sahu

      Sankarsan sir,

      Nice document, Yesterday I was looking for a similar document and happy to see this one, which is going to be definitely helpful.

      Thanks,

      Bhabagrahi

      Author's profile photo @ Dey Sankarsan
      @ Dey Sankarsan
      Blog Post Author

      Thanks Mr. Sahu.

      Regards,

      Sankarsan

      Author's profile photo Former Member
      Former Member

      Good Document Where do I create Time Wage type 5000 and Overtime Wage type 5001 Could you please let me know

      Author's profile photo Former Member
      Former Member

      You have created three PCR's ZTST with same name could you please clarify when I try to create another ZTST it is saying its already created.

      Author's profile photo @ Dey Sankarsan
      @ Dey Sankarsan
      Blog Post Author

      Hi Priya,

      It would be different PCR name. I have written all rule under one PCR name(it's my mistake thanks to cirrecting me 😛 )

      For correct it would be ZTST, ZTS1 and ZTS2.

      Regards,

      Sankarsan

      Author's profile photo Former Member
      Former Member

      Thank you Where do I create Time Wage type 5000 and Overtime Wage type 5001 Could you please let me know


      Do I need to create in V_T555A Could you please let me know whet is the scenario??

      Author's profile photo Former Member
      Former Member

      WHEN IAM CREATING num= 5000 ITS SHOWING INVALID OPERATION PLZ ET ME KNOW

      /wp-content/uploads/2014/12/1_604326.jpg

      Author's profile photo Former Member
      Former Member

      Hi Sankarsan,

      very good document do come with different  scenarios like this ..

      i have an doubt here " insert in the schema with IF ENDIF condition of EOM" .

      can u clarify how to do this

      Author's profile photo @ Dey Sankarsan
      @ Dey Sankarsan
      Blog Post Author

      Hi Bhama,

      It's mean that in the schema it would be like below

      Function Par1 Par2 Par3 Par4

      IF                             EOM

      PIT        ZTST

      ENDIF

      Regards,

      Sankarsan

      Author's profile photo Former Member
      Former Member

      You havent shown where to place pcr in schema  5 Rules you have written  but you didnt show where we need to place in schema

      what is the scenario all about why we are using those pcrs? No explanation for that

      where we can create time types 5000 and 5001

      Last step I didn't understand where we will modfy below  INAL subschema I believe you have written pcr

      After done this we will modify the value pay element pcr in INAL subschema.


      Could you please explain

      Author's profile photo @ Dey Sankarsan
      @ Dey Sankarsan
      Blog Post Author

      Hi Priya,

      It's mentioned that where you will insert the PCR in the schema.

      5000 & 5001 is not the time type. It's a wage type where it's related pcr has been written under Payroll section.

      In the INAL subschema there have XVAL pcr which i have modified to /VAL.

      Regards,

      Sankarsan

      Author's profile photo Former Member
      Former Member

      Thank you sorry it is mistype where we need to create time wagetypes 5000 and 5001 You have mentioned

      Now to transfer the time type value to payroll we need to create a time wage type say WT5000. In the end of the month we will generate this time wage type and will move to payroll as a cumulative value. So for below pcr need to write and will insert in the schema with IF ENDIF condition of EOM.

      Author's profile photo Former Member
      Former Member

      Could you please provide screenshots for below



      So for below pcr need to write and will insert in the schema with IF ENDIF condition of EOM.

      Insert this pcr in XT00 sub schema just before X020 standard pcr. WT 5001 is the overtime wage type and if OT wage type is generating then we can write the OT calculation pcr and insert it just after above mention pcr but before X020 standard pcr.