Skip to Content
-1
Mar 04, 2017 at 05:05 PM

which one is better performance between loop and select query.

161 Views

Hi Experts,

I have a question for ABAPER, in my program fetching data from BKPF table based on input fields BELNR, GJAHR and XBLNR. Here XBLNR is a non primary key field, so when data volume is huge system giving dump at BKPF table select query. Anyone can help on this whether i need to create secondary index for BKPF table or I need to fetch data based on BELNR and GJAHR then in loop i will filter by xblnr.

Which one is better performance.

Thanks,

Pradeep.