Skip to Content
0
Former Member
Feb 25, 2009 at 11:26 AM

RETRIEVE DATA FROM DATABASE

37 Views

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