How to extract the number of employees (Head count) in a particulr month

[Former Member]

Hi Experts,

We are trying to have a customized report on Having the employee headcount for a particular month with number of employees joined on the month and number of employees left the organisation.What is the way to get it.

Please advice.

V Sai.

[Former Member · Accepted solution]

Hi,

Instead of a customized report, you could use the standard reporting indicating the Entries and the Leaving/ make 2 variants with conditions (one for leavers and a second one for entries) and use Partial/Total Sums. You could use as grouping the Org Unit, EE Group or whatever additional element you might want to add to your analysis.

Or if you want both the entries and the leavings in the same report - I would suggest a Querry based on the same principles (actions: hiring and leaving, the employee dates, additional dates for grouping critiria - org unit, EE group etc).

It would ease your job

Regards,

Adriana

[Former Member · Accepted solution]

Hi Adraina,

Thanks for the message.

What is the standard reports transaction code to get the hired emploees and left employees in a particular month and also is it possible to get the gross totals for the month at a single shot.

Please advice.

V sai.

[Former Member · Accepted solution]

Hi Vicky Sai,

The standard report is S_PH9_46000223 - EEs Entered and Left

If you want to obtain the numbers in the same screen you should do the following1

1 - access the report

2 - further selection button - select Action type and move it to the Selection fields (you will get it on the screen)

3 - select action Hiring and action Leaving (so that the report will only count these elements)

4 - Period - current month

5 - run the report

6 - you will now have to see the number of employees (unfortunately you cannot do Sum here as you could do in a Querry that you would build as you would add the Count field so we need to do a little trick)

7 - Change layout icon - View tab- select Preferred view instead of SAP List viewer ->Microsoft Excel

8 - Select a template - press save

9 - You will see now the report in the Excel format. You can do sums if you want, add formulas, or you simply delete the first line and just look at the latest line filled in (total number of EE who left or were hired during the month)

If you do your own Querry - you can skip the Excel part and make a screen variant with the Sums.

At least now you have 2 options that you can choose from

Regards,

Adriana

[Former Member · Accepted solution]

Hi Adriana,

Thank you very much for the answer.It definately helps me.

Another requirement is we have to fetch the gross salary sum of newly joined employees and Left employees in the particular month.

And also is there any possibility to get the difference between headcount of employees and gross salaries for any two months.

Please advice.

Regards,

V Sai.

[Former Member]

Hi,

Please check the report S_AHR_61016369.

Menu Path: SAP Easy Access --> Human Resources --> Information System --> Reports --> Personnel Management --> Administration --> Employee --> Employee List.

Regards,

Srini.

[Former Member]

Hi,

There's a report called RPSDEV00 that you can use for this purpose.

Kind rgerads,

Andrzej

[Former Member]

Hi,

Please run S_AHR_61016373 report.

Thanks!

Regards,

Chetan

[sikindar_a]

There is standrad Report for this did you have look towards it in case of custom report pull the data based on employee active status

for out project we have gone for BI report

[jananipriya]

Hi Sikindar,

I'm trying to calculate total no of employees in a month based on the joining date & leaving date in a company.

I'm working on creating BW report so Can u plz share ur experience by how u created the BI report?

It will be really helpful if u give me an detailed scenario.

Thanks in Advance