Skip to Content

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

select query

Hello All,

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

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