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

Multiple Where condition problem

168 Views

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

START DATE ENDATE

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

Regards

Rachel Arun