Skip to Content
0
Former Member
Dec 13, 2007 at 02:30 PM

Select statement....using wild character

23 Views

Hi All,

SELECT EKGRP EKNAM FROM T024 INTO TABLE IT_T024 WHERE EKGRP = S_EKGRP AND EKNAM NE 'NOT VALID%'.

My requirement is to eliminate the EKNAM (Purchasing Group Name) starting with NOT VALID string.

Any hint...

Thanks,

Kal Chand