Effective Loop

[Former Member]

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

loop at itab into ws_itab where a = b.

delere record.

endloop.

ENDIF.

ENDLOOP.

OR**************************************************************************

LOOP at BKPF where belnr = ws-Belnr.

loop at itab . -

---

Enter the LOOP ITAB and then check condtion

IF i_bkpf-blart = 'A1'.

delete record.

elseif i_bkpf-blart = 'B1' .

delere record.

endif.

endloop.

ENDLOOP.

[Former Member]

Hi,

The second loop is more efficient.

Thanks,

Preetham S

[Former Member]

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

[Former Member]

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

loop at itab into ws_itab where a = b.

delere record.

endloop.

ENDIF.

ENDLOOP.

**************************************OR*************************************************************************

LOOP at BKPF where belnr = ws-Belnr.

loop at itab . Enter the LOOP ITAB and then check condtion

IF i_bkpf-blart = 'A1'.

delete record.

elseif i_bkpf-blart = 'B1' .

delere record.

endif.

endloop.

ENDLOOP.

[Former Member]

Both are bad. You should use READs with BINARY SEARCH instead. Please see:

[Performance of Nested Loops|]

Rob

[Former Member]

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.

Regards,

Yogita

[Former Member]

The blog shows one way to do exactly that.

Rob