Internal Tables

[Former Member]

hi all ,

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

With Kind Regards

Vel

[Former Member]

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.

[Former Member]

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 .

[Former Member]

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

[Former Member]

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

[abdul_hakim]

Hi,

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

Cheers,

Hakim

[Former Member]

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

[Former Member]

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?

[Former Member]

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

[Former Member]

now corrected.

What happened earlier?

[Former Member]

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.

[rainer_hbenthal]

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.

[Former Member]

Hi,

You can get your problem resolved from the following thread.

Hope it will be useful for you.

Thanks.

Nitesh

[BH2408]

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

[Former Member]

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)