Internal Tables

[Former Member]

hello sap gurus,

How we come to know how many records maximum an internal table contains ? can any one tell me ?

regards,

vijaya.

[naimesh_patel]

It will depend on your system memory settings.

Exerprt from the help:

Data objects that are defined either with the data type of an internal table, or directly as an internal table, are always fully defined in respect of their line type, key and access method. However, the number of lines is not fixed. Thus internal tables are dynamic data objects, since they can contain any number of lines of a particular type. 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. The line types of internal tables can be any ABAP data types - elementary, structured, or internal tables. The individual lines of an internal table are called table lines or table entries. Each component of a structured line is called a column in the internal table.

Link to help:

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

Regards

Naimesh Patel

[Former Member]

Hi,

It usually varies depending on the settings set by Basis people. Basis people will allocate some memory to the internal tables. So if it is crossing that memory it will give. Usually we check the memory in terms of BYTES not in terms of records.

For eg: One internal table has 4 fields and 30 records and think that this is the maximum limit. If we append more records it will give you dump.

Another internal table is having 2 fields and having 50 records.

So it all depends on the length of each field and number of records. So total in bytes only. You can check with your basis team.

Regards,

Venkatesh

[Former Member]

Hi.

Try to tell with BASIS, they can tell you what's the max number of bytes allocated to an internal table.

Regards.

Edited by: Rodolfo Oliveira on Aug 15, 2008 3:44 PM