My requirement is that I should not display the data on a specific date.

Given the select query below it should not display the dates which are present in not condition but in my output I could still see the dates which are present in not condition.

REPORT Z_SANJAY_INTERNALTABLES_06.

Tables : EKKO.

Select-options : S_dates for ekko-bedat .

Data : Begin of WA_ekko ,
       WA_EBELN type ekko-ebeln ,
       WA_bedat type ekko-bedat ,
       WA_lifnr type ekko-lifnr ,
       WA_bukrs type ekko-bukrs ,
       end of WA_ekko .

Data : IT_ekko like table of WA_ekko .

select ebeln bedat lifnr bukrs from ekko into table IT_ekko where bedat in S_dates and bedat <> '02.11.2000' .

Loop at IT_ekko into WA_ekko .

write :/ WA_ekko-WA_EBELN ,
         WA_ekko-WA_LIFNR ,
         WA_EKKO-WA_BUKRS ,
         WA_ekko-WA_bedat .
endloop.