Reg: Select Query

Hi All,

the Custom Table consist of fields Company Code, Material, Vendor, date, Status, deletion falg

of which Comapany Code, Material and Vendor are key fields, Now the requirement is i need to select the records without deletion flag for this i have written a select quiry as

select bukrs matnr lifnr stuff datma loekz from <databasetabe> into <internal table>

where bukrs in s_bukrs and

matnr in s_matnr and

lifnr in s_lifnr and

loekz = ' '.

but it is fetching along with deletion flag as 'X' Please correct my code if there is any mistake Actually i need records without deletion flag.

Regards,

Kumar