1. How To Modify One Field Of Internal Table In Sap Abap
2. Update And Modify Statement In Sap Abap Performance Chart
3. Update And Modify Statement In Sap Abap Performance Test

In ABAP, MODIFY statement can be used with. Database tables. Internal tables. Index tables. Lists. ScreensMODIFY statement is used for changing the current content value.

Ralph,All the instructions that use a where are implemented looping the internal table (sequential scan). Thus, if the table holds a huge number of records and you want to delete a few, delete where is not the best choice you've ever made. Even then, is fast enough.The fastest method I've ever tried is working with hashed tables and moving the non 'alive' records to a new table inside a loop with a check. You don't avoid the looping over the whole table (even if you use delete where), but you avoid that housekeeping stuff (updating indexes for example).Horacio.

How To Modify One Field Of Internal Table In Sap Abap

Sorry but, you must be kidding.and. 3d garden designer deluxe edition. Do you really think that removing the loop, the update to millions of records won't take a sometime?Basic stuff in the operation of a program: each update you perform takes sometime (microseconds, milliseconds or whatever.). Let's put it with some numbersupdate time - 0.005 secondsrecords to be processed - 1000000total time to update 0.005. 1000000- 5000 secondsif the time were 0.00005 secs - total time = 50 secs.Keep in mind that the table resides in memory and although ram is fast, access to it is not immediate.

Update And Modify Statement In Sap Abap Performance Chart

(it takes some time to access each block of memory).PS: BTW. (are you really a Software engineer.?). There are many ways to improve the update performance in your loop. You may have to be a little creative.Use field symbols so you can update your field directly without having to use a modify statement. Use hashed tables, make sure your table is sorted properly - maybe even re-design your table so the sorting of your records makes them move to the top so they process first.You really need to step back and take a good look at how much data you really have, how long is it taking to process currently and whether that is an acceptable amount of time.also, you can always place a set of code in the Performance Tips and Tricks and run it side by side with your original code to see how changes affect performance.SE80 - Environment - Examples Performance Examples. As John said you have to be bit creative hereHere what I would doIf the input to you processing is a file then read one record at a time using dataset command. It is very efficient, however if the input to your processing is database read (select) then you can use 'open cursor' select.

Update And Modify Statement In Sap Abap Performance Test

It allows you to read number of records at the time (eq. 1000), then go to your internal table processing, once finished go back to database read fetch another 1000 recs etc etc.Here is how I used it to resolve similar problem1.