topic Re: maximum record limit for internal table in Application Development and Automation Discussions

maximum record limit for internal table

Former Member — Wed, 17 Jan 2007 10:14:56 GMT

hello all,

can any one tell me what is the maximum limit of internal table. i would like to add all records from bseg to internal table. so i can improve processing time.

thanks,

raj

Re: maximum record limit for internal table

Former Member — Wed, 17 Jan 2007 10:16:57 GMT

hi Raj,

There is no Limit defined ..you can add as many number of records that you want to add ...

Regards,

Santosh

Re: maximum record limit for internal table

Former Member — Wed, 17 Jan 2007 10:21:50 GMT

Hello Raj,

There is no limit fo internal table records.

Declare the table with occurs 0 additon.

The table can hold any number of records.

If useful reward.

Vasanth

Re: maximum record limit for internal table

Former Member — Wed, 17 Jan 2007 10:26:18 GMT

thanks all

Re: maximum record limit for internal table

sourabhshah — Wed, 17 Jan 2007 10:27:47 GMT

hi,

Before Release 4.0A, ABAP stored the content of internal tables in a combination of main memory and file space. This means that the maximum size of all internal tables of all programs running on such an application server at one time is about 2 GB. With Release 4.0A or greater, this size decreases to about 500 MB. (Note that those values aren't fixed, but this is a good guide. This minimum of 500 MB is the lowest limit of the real value, which varies among different operating systems and even among different releases of the same operating system.)

It may sound strange that a newer release has a higher restriction on capacity. But it's a consequence of the fact that the contents of internal tables move from a reserved file to shared memory. When you process internal tables this way in Release 4.0A or greater, you pay for much better performance with a smaller potential size.

Regards,

Sourabh

Re: maximum record limit for internal table

Former Member — Wed, 17 Jan 2007 15:58:29 GMT

It is correct that there is no ABAP limit to the number of records that you can put into an internal table, but there are system memory limits. If you try to put all records from BSEG into an internal table, you will likely exceed this limit and dump.

Rob