How many maximum number of fields can be in a table ?

[Former Member]

How many maximum number of fields can be in a table ?plzz tell

Edited by: Alvaro Tejada Galindo on Feb 13, 2008 3:45 PM

[Former Member]

Any no of fields possible.

[Former Member]

The pgm will be stored in a table in the databse server, table name is TRDIR

<REMOVED BY MODERATOR>

Edited by: Alvaro Tejada Galindo on Feb 13, 2008 3:47 PM

[Former Member]

No limit

[naimesh_patel]

1024 fields for the Database tables.

Check this help:

http://help.sap.com/saphelp_nw04/helpdata/en/41/bf33c977c7f240832dcd166653ec29/content.htm

Regards,

Naimesh Patel

[Former Member]

I dont think there is a limit on number of fields. But there is a limit on the sum of the field lengths which 4030 chars.

Thanks

Romit

[former_member125931]

There is no limitation on fields.

[Former Member]

u can have 255 fields in a table not more than that

[former_member182485]

And finally the currect answer is

Number of columns in each table (with KEY) 1024

Number of columns in each table (without KEY) 1023

Regards

Bikas

[Former Member]

Hi srinath,

Number of field in each table (with KEY) =  1024 
Number of field in each table (without KEY) = 1023

*Total number of field in one table = 2047 fields

*

Best of luck,

Bhumika

[Former Member]

Hi,

The 4.7 version of SAP had the following characteristics:

50 characteristics

120 value fields

249 fields in table

1948 bytes of table width

The new 6.0 version has the following:

50 characteristics

200 value fields

749 fields in table

4030 bytes of table width.

do let me know if useful

Manish

[Former Member]

Hi Srinath,

A table can have 249 fields out of which we can have 16 primary keys.

Regards,

Swapna.

[Former Member]

Hi,

Max of 255 fields and in which we can have Max 16 primary key fields..

Regards

Narin Nandivada

[Former Member]

Hi Srinath.

I would like to suggest,

The maximum number of fields in a table can be maximum upto 9999 fields.

The field POSITION in table DD03L has a length 4

this defines the position of field in a table.

Hope that's usefull.

Good Luck & Regards.

Harsh Dave

[Former Member]

hi check this..

there may be 1024 fields in the database table with key

or there may be 1023 fields in the database table without key

dut defaultly they are 256