08-03-2009 7:26 AM
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.
08-03-2009 8:53 AM
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
08-03-2009 9:07 AM
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
08-03-2009 9:47 AM
no difference ... discussed very often.
Both use array interface to the database.