10-17-2006 6:52 PM
For Using FOR ALL ENTRIES, is there a limitation to the size of the Table it can Handle?
10-17-2006 6:55 PM
Hi Skaria,
I believe there is no limit. Only think we should keep in mind is there the internal table should not be empty. If it is empty it will select all the values from the table. Hence that NOT... IS INITIAL condition should be done before selection.
~thomas
10-17-2006 6:54 PM
I've never run into a problem, but performance may be an issue with a large table.
Rob
10-17-2006 6:55 PM
Hi Skaria,
I believe there is no limit. Only think we should keep in mind is there the internal table should not be empty. If it is empty it will select all the values from the table. Hence that NOT... IS INITIAL condition should be done before selection.
~thomas
10-17-2006 6:56 PM
No there is no limitation. If the internal can't able to handle the large set of data it will give give a dump and it will not come upto Select query.
Regards,
Prakash.
10-17-2006 8:05 PM
Hi Manoj,
1. When using for all entries in Select, ensure that the internal table does have atleast one entry as otherwise the entire target table is hit and performance is affected.
If not itab[] is initial.
Select... for all entries in itab...
Endif.
2. Not sure about the actual volume an itab can hold. However one can use extracts instead of internal tables.
3. Another option is to select data upto n rows and then write the processing logic within the Select .... End Select statements. Performance intensive and not usually done....
Regards.
10-17-2006 8:15 PM
Hi Manoj,
1)There is no limitation on table size to handle using FOR ALL ENTRIES.
2)But you should check a condition whether internal table is initial or not before using FOR ALL ENTRIES.
3)If you didnt specify this option, it may lead to incorrect results.
4)Size of internal table is always relies system configuration. You can have upto 2GB of content to an internal table.
Thanks,
Vinay
10-17-2006 8:39 PM
Hi Manoj,
There is no limitation to size of table but as everybody told make sure it is not empty otherwise you may lead to short dump.
When extracting data from DB table based on FOR ALL ENTRIES, don't forget to delete the duplicate records otherwise the performance will not be good.
Also prefer to use few records at one time when using FOR ALL ENTRIES (e.g. 20000) and your program will have good performance.
02-15-2007 3:02 PM
02-15-2007 3:03 PM
02-15-2007 3:03 PM