Skip to Content
author's profile photo Former Member
Former Member

doubt in calculate absence days

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.

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

3 Answers

  • author's profile photo Former Member
    Former Member
    Posted on Mar 24, 2008 at 09:04 AM

    Hi,

    Can you tell us about the table and the fields involved for this.

    Regards.

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Mar 24, 2008 at 09: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 ...

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Mar 24, 2008 at 09: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

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.