topic Re: Table in Application Development and Automation Discussions

Table

Former Member — Fri, 04 Jan 2008 09:42:24 GMT

In a table maximum how many columns can we have?

Re: Table

Former Member — Fri, 04 Jan 2008 09:45:03 GMT

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.

Re: Table

former_member188829 — Fri, 04 Jan 2008 09:46:23 GMT

Hi,

Check this link..

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

Re: Table

Former Member — Fri, 04 Jan 2008 10:07:01 GMT

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.

Re: Table

Former Member — Fri, 04 Jan 2008 20:58:55 GMT

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

Re: Table

Former Member — Tue, 08 Jan 2008 09:28:10 GMT

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.