2008 Oct 30 8:19 PM
Hi Guys,
can you please let me know which is less time consuming LOOP selection?
LOOP at BKPF where belnr = ws-Belnr.
IF i_bkpf-blart = 'A1'. ...........................check the condition and enter in loop ITAB
loop at itab into ws_itab where a = b.
delete record.
endloop.
ELSEIF i_bkpf-blart = 'B1' . check the condition and enter in loop ITAB
delere record.
ENDIF.
ENDLOOP.
OR**************************************************************************
loop at itab . -
Enter the LOOP ITAB and then check condtion
IF i_bkpf-blart = 'A1'.
elseif i_bkpf-blart = 'B1' .
endif.
2008 Oct 30 8:44 PM
Both are bad. You should use READs with BINARY SEARCH instead. Please see:
[Performance of Nested Loops|]
Rob
Hi,
The second loop is more efficient.
Thanks,
Preetham S
2008 Oct 30 8:32 PM
2008 Oct 30 8:35 PM
Hi ,
But the second loop LOOPs across all the records of ITAB and then check condition.
And first one just LOOPs when condition is met.
What do you say?
Regards,
Yogita
2008 Oct 30 8:37 PM
**************************************OR*************************************************************************
loop at itab . Enter the LOOP ITAB and then check condtion
2008 Oct 30 8:53 PM
Hi Rob,
But as per the requirement, I need to select multiple records and hence I need to use LOOP instead of READ which selects single record.
Please advice.
2008 Oct 30 9:16 PM
The blog shows one way to do exactly that.
Bluesky
