topic Re: error while creating database table in Application Development and Automation Discussions

error while creating database table

Former Member — Fri, 06 Feb 2009 07:10:46 GMT

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

Re: error while creating database table

former_member194669 — Fri, 06 Feb 2009 07:15:06 GMT

This will be constrains

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

a®

Re: error while creating database table

Former Member — Fri, 06 Feb 2009 07:17:49 GMT

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

Re: error while creating database table

Former Member — Fri, 06 Feb 2009 07:18:11 GMT

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

Re: error while creating database table

Former Member — Fri, 06 Feb 2009 07:21:24 GMT

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

Re: error while creating database table

Former Member — Fri, 06 Feb 2009 07:26:20 GMT

Hi,

You cannot have key fields length longer than 69 characters.

thanks,