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.
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.
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.
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.
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.
After done this we will modify the value pay element pcr in INAL subschema.
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
Hi Sankarsan,
Good document and i hope more documents from you.
Best Regards,
Praneeth kumar
Hi Praneeth,
Thanks!! Sure i will ...
Regards,
Sankarsan
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
Thanks Rama!!!
Regards,
Sankarsan
Hi Sankarsan,
Thanks for the nice document. I'm expecting some more documents on Positive Time Managemt.
Santosh
Thanks Santosh!!
Sure i will do some on +ve time managment.
Please rate the document.
Regards,
Sankarsan
Good One Sankarsan
BR
Anil
Thanks Anil.
Please rate the document.
Regards,
Sankarsan
Hi Sankarsan,
Good document, come up with some more documents like this ..
Thank Sba01 b.
I will.
Regards,
Sankarsan
Hi Sankarsan,
A very good document
pls provide some more scenarios also like the same...
Vijay
Hi Vijay,
Thank you. Please rate the document.
Regards,
Sankarsan
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
Thanks Mr. Sahu.
Regards,
Sankarsan
Good Document Where do I create Time Wage type 5000 and Overtime Wage type 5001 Could you please let me know
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.
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
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??
WHEN IAM CREATING num= 5000 ITS SHOWING INVALID OPERATION PLZ ET ME KNOW
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
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
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
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
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.
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.