Table Create Time Error

[narendra_rajput]

Dear Professional Sir,

               I want add 500 Field whenever i try to add field whenever i add field using Include strucuture at that time give error

FieldName
Field1
.INCLUDE
.INCLUDE
.INCLUDE

Please Help me

Thank You In Advance

[Former Member]

Hi,

You need to check the OSS Note - You can't create more than the 4030

SAP Note 636217 - DDIC activation error as table width greater than 1962 bytes

Or you can create another table and maintain the table relation specific with specified fields

Check this discussion, it may helps you to take the decision

: ZTable is too long (>4030)

[dibyajeeban_jena]

check the following points while creating Table

This also renders obsolete the restriction to 1962 in earlier SAP releases. You can increase the table width restriction to 4030 characters. We do not recommend that you increase the restriction to a value greater than 4030 characters.

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.