Data fetching problem
I have faced one problem.I want to fetch data from table COEP where VRGNG ne KOA*.It means I want that data whose VRGNG not starting with KOA.I have written the code which is written under..
SELECT * INTO CORRESPONDING FIELDS OF TABLE wcoep2
INNER JOIN zpm_cost
on coep~kstar = zpm_cost~kstar
FOR ALL ENTRIES IN waufk
WHERE coep~objnr = waufk-objnr
AND coep~vrgng NOT IN ('KOA%')
AND coep~kokrs = 'SRL1'
AND zpm_cost~ACTIVITY = 'PARTS'
AND TIMESTMP > ld_timestmp.
But,unfortunately this code is triggering KOA* data also.
Please have a look and give me the solution..