Absence Valuation Concept.

[Former Member]

Hello Experts,

First of all I really appreciate your effort for helping and expanding your knowledge. This is my first time posting a question on SAP Forum.

I am trying to understand the basic concept of Absence Valuation. 

I have an Unpaid Absence. My requirement is that if an employee takes unpaid holiday say for one week. The salary for the absent days will be deducted from basic pay. The basic pay wage type should show the full amount for the employee salary but I want to add another wage type which shall deduct the absent days as well as print this on the salary slip.

For this I have created a wage type “Holidays Unpaid”. And maintain following tables,

V_T554L for Defining Absence valuation rule.

V_554S_G for Grouping Absences for valuation .

V_T554E for counting class.

V_T554C for Absence valuation-

Now when I run the payroll I am able to see the wage type but it is adding the total amount in basic salary instead of deducting from it.

Now my question is that can I achieve this requirement through the standard configuration or do I need to write a custom rule for this. If yes, can you guys help me please? Thank you in advance.

[Former Member]

Hi Usman,

Actually Absence valuation we are doing for valuate the absence based on paid leave or unpaid leave.

Lets say you have 03 types of absence called  Annual leave , Casual leave and Sick leave.In this , Annual and Casual leaves are Paid leave and the sick leave is unpaid leave.

01.For this above scenario. we have to define the absence valuation rule (V_T554L ) for Paid leave and Unpaid leave. lets say rule 01. is paid leave and rule 02 is unpaid leave.

02.then you have to group absence for absence valuation in V_554S_G. here you have to assign the rule to your absence. Annual and casual should be  01 and Sick leave should be 02.

03. Creating counting class (V_T554E) which you can consider as the valuation rule . you have to create counting class as 01-Paid absence and 02-Unpaid ubsence .

04. this counting class and the valuation rule has to be attached in V_T554C-Absence valuation. In this table you can assign your absence valuation group (which will comunicate with PCR XMOD.)

, valuation rule (which you created earlier), counting class and wage type etc..

Regards,

Dinesh.

[Former Member]

Dear Dinesh,

First of all thank you so much for your reply.  I have already configured the above mentioned points.

The problem i am having here is when i run the payroll i want the Absence to reduce the salary base on absent days. But instead of reducing the salary the wage type i created and attached in  V_T554C is being added in total salary. I want this wage type to be deduction wage type. Now this wage type has the valuation 01 assigned to it. and based on absent days this is adding the amount in total salary. Say employee has 3 unpaid absent days. So the amount of these 3 days shall be deducted from salary.

I am having the right amount when i run the payroll but amount is being added in total salary.

Thanks for your input.

[Former Member]

Hi Usman

you may wanna check if the customer wagetype you have mapped in  V_T554C is flagged as deduction-V_T511 and also add to total flag.this might sound silly,but still worth a check i reckon

no worries

kg

[Former Member]

Hi Usman,

Once you got the number of absence days in you customer wage type then you can write a PCR according to your formula.(each company have deferent deferent formula for this.) what is your calculation formula??

Lets say if an employee is two days absence (unpaid) then  the formula should be :

Example: Basic Pay / 30 * 2 days (absence days)

                5000.00 /30 * 2 = 333.00  (this has to be deducted from his/ her salary right?

writting a simple PCR you can capture this amount and which can be deducted from employee's basic salary

Regards,

Dinesh

[Former Member]

I have tried this already but not working. Thanks anyways for your input

[Former Member]

Hi Shan, Thanks for your reply again. I have maintain the TKAU** valuation and assigned this to customer wage type in PC10. now basic salary gets reduced but how do i need to get this value in customer wage type??

Because i am getting the value in payslip like

Wage type                                     Hours                    Rate                               Earning            Deduction

5001                                                 24                          10                                  240

Now the rate it is getting from Valuation 01 which i have assigned to customer wage type. it should show the 240 on deduction side but instead of i am  having this value in earning side.

This is the problem i am having now if i have to write a rule. Can you please explain it to me. I have no experience in writing PCR. Thank you so much

[Former Member]

Hi Usman,

try to do in bellow mentioned way.

01. create a wagetype (Ex. 9000)  to capture unpaid leave days and make it as deduction wage type in V_T511 (tick deduction wage type) and V_512W_D (put tick on "net payment/ deduction).

02. Assign this wage type in your absence valuation in V_T554C. now this wage type will cary the number of absence days (number value).

Ex. if you applied unpaid absence via IT2001 then this wage type will carry the number of days.

03.now you have to write a PCR to valuate this number of days into amount.so the sample PCR for your wagetype 9000

Lets say your formula is :

Basis pay /30 * number of days ubsence.

In this scenario your basic pay wage type is 1000.and unpaied ubsence hours in 9000

*

9000 

AMT= 1000  AMT/  30 MULTI ANA  ELIMI *   ADDWT *

Now  add this wage type 9000 in your deduction cumulation side in payslip config Pe51

Regards.

Dinesh