Hi Experts,
Hi friends,
I need a logical solution.
I have 10 yrs employees data. I have upload only basic salary through bdc in database table.
I have a MODULE POOL screen, On screen date(23.02.2009 format) field and emp. no. is available.
I have several records of April(2001,2002........2009) ,May(2001,2002, 2003.......2009)..........Jan(2001,2002, 2003..........2009) . To neglect the overwrite of emp no. i have taken (empno, month, year) as aprimary key in database table.
My requirement is When i input date on screen like 23.02.2009 and employee no. of particular employee the whole data of current financial year (april 2008 to jan 2009) should be selected from the database table. Not a previous year (2006, 2007, 2008).
Plz reply as soon as possible.
Regards,
Swapnika