Skip to Content
0
Former Member
May 14, 2008 at 06:48 PM

How to avoid a select statement in a loop

15 Views

Hi can any one tell how to write the below select statement with out loop, to get the desire output as below.

if i_bkpf[] is not initial.

loop at i_bkpf into wa_bkpf.

select belnr gjahr lifnr xblnr

appending table i_rbkp

from rbkp

INTO CORRESPONDING FIELDS OF TABLE I_RBKP

FOR ALL ENTRIES IN I_BKPF

where belnr = wa_bkpf-awkey+0(10)

and gjahr = wa_bkpf-awkey+10(4).