error while creating database table

[Former Member]

Hi

I am creating a table with 2 key fields of length 255 chars each. its giving me error Key field is greater than 780. Please suggest.

Regards

Aditya

[former_member194669]

This will be constrains

ie maximum of 16 key fields per table is permitted and maximum length of the table key is 255.

a®

[Former Member]

Hi Aditya,

Please check the Link below.

[error while creating database table|http://help.sap.com/saphelp_nw04/helpdata/en/cf/21eb6e446011d189700000e8322d00/content.htm]

Thanks

Kalyan B

[Former Member]

Hi,

Since table key can be max of 255 length,we rarely make use of a single key field of 255,

so, reduce the length of field.

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.

Edited by: Sreesudha Gullapalli on Feb 6, 2009 8:19 AM

[Former Member]

Hi ,

Either you can have only one key field with 255 length or the length of the both key fields should not be more than 255 and then you can adjust database.

Regards

Pinaki

[Former Member]

Hi,

You cannot have key fields length longer than 69 characters.

thanks,