Modifying Standard PCR Related To Factoring Paid & Unpaid Absences
Introduction
I was going through SCN on factoring wage types differently based on paid and unpaid absence types for UAE Payroll especially when it comes to modifying only one wage type in a particular manner where as remaining all other wage types are factored in the same manner and frankly did not get much insight into it. They are multiple approaches for solutioning this particular requirement and for the purpose of this document, I would be covering step by step configuration using one of the approaches.
My objective would be to cover step-by-step configuration of the entire solutioning of this requirement with the approach of using processing classes insync with PCR specific for UAE Payroll.
Assumption
This document is made on the assumption that all the absence types required are already present in the system. We would be focusing only on the payroll part of the requirement as the requirement is related to absence valuation.
Client Requirement
Below was one of the requirements from the client.
Transportation allowance calculation for UAE Payroll needs to be modified as per the below requirements
AS-IS Process
In case Absence records are present in IT 2001 then
Transportation allowance needs to be prorated accordingly based on the records.
Transportation allowance needs to be prorated accordingly based on the records.
- Annual Leave
- Leave without pay
- Bereavement leave
- Maternity leave
- Paternity leave
- Child birth leave
- Wedding leave
TO-BE Process
In case Absence records are present in IT 2001 then Transportation allowance needs to be prorated accordingly based on the records.
- Annual leave
- Leave without pay
- Bereavement leave
- Maternity leave
- Paternity leave
- Child birth leave
- Wedding leave
|
AS- IS
|
TO BE
|
| Monthly Transportation Allowance 1000 USD |
|
|
Start Date:
01-Jan- End Date: 30-Jan
|
|
|
Annual/Wedding/Child birth/Bereavement leave for 10 calendar days
Transportation allowance = 1000/30*(30-10) |
Annual/Wedding/Child birth/Bereavement leave for 10 calendar days
Transportation allowance = 1000 |
|
Sick/Emergency leave for 10 calendar days
Transportation allowance = 1000 |
Sick/Emergency leave for 10 calendar days
Transportation allowance = 1000 |
|
Maternity leave for 20 calendar days
Transportation allowance = 1000/30*(30-20)
|
Maternity leave for 20 calendar days
Transportation allowance = 1000/30*(30-20) |
In Other words, As part of the new requirement Transport allowance wage type needs to be modified to ensure that only in case an employee applies for maternity or paternity leaves should the Transportation Allowance be reduced for those and not for any other leave type effective from the new year.
Solution Design
Firstly, lets break up the requirement-
- Change should be from a new date– This would mean that all previous records should not be impacted. To achieve this the approach I took was to create a new wage type and configure all the changes to this wage type so that in case any retro or old
wage type needs to run, the HR team can use the old wage type and in case the new calculation is required, they can use the new wage type. This way there is more flexibility to the whole solution. - Should not impact any other wage type- As per the requirement, all other wage types, when absence records are present be it Earned leave, Loss of pay, Wedding leave etc, the amount assigned in the wage type needs to be prorated based on the number of absent days. Whereas in the new wage type only paternity and maternity leaves should be deducted and no other wage type. To achieve this, the methodology used by me was to assign a unique or unused value in Processing Class 10 in the
newly created wage type. This way when all the other wage types have the value assume 1 in PC 10, the new wage type would be having the value say 5. - Differential payment based on Absence types- This would be the meat of the entire requirement and to have this implemented, I wrote a PCR under the factoring Schema specifically under the factoring technical wage type based on the value assigned in the Processing class 10. This would be explained in detail in the Implementation section below
along with screenshots.
Implementation
Step 1: The entire approach would start with creating a new wage type by copying the already existing transportation allowance and shall name it as Transportation Allowance Dubai
Below screenshot
|
T-Code
|
OH11
|
Now run the same by removing the test run checkbox and the wage type would be copied successfully.
Step 2: We would now need to assign a unique value in PC 10 for this newly created wagetype so that the processing can be impacted via the PCR to get the desired calculation.
|
T-Code
|
SE16
|
|
Table
|
V_512W_D
|
Now the newly created wage type 1038 Transport Allowance has the unique factoring value of 5 as seen in the above screenshot.
With this we ensure that the wage type would be factored in payroll using the technical wage type /805.
With this in mind now, we can modify the behavior of the new wage type by editing the technical wage type/805 to ensure that the calculations in payroll are in consistent with the new requirements.
Step 3: Now we would start to modify the PCR which calculates the /805 wage type in payroll to ensure only maternity and paternity absence types are deducted from the allowance in payroll and no other absence type.
Note: Whenever you have requirements to modify the standard solutions given by SAP, the best approach would be to copy the standard solution, rename it and use the same for modifying as per the client requirements. Its always in the best interest of the user to ensure that standard programs are not modified.
For UAE payroll, the standard PCR used for Partial Period factors is AEPF. So we create a custom PCR by first copying the standard PCR and shall name it as ZAPF
|
T-Code
|
PE02
|
Now we modify the custom PCR ZAPF and the wage type /805
We modify the /805 wage to be shown as below:-
Here the TKAP** are the paid absence which would be deducted from the calendar days before being used for calculating the transport allowance. In case of unpaid absences, include TKAU** which would ensure any unpaid absences would be deducted.
Here in my case, the values 06, 07 and 09 and maternity and paternity absence types.
Save the above changes in the PCR.
As far as the requirements are concerned, the process is complete. Now all is required is to include the custom PCR in our payroll
schema for UAE (AE00) so that the same is considered for processing while payroll is run.
schema for UAE (AE00) so that the same is considered for processing while payroll is run.
Results
With the above configuration in place, lets run a monthly payroll for an employee to see if the wage type is being calculated as per requirement.
Step1: Include the wage type in the employee records using the Tcode PA30
Step 2: Apply any Earned leave in the system in IT2001.
Step 3: Execute Payroll for the employee and see if any proration happens for the newly created wage type.
If the amount is paid as whole with no proration then that would mean our scenario is successful. In the above screenshot the entire amount is being paid to employee.
Now repeat the above Steps 1-3 and this time apply maternity and paternity absence types in the employee records and rerun payroll.
You would have the wage type pro-rated based on the number of days the absence types are present for the month in which payroll is run as shown in the below screenshot.
This would bring me to the conclusion of this document and sincerely hope this comes in handy for our HCM consultants and need not reinvent the wheel.
Wish you all the best..
Thanks and regards,
Shine Sebastian Joseph
In case of any feedback or suggestions, pls feel free to mention in the comments section.
Very Good Document. Nice. Keep it up. 🙂
Thanks Suresh for your feedback.. shall surely bring in more docs.. 🙂
Hope you had rated the document too for the benefit of other users in SCN.
Yes Given Five Star rating. It is really good one.
Thanks for rating the document 5 star... 🙂
Good detailed document. Thanks a lot.
such a helpful document, if you don't mind i need your suggestion regarding modifying standard pcr related to factoring https://answers.sap.com/questions/340418/pcr-period-factoring-365-days.html
Hi Sebastin,
I have configured as you mentioned but its not working. My requirement is when an employee applies for an “Annual leave” Transport allowance should not be getting paid for the number of days.
I have configured separate Absence Valuation rule as 05 -ANL LEV UNPD TRNS
I have mapped the 05 against the Annual leave under grouping for absence valuation
I have defined separate counting class for Annual leave
And i have created counting class for absence valuation
Â
And i have modified the PCR /805
as
/805 Partial
RTE=TKSOLL
RTE-TKAP05
RTE*KGENAU
RTE/TKDIVI
ADDWT *
and i have assigned the processing class 10 to 05 of transport allowance and Basic pay to processing class 10 to 01
I have applied one day as Annual leave
But when i run the payroll and checked RT Basic pay is getting deducted for Annual leave for one day & transport allowance is not getting deducted and with same configuration i have also applied one more day- unpaid leave and again transport allowance is not getting deducted. Kindly help.
Â
Regards,
Deepan
And i have also tried change the /805 to valuation unpaid 01
Tried with the above configuration its not deducting the transport allowance.