Internal Table size

[Former Member]

Hi Experts,

Is there any limitation to the size of an internal table..say in terms of no of records?

In a simple term how many records at the max an internal table hold??

I would reward points for uselful answers!

[Former Member]

Hi Sudha,

yes there is a limit to the no. of records.

But the no. of records are calculated based on the size of the record. Lets say you have only two fields in the table then the no. of records are much higher than the table with 10 fields.

I just cann't remeber the exeact size but it is some 50 KB.

I will let you know the size of the same.

Regards,

Atish

[Former Member]

Thanks a lot..do let me know the correct size of the interna table.. i appreciate your help and woud reward points!

[Former Member]

Hi Sudha,

I think at the start it is 8 kB and then can be extended in 12KB interval, but it also does has a limit.

Not very sure how much the limit but from my exp I can say you can have around 40-50K records in the table.

Reward points if useful.

Regards,

Atish

[Former Member]

basically its 8kb and we can extend

see the system variables to find out run time memory sy-toccu

Reward Points if it is helpful

Thanks

Seshu

[Former Member]

Hi

When you are creating an internal table with occurs clause you are assigning size also.For eg: Data:Begin of ITAB OCCURS 0, means it will assign 8KB of memory automatically. Then Whenever the internal table is filled with 8 KB again system will assign another 8 KB and it will go on....

But if insted of OCCURS 0, if you ar especifying other numbers the meaning will change. If you are specifying OCCURS 5, the system will assign memory for another 5 Rows(according to the structure of your internal table). This is the most efficient way than that of using 0. This will save a lot of memory. The maximum size of an internal table may be upto 2 GB. But its according to the availability of your memory. In a more clear way it will be upto 500 MB.

Hope this will help you.

Reward All Helpfull Answers.......

[Former Member]

Hi,

See if u have given the size of a record as occurs 0 then it occupies only 8kb n if u give it as occurs 1 then it gets doubled...soit depends upon the size of the records u take n i think u can take upto 500 mb.

if useful reward with points.

with regards,

madhuri.

[Former Member]

Hi,

Please find the information given by SAP people on internal table storage capacity under the heading <b>Internal Tables as Dynamic Data Objects .</b>

<a href="http://help.sap.com/saphelp_nw2004s/helpdata/en/fc/eb35de358411d1829f0000e829fbfe/content.htm">http://help.sap.com/saphelp_nw2004s/helpdata/en/fc/eb35de358411d1829f0000e829fbfe/content.htm</a>

-SatyaPriya