topic Re: Internal Tables in Application Development and Automation Discussions

Internal Tables

Former Member — Wed, 22 Oct 2008 05:43:52 GMT

hi all ,

what is the maximum number of fields can i have in the internal tables ?

With Kind Regards

Vel

Re: Internal Tables

Former Member — Wed, 22 Oct 2008 06:06:49 GMT

Hello Vel Murugan,

The internal table size depends on the buffer storage.The settings will be done by the basis team. we can store lakhs or crores of records in the internal table if you are not able to store the number of records you ask the basis team that he will increase the buffer size for the internal table.

Re: Internal Tables

Former Member — Wed, 22 Oct 2008 06:12:19 GMT

hi ,

tks for your valuable answer ,

but i need the clarification for , number of fileds [ columns ] can be used in the internal table not for number of records .

Re: Internal Tables

Former Member — Wed, 22 Oct 2008 06:13:28 GMT

because i need the max no of fields can be used in the internal tables .

Re: Internal Tables

Former Member — Wed, 22 Oct 2008 06:13:57 GMT

Theoretically you can specify any number of columns

Only if the memory runs out you will get a dump like "Internal table cannot be extended"

Regards

Edited by: Rajvansh Ravi on Oct 22, 2008 8:15 AM

Re: Internal Tables

abdul_hakim — Wed, 22 Oct 2008 06:21:39 GMT

Hi,

Basically there are no limits on number of columns you can have for internal table.

Cheers,

Hakim

Re: Internal Tables

Former Member — Wed, 22 Oct 2008 06:28:01 GMT

Hi,

As far as the abap documentation materials i haveread i have found no specification for the columns.

So as far as my knowledge is concerned you can add n number of columns to your internal tables depending on what type of config has been set to your server by the basis team.

Thanks & Regards

Re: Internal Tables

Former Member — Wed, 22 Oct 2008 06:34:10 GMT

Same number of fields we can display as we can see in se16.try and explore.

Strange:you closed this thread by giving mark to Santosh Marupally but still its showing as open!!!!

has anybody else noticed the same?

Re: Internal Tables

Former Member — Wed, 22 Oct 2008 06:37:08 GMT

Yeah.

I noticed it. Even SCN got wexed of members who post such questions..so It is just going weird. :).

Edited by: Vishwa Sri Hari on Oct 22, 2008 12:07 PM

Re: Internal Tables

Former Member — Wed, 22 Oct 2008 06:42:26 GMT

now corrected.

What happened earlier?

Re: Internal Tables

Former Member — Wed, 22 Oct 2008 06:43:28 GMT

Now, for the first person who replied the question,intially the points were 10. Now he made it 2..:). So, it got rectified I suppose.

Re: Internal Tables

rainer_hbenthal — Wed, 22 Oct 2008 11:35:43 GMT

If you are working 8hours a day, 220 day a year, 40 years, and if you need 15 seconds to enter a columnname and a type/like clause, then you can have 16.896.000 columns.

Re: Internal Tables

Former Member — Wed, 22 Oct 2008 12:03:28 GMT

Hi,

You can get your problem resolved from the following thread.

Hope it will be useful for you.

Thanks.

Nitesh

Re: Internal Tables

BH2408 — Wed, 22 Oct 2008 12:09:00 GMT

Hi ,

There is no limit that these many fields need to there in the internal table . it totally depends on the buffer and work process of the appication server .BASIS consul they will take of these things.

Regards,

Bharani

Re: Internal Tables

Former Member — Wed, 22 Oct 2008 18:31:18 GMT

SAP tables are limited to 9999 fields by table DD03L. Of course you could get around that with includes and appends. But on behalf of my fellow BASIS admins, if you need that many fields you're probably doing it wrong. B)