Hi Experts,
Can you please give steps for the following requirement.Is there any standards available.Please explain the procedure to create report.
Points will be awarded fot the suitable solutions.
The report shouldl query SAP for the number of employees based on the personnel area and sub area. The main reporting is based on the sub area. If the employee is in the India Pers Area the total number of employees from each sub area will have to be deducted from the headcount for that sub area and added to the India area for headcount totaling. For each of the areas/subareas we need to gather the total number of Active Employees, Temp Employees and Contractors. This information can be gathered from the employee group.
i/p filed available table
Key Date
Employment Status PA0000
Personnel Area PA0001
Personnel Sub Area PA0001
Employee Group PA0001
Employee Subgroup PA0001
C stands for column C2 c3 c4 will be filled by users after running report.
c1 c2 c3 c4 c5 c6
SEIM 70 9 4 Pers Sub Area - FIN
NGUYEN 25 0 1 Pers Sub Area - MKT
LUHR 120 3 4 Pers Sub Area - SLS
DREW 532 78 2 Pers Sub Area u2013 OPS
CHOMA 35 2 6 Pers Sub Area u2013 ODLP
LIPPS 3 0 0 Pers Sub Area - GAA
INDIA 79 0 0 Pers Area - IND
TOTAL 864 92 17 0
Thanks and Regards,
Raj