Not Like in Select Statement

[Former Member]

Hi All,

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 ' '.

Thanks,

Kal Chand

[Former Member]

Hi All,

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 ' '.

Thanks,

Kal Chand

[Former Member]

Hello,

For the first condition: not starting with 'NOT VALID' , I don't know other way apart from yours: EKNAM NOT LIKE 'NOT VALID%'.

For the second one, not starting with blank: EKNAM NOT LIKE ' '. Does it work? I think it compares if EKNAM is different from blank which can be done using: EKNAM NE ' '.

I hope it will help you.

[Former Member]

Hi All,

I have used the string comparison operator "CS" in the internal table loop.

DATA V_STR1(9) VALUE 'NOT VALID'.

LOOP AT IT_T024.

IF IT_T024-EKNAM CS V_STR1.

CONTINUE.

ENDIF.

ENDLOOP.

Thanks,

Kal Chand