Performance wise which one is better: loop inside select single or select outside loop and reading inside loop

Former Member — Fri, 19 Oct 2012 07:50:42 GMT

Hi All,

I am having code like shown below...

loop at it_vbeln.

SELECT * FROM vbfa WHERE vbeln = it_vbeln-vbeln.

SELECT SINGLE * FROM vbkd WHERE vbeln = vbfa-vbelv.

endloop.

whether can i use the select statements outside the loop?

select VBELN

POSNR

KDGRP

PLTYP

from vbfa

into table it_vbfa

for all entries in it_vbeln

where vbeln = it_vbeln-vbeln.

after that...

loop at it_vbeln.

read table it_vbfa into wa_vbaf with key vbeln = it_vbeln-vbeln.

endloop.

Which one is better....inside loop select single is better or use select outside the loop and read the table...

But when i seen the execution time select single inside loop is taking less time as compared with select outside loop and reading inside loop.

Please advise.

Ram

Re: Performance wise which one is better: loop inside select single or select outside loop and reading inside loop

kesavadas_thekkillath — Fri, 19 Oct 2012 07:58:37 GMT

Moderator message : There are several discussions already available to related topics. Please search for it in SCN. Do the performance analysis yourself using the various transactions available in SAP( please search for it again ).

topic Re: Performance wise which one is better: loop inside select single or select outside loop and reading inside loop in Application Development and Automation Discussions

Performance wise which one is better: loop inside select single or select outside loop and reading inside loop

Re: Performance wise which one is better: loop inside select single or select outside loop and reading inside loop