I've a scenarion in which I want to fetch the data from BSAK in the below format:
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.