Skip to Content
Former Member
Jan 24, 2009 at 07:03 AM

Multiple Where condition problem


hi experts,

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

For E.g


12.03.2007 31.12.9999

17.03.2006 11.03.2007

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


Rachel Arun