36 - ABAP Programming - Best Performance Guidelines(Parallel Cursor) Part6

Best Programming Guidelines Covered:
-Use Parallel Cursor in nested loops.

[@Rajasekharabap]

U are god sir thank u Now clearly understood when we go for read table,nestedloops,parellel cursor

[@sapabapbyrahulmehta]

Great Rajasekhar 👍

[@mohammed5711]

Crystal clear explanation. Thank you so much sir

[@sapabapbyrahulmehta]

Thank you very much.

[@vikharkhan3953]

Great explaination. I have a question. Does the sy-tabix returns current loop iteration or returns the index number from where data transferred to work area?

[@sapabapbyrahulmehta]

Thank you. If you are Looping or reading based upon a condition then in that case, it will return the index of the matching record based upon that condition. In some cases, we need index of matching record in that case we don't even use work area.

[@sairahulreddy9127]

Heloo sir my query is - Loop at it_data1 into lwa_data1 from lv_index . Let say lv_index is 4 so it read from 4th row after that how it read from 5th row because we havent incremented lv_index it should always read from 4th row only please clarify this is from v_index will work only for first time from next time it will not consider. ???

[@sapabapbyrahulmehta]

LOOP means - It will process the records one by one. If loop is processing for 4th record, so in next iteration, it will process the record 5, 6 and so on. We started the loop from Index - 4, but it will point to next record in next iteration.

[@grzewicz1109]

Hi. Thanks for great explanation. From my understanding, each loop has its own sy-tabix value, right? When these values are reseted? When program finishes?

[@sapabapbyrahulmehta]

Hello Grewicz, Thank you for the feedback. Your understanding is right, each loop has it's own sy-tabix value. When the loop ends, it will reset at that time.

[@grzewicz1109]

@@sapabapbyrahulmehta but the internal loop keeps its sy-tabix incrementing even when external loop goes to next iteration ( its tabix goes from 0 to 1). Does that mean that inner loop is truly finished (sy-tabix resets) only when outer loop, that contains it, is finished?

[@sapabapbyrahulmehta]

@@grzewicz1109 When we see any internal table in the Debugging Mode, the first column is always the index of the rows, the name of the colum is ROW. Whatever the records processed in the first iteration Internally it will mark as processed and in the next iteration SAP simply check the value of ROW column for the new record and that will act as SY-TABIX.

[@sireeshaande9102]

Hi, can we use parallel cursors for more than 2 loops..?

[@sapabapbyrahulmehta]

If you have 3 nested loops, then same way we will apply parallel cursors for 3rd loop also.

[@sireeshaande9102]

@@sapabapbyrahulmehta ok sir, Thank you.

[@sapabapbyrahulmehta]

@@sireeshaande9102 👍

[@yuvrajkarwar4713]

Sirji, what if key columns are not in order?

[@sapabapbyrahulmehta]

Hello Yuvraj, Can you please explore your query?

[@GauravSingh-lz8mb]

@@sapabapbyrahulmehta I have the similar question sir, What if it is not in sequence as Order No 1,2,3,4,5,6 and so on. What if the order numbers are like 001abc, 005xyz, means the sequence is not followed it could be anything numeric characters. then how can do this parrellal cursor sir?

[@sapabapbyrahulmehta]

@@GauravSingh-lz8mb Hello Gaurav, order number is a numeric field, So a-z is not allowed. It will only accept numbers.

[@user-bl8vw3pm2s]

@@sapabapbyrahulmehta Sir, So can we say that for implementing parallel cursor conditional column of both the internal table should be sorted?

[@sapabapbyrahulmehta]

@@user-bl8vw3pm2s At least the inner internal table on which we are applying the Binary Search, that must be sorted.

[@AliAsim-ks8br]

Hi Rahul Do you give online training on Abap?

[@sapabapbyrahulmehta]

Hello Ali. I am not providing any online training as such,but if you stuck somewhere, you can ask those queries.

[@AliAsim-ks8br]

@@sapabapbyrahulmehta thanks for the reply, can you pls share your email. thanks Ali

[@sapabapbyrahulmehta]

@@AliAsim-ks8br My Email address is [e-mail].

[@charan3059]

In the parallel curser also we have do the bug analysis like if we add new record in header table. It was not reflecting in the output. You have explained about bug analysis for the normal process. Do We have to do the same process for the parallel cursor? kzbin.info/www/bejne/qmqrYZR9ls1mpdksi=2VUvDPlWGQ96WQXv

[@sapabapbyrahulmehta]

Yes. As the requirement is same. You can add there also.