My requirement is not to select the entries for the T024 table where the eknam is either starts with 'NOT VALID' or blank.
For that, I have written the select statement using NOT LIKE,
Will this negation in the select statement cause extra execution tiem?
If so, can you give some hint for alternative statement.
SELECT EKGRP EKNAM FROM T024 INTO TABLE IT_T024
IT_PURC WHERE EKGRP = S_EKGRP AND EKNAM NOT LIKE 'NOT VALID%' AND EKNAM NOT LIKE ' '.