Report for cost of Attrition

[Former Member]

Dear Gurus,

I have to design a report to calculate the cost of attrition in SAP. I understand that there is no standard build up for it in SAP, and a BI report to be developed. Being a functional consultant need to give inputs for the report to BI consultant.

Measure inputs are :

1) No. of people hired and entrants left in a month

2) S_PH9_46000223 - A standard report on entry & exit

3) Table PA0000 - Field BEGDA, ENDDA , MASSG. Here in reason of action we consider it as category i.e. Voluntary or Involuntary. To record exit reasons have developed a customized Infotype.

4) To have the report pulled exit reason wise need to give the customized table name.

5) One person occupying one position.

6) Table HRP1000 - To get the data pertaining to object S(Positions).

7) Formula to calculate the cost of attrition.

I have a query related to point number 7 i.e. am aware there is no standard functionality available in SAP to record the cost of incurred on employee. So is it that  have to develop a customized Infotype for recording the cost incurred, then cost has to be recorded overall or categorised i.e. cost on hiring; cost on induction ; cost on training; Salary. Please guide me how to go about it and in case I am missing out on any point.

Regards,

Garima

[Former Member]

Hi,

7) Formula to calculate the cost of attrition.

I have a query related to point number 7 i.e. am aware there is no standard functionality available in SAP to record the cost of incurred on employee. So is it that  have to develop a customized Infotype for recording the cost incurred, then cost has to be recorded overall or categorised i.e. cost on hiring; cost on induction ; cost on training; Salary. Please guide me how to go about it and in case I am missing out on any point.

This can be achieved by developing HR Form .. via PE51...

Include all the wage types needed for determining cost..

Before defining Attrition rate you have to decide which type of cost you would to attach with an employee...

With Payroll Journal you can record actual cost incurred,, & finally go for attrition rate...

Regards,

Veeram

[Former Member]

Hi,

As you said there is no std to find the cost spend by the Employer on Employee for Hiring, induction program, Training program. for these you have to maintain in the sap then only you can pull the values for your required report.

for employee salary, are you maintaining field Annual salary in the IT 0008 ? or any wt /TPA - Total package otherwise consider wt /101 Total gross amount.

for remaining points you already know from where you have to pull the data.

Thanks and Best Regards,

Praneeth kumar