Can store more than 2lack records in an Internal Table

[Former Member]

Hi! All,

Can we store more than 2lack records in an Internal table? if not whats the problem it gives and how to solve it?

Thanks,

Nagulan

[amit_khare]

Welcome to SDN.

Storage in internal Table does not depend on the number of records but depend on the memory they will be using.

An internal table allows maximum of 2GB of storage, this can be increased by applying some patch up to 4 GB but that will degrade the programs performance.

To resolve this limit the number of records while selecting and rerun the program as per required number of times.

Regards,

Amit

Reward all helpful replies.

[former_member404244]

Hi,

yes u can store more than 2lakhs of records.

Regards,

nagaraj

[Former Member]

Hi Nagul,

Try to insert large number of records without getting error,

if u got any error try to create one more internal table with same structre and insert remaining records into that second internal table....

reward points to all helpful answers

kiran.M

[Former Member]

Hi,

It is dependent on these profile parameters. Your system administrator will set these during installation and may be changed as needed.

"o ztta/roll_area (1.000.000 - 15.000.000)

Classic roll area per user and internal mode

usual amount of roll area per user and internal mode

o ztta/roll_extension (10.000.000 - 500.000.000)

Amount of memory per user in extended memory (EM)

o abap/heap_area_total (100.000.000 - 1.500.000.000)

Amount of memory (malloc) for all users of an application

server. If several background processes are running on

one server, temporary bottlenecks may occur.

Of course, the amount of memory (in bytes) must also be

available on the machine (main memory or file system swap).

Caution:

The operating system must be set up so that there is also

enough memory for each process. Usually, the maximum address

space is too small.

Ask your hardware manufacturer or your competence center

about this.

In this case, consult your hardware vendor

abap/heap_area_dia: (10.000.000 - 1.000.000.000)

Restriction of memory allocated to the heap with malloc

for each dialog process.

Parameters for background processes:

abap/heap_area_nondia: (10.000.000 - 1.000.000.000)

Restriction of memory allocated to the heap with malloc

for each background process.

Other memory-relevant parameters are:

em/initial_size_MB: (35-1200)

Extended memory area from which all users of an

application server can satisfy their memory requirement.

Reward if it helps..

Regards,

Omkar.

[Former Member]

Hi! All

Thanks to all.