Table

[Former Member]

In a table maximum how many columns can we have?

[Former Member]

Hi,

you can have any number of fields provided they dont cross the total size of each record to 255 characters

Check this link..

http://www.sapdb.org/7.4/sap_db_features.htm

Regards,

Omkar.

[former_member188829]

Hi,

Check this link..

http://www.sapdb.org/7.4/sap_db_features.htm

[Former Member]

Which table u r talking about:

1. If it is internal table in a program then in normal report you can have your columns up to 255 character.

if report or program is an ALV one it can extend upto 90 columns.

2. If it is DDIC table u can have any number of columns.

[Former Member]

A maximum of 1024 columns can be specified for one table

Check this link.

http://help.sap.com/saphelp_nw04s/helpdata/en/6d/5df0ed034111d5aa2c00a0c9430730/frameset.htm

Regards,

Maha

[Former Member]

Hi,

Maximum number of columns in a table --> 256

Maximum lenght of a row in a table -- > 64KB

In DB2 Version 8 the max length of a row is 32K not 64K.

The max number of tables in a join is 225 (for many releases 15 tables was the max but not any more, version 8 is a beast of a release, the biggest ever in db2 history)

and the max number of columns in a table is 750 (it's been 750 since Version 3 in 1991 prior to that it was 300).

regards,

vasavi.

reward if helpful.