max fields in a Z Table

[Former Member]

Hai Friends,

what is the maximum number of fields i can create in a Z Table?. Is there any restrictions.

[Former Member]

It should be dependant on the underlying database, for Oracle database table there is limitation of 254 fields max.

[Former Member]

Hi Vennila,

Check this

hope it helps you

Thanks!

[Former Member]

Hi Vennila,

Please have look at the constraints below for the Table Creation:

Constraints

All the key fields of a table must be stored together at the beginning of the table. A non-key field may not occur between two key fields.

A maximum of 16 key fields per table is permitted. The maximum length of the table key is 255.

If the key length is greater than 120, there are restrictions when transporting table entries. The key can only be specified up to a maximum of 120 places in a transport. If the key is larger than 120, table entries must be transported generically.

A table may not have more than 249 fields. The sum of all field lengths is limited to 1962 (whereby fields with data type LRAW and LCHR are not counted).

Fields of types LRAW or LCHR must be at the end of the table. Only one such field is allowed per table. There must also be a field of type INT2 directly in front of such a field. The actual length of the field can be entered there by the database interface.

Please have a look at this following link which will give you complete details:

Constraints

http://help.sap.com/saphelp_webas620/helpdata/en/cf/21ea31446011d189700000e8322d00/frameset.htm

Thanks,

Samantak.

[Former Member]

hi

A Table can have

1) Not more than 249 Fields & the sum of all the field lengths is limited to 1962.

2) Maximum of 16 key fields & maximum length of table key is 255.

Regards

[Former Member]

Dear vinnela,

A table may not have more than 249 fields. The sum of all field lengths is limited to 1962 (whereby fields with data type LRAW and LCHR are not counted).

A maximum of 16 key fields per table is permitted. The maximum length of the table key is 255.

All the key fields of a table must be stored together at the beginning of the table.

A non-key field may not occur between two key fields.

Cheers

Fareed

[former_member632729]

Hi Dude,

Max fields in a table is 249 only.. not more than that..

Edited by: Raghunath Shyamala on May 25, 2009 7:49 AM

[Former Member]

This message was moderated.