Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

Data fetching problem

Hi Experts,

                 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             

                 FROM coep             

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

Not what you were looking for? View more on this topic or Ask a question