Skip to Content
0
Former Member
May 12, 2010 at 10:40 AM

Which will give the better performance

18 Views

Hi Friends,

I've a scenarion in which I want to fetch the data from BSAK in the below format:

bukrs

augbl

auggj

kostl

prctr

gsber

aufnr

lifnr

umskz

augdt

gjahr

belnr

buzei

budat

bldat

cpudt

waers

bschl

shkzg

mwskz

dmbtr

wrbtr

sgtxt

saknr

hkont

Now my question is that which approach would be better for the performance purpose whan I'm supposed to fetch 3-4 lac records in one go:

1. Select into corresponding fields of table

2. or select in one table which is having records in the same sequence as in BSAK & then pass records to different internal table having above sequence by looping

3. Or any other appraoch

Please advise. I've to fetch around 3 lac records in one go & then process further.

Thanks:

Gaurav