size of internal table.

[Former Member]

what is the maximum storage capacity of internal table.

i mean how many maximum records an internal table can have?

[Former Member]

there is no limit , you can store any no of records

[Former Member]

Hi Vamsi,

The storage capacity of internal table is based on the basis settings. Contact ur basis people to know the exact space allocated to this.

Regards,

Satya.

[Former Member]

The maximum memory that can be occupied by an internal table (including its internal administration) is <b>2 gigabytes</b>. A more realistic figure is up to <b>500</b> <b>megabytes</b>. An additional restriction for hashed tables is that they may not contain more than<b> 2 million entries</b>.

reward if it helps u

Vijay Pawar

[former_member181962]

"The only restriction on the number of lines an internal table may contain are the limits of your system installation. The maximum memory that can be occupied by an internal table (including its internal administration) is 2 gigabytes. A more realistic figure is up to 500 megabytes. An additional restriction for hashed tables is that they may not contain more than 2 million entries. "...

extracted from help.sap.com

http://help.sap.com/saphelp_nw2004s/helpdata/en/fc/eb35de358411d1829f0000e829fbfe/content.htm

Regards,

ravi

[Former Member]

Hi,

The minimum size of an internal table is 256 bytes. This is

important if an internal table occurs as a component of an aggregated data object, since even

empty internal tables within tables can lead to high memory usage. (In the next functional

release, the size of the table header for an initial table will be reduced to 8 bytes).

You can specify the initial amount of main memory assigned to an internal table object when you

define the data type using the following addition:

INITIAL SIZE <n>

This size does not belong to the data type of the internal table, and does not affect the type

check. You can use the above addition to reserve memory space for <n> table lines when you

declare the table object.

When this initial area is full, the system makes twice as much extra space available up to a limit

of 8KB. Further memory areas of 12KB each are then allocated.

You can usually leave it to the system to work out the initial memory requirement. The first time

you fill the table, little memory is used. The space occupied, depending on the line width, is 16

<= <n> <= 100.

It only makes sense to specify a concrete value of <n> if you can specify a precise number of

table entries when you create the table and need to allocate exactly that amount of memory. This can be particularly important

for deep-structured internal tables where the inner table only has a few entries (less than 5, for

example).

To avoid excessive requests for memory, large values of <n> are treated as follows: The largest

possible value of <n> is 8KB divided by the length of the line. If you specify a larger value of

<n>, the system calculates a new value so that n times the line width is around 12KB.

Regards,

Bhaskar