03-24-2008 8:55 AM
Hi ,
I want to calculate number of employees who hav taken excess days of leave in given period,ie if 3 days allowed to be absent for a month,i need who are all absent for more than 3 days in tht month.
plz help if u know.
thx and best regards,
Suchithra.
03-24-2008 9:04 AM
Hi,
Can you tell us about the table and the fields involved for this.
Regards.
03-24-2008 9:12 AM
Use FM : HR_GET_LEAVE_DATA
to get the leaves for a particular person in a month
and check if they are more than 3 ...
03-24-2008 9:25 AM
if u are maintaining the employee leave details in a table then u can do this requirement easily,
select emp from leavetable to internal table.
sort by empno.
clear count.
loop the internal table.
count = count + 1
at end of empno.
append empno & count to a new internal table
clear count.
end loop