I face a small criticality in finishing the report since
the requirement has been changed .
The below select stmt works perfectly for fetching
Employee no betwen the start date and End Date
Select pernr begda endda rtamt from pa0581
into corresponding fields of table it_pa0581
where pernr in so_pernr and
begda >= pr_begda and
endda <= pr_endda .
But, ...Now, the requirement is that
START DATE ENDATE
if i give the input as 17.03.2006 and 12.03.2007 means
it will fetch only the second row of the e.g data i have
specified above, but they say since 31.12.9999 is considered
as active it(i.e the first row ) it also shud come in the output....
Therefore 2 rows has to be selected in the output for given input.
Iam bit confused how to change the select according,
Please do help me out....
Thanks in Advance