topic Which is more efficient SELECT...ENDE SELECT OR SELECT INTO TABLE. in Application Development and Automation Discussions

Which is more efficient SELECT...ENDE SELECT OR SELECT INTO TABLE.

Former Member — Mon, 03 Aug 2009 06:26:14 GMT

Dear All,

which one is more efficient

SELECT

matnr bwkey bwtar belnr gjahr buzei buzid

shkzg dmbtr menge meins budat bldat blart

FROM bsim

INTO (it_bsim-matnr, it_bsim-bwkey, it_bsim-bwtar, it_bsim-belnr, it_bsim-gjahr, it_bsim-buzei, it_bsim-buzid, it_bsim-shkzg,

it_bsim-dmbtr, it_bsim-menge, it_bsim-meins, it_bsim-budat, it_bsim-bldat, it_bsim-blart)

WHERE

bwkey IN s_werks AND

bwtar IN s_bwtar AND

matnr IN s_matnr AND

budat IN s_budat AND

blart IN ('WA' , 'RE' , 'WL' , 'PR' ,'WE' , 'WI').

APPEND it_bsim.

ENDSELECT.

SELECT

matnr bwkey bwtar belnr gjahr buzei buzid

shkzg dmbtr menge meins budat bldat blart

FROM bsim

INTO table it_bsim

WHERE

bwkey IN s_werks AND

bwtar IN s_bwtar AND

matnr IN s_matnr AND

budat IN s_budat AND

blart IN ('WA' , 'RE' , 'WL' , 'PR' ,'WE' , 'WI').

Thanks in advance.

Re: Which is more efficient SELECT...ENDE SELECT OR SELECT INTO TABLE.

Former Member — Mon, 03 Aug 2009 07:53:43 GMT

Amit,

Please read the rules of the forum.. ur not supposed to post without doing some research on ur own... u can find several threads on similar questions...

also, u can run the select statements and see for urself which is more efficient..

Regards,

Bikash

Re: Which is more efficient SELECT...ENDE SELECT OR SELECT INTO TABLE.

Former Member — Mon, 03 Aug 2009 08:07:34 GMT

Hi Amit,

write 2 reports and each u fill with one Select.

Then, go to SE30, type in ure reports name and compare their runtime.

EDIT: In the upper left corner is a button called 'Tipps & Hints/Tricks'. Push it and u will be redirected to a performance analyse screen with very useful examples!!

Good luck!

Regards,

Zaya

Edited by: Tuncay Zaya on Aug 3, 2009 10:08 AM

Re: Which is more efficient SELECT...ENDE SELECT OR SELECT INTO TABLE.

Former Member — Mon, 03 Aug 2009 08:47:26 GMT

no difference ... discussed very often.

Both use array interface to the database.