04-23-2007 3:29 PM
what is the maximum storage capacity of internal table.
i mean how many maximum records an internal table can have?
04-23-2007 3:31 PM
04-23-2007 3:32 PM
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.
04-23-2007 3:34 PM
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
04-23-2007 3:34 PM
"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
04-23-2007 3:55 PM
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