topic Re: select query in Application Development and Automation Discussions

select query

Former Member — Tue, 27 Nov 2007 05:42:57 GMT

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

Re: select query

Former Member — Tue, 27 Nov 2007 05:48:12 GMT

what amarnath..? check out once..plz..if au r ausing the for all entries condition ur basic thing is to check the ionternal table is initial or not..

if the internal table is not having any data ..it will fetch all the data..

ok..amar..i am expecting 10 points..from u ha..ha...good day take care..

Re: select query

Former Member — Tue, 27 Nov 2007 05:50:56 GMT

Hi,

1) try to sort the internal table and use it in the select query.

2) use sub joins.

reward points if useful.

Regards,

Niyaz

Re: select query

Former Member — Tue, 27 Nov 2007 05:51:33 GMT

Hello Satish,

The Itab is not initial, the lt_ekko contains the data,

after the query excution the table lt_eket contains only the entries that are in lt_ekko, but it also contains the entries which are failing my secong condition (menge > wenge)

Re: select query

Former Member — Tue, 27 Nov 2007 05:55:46 GMT

Hi Amar,

Your query cannot be done..

Instead if u r concentrating on performance...

if not it_ekko is initial.

select <required fields> into table lt_eket from eket for all entries in lt_ekko where ebeln = lt_ekko-ebeln .

if sy-subrc eq 0.

loop at lt_eket .

if it_eket menge gt lt_eket-wemng.

append lt_eket1.

clear lt_eket1.

endloop.

Regards,

kaveri...

Re: select query

Former Member — Tue, 27 Nov 2007 06:00:30 GMT

hai amar actullay i am not at desk but try this first write: greater copndition with the brackets if possibel or else without brackets also possible..and then use the equal to condition and post me the answer.

Re: select query

Former Member — Tue, 27 Nov 2007 06:01:33 GMT

use following code

select * into table lt_eket from eket for all entries in lt_ekko where ebeln = lt_ekko-ebeln and menge GT wemng .

L.Velu