I have a situation where I need to select few fields from a std table to my internal table based on certain crtiteria and one of the criteria is if the field indicator is "X" then it should not insert the data in the internal table, can you please tell me how to write this statement. my table name is it_tab abd std table let say xyz and the field name is "OPEN".
so the statement should be:
select * from xyz into tabke it_tab
where name = 'ravi' and
bukrs = c_bukrs and
open ne 'X'.
is the above statement right?
looks ok to me. what is the problem?