i would like to select all the entries from EKET table with menge is greater than wemng. for this i have written a query like
select * into table lt_eket from eket for all entries in lt_ekko where ebeln = lt_ekko-ebeln and menge GT lt_eket-wemng .
this is nor giving any error, but after execution i am also getting the lines in lt_eket that wont satisfy my condition .
can someone please suggest what would be the right query?
(selecting into internal table , looping through it and deleting the entries is causing lot of performance problem)
is there any solution with single query
Thanks in advance
Amarender Reddy B