topic Re: HR in Application Development and Automation Discussions

HR

Former Member — Fri, 28 Mar 2008 16:10:09 GMT

Hi guyz,

my requirement is..my program should calculate the total number of hours the employee is absent with in the given period..

for eg : 1-03-2008 to 31-03-2008

In the table iam having begda = 28.02.2008

endda = 03.03.2008

what program should do is calculate the hours the employee was absent with in the given time now it should calculate only three days ..the answer iam looking for is 24 hours coz 28.02.2008 is outta my range..can anybody help me out ...

thanks

Re: HR

Former Member — Fri, 28 Mar 2008 16:15:15 GMT

hi ,

go to the table pa2001 and see the field STDAZ for abasent hours

regards,

venkat.

Re: HR

Former Member — Fri, 28 Mar 2008 16:18:07 GMT

thanks for your reply ...in the table pa2001 begda = 28.02.2006 endda = 03.03.2006, stdaz is 32 hours but my logic should ignore 28.02.2006 coz period ive given is 01.03.2006 to 31.03.2006 and also the total hours i should have is onli 24 hours...plz advise..

regrds

Re: HR

Former Member — Fri, 28 Mar 2008 16:27:45 GMT

hi ,

do like this

v_date = s_date-low -1.

select pernr

begda

endda

STDAZ

from pa2001

into table itab

where pernr in s_pernr

and begda le s_date-high

and endda ge s_date-low.

regards,

venkat.

Re: HR

Former Member — Fri, 28 Mar 2008 16:34:50 GMT

thanks for your reply....

s_low = 1.03.2006

s_high = 30.03.2006

i need the calculate the number of days the employee absent with in this specified dates

if employee is absent from 23.02.2006 to 4.03.2006

i should calculate only 4 days .....my answer shud be 4 X 8(no of working hours a day) = 32 ...

plz advise

regards