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).