Skip to Content
0
Former Member
Aug 03, 2009 at 06:26 AM

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

28 Views

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.

or

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.