Data loading optimization

Case 1. C_PREF (Loading time from 70 minutes to 4 minutes)

1. DTP Changes
   1.1 Setup the Semantic Group 2
   1.2 Package size 2
2. Tuning the ABAP Code in the Start Routine 3
   2.1 Made changes to internal table declaration 3
   2.2 Replaced COLLECT Statement with APPEND : 4
   2.3 Bypassed collecting the data into an internal table in a loop 4
   2.4 Added the condition ‘OBJVERS = ‘A’ ’ in the where clause of the select statement 5
   2.5 Created secondary index on the IO 0SLL_PROD on the filed /BIC/C_PRNO -

Case 2. CUB_RKWA (Loading time from 23 minutes to 2 minutes)

1. Change routine mapping at field move to end routine
2. Use End routine and send internal table instead of each record