ERROR activating table

[Former Member]

Hi guys,

I'm having some trouble in creating a simple database table....

The thing is, imagine a table with 27 fields. Everything goes ok, I'm able to activate it, all cool. The problem is, when I insert a new field (number 28), i get an error on activation. The error is:

"TABL ZCOF_ECO_DATA2 was not activated

Check table ZCOF_ECO_DATA2 (ROFF/07.12.06/18:04)

Table ZCOF_ECO_D is too long (>4030)

No data exists (structure change caused by DROP / CREATE)

ZCOF_ECO_DATA2: Structure change at field level (DB is adjusted)

Check on table ZCOF_ECO_DATA2 resulted in errors"

I've tried everything on the Technical Settings, Delivery and maintenance....

Do you have any ideas?....

[Former Member]

Hi

I believe the structure of your table become too long if you add new fields.

Max.

[ferry_lianto]

Hi,

Try to run database utility (SE14) and select activate and adjust database with save data.

Regards,

Ferry Lianto

[Former Member]

Hi,

Whenever you change the ABAP dictionary it may require you to adjust the DATABASE, this can be done in the transaction SE14.

The database utility is the interface between the ABAP Dictionary and the relational database underlying the R/3 System. The database utility allows you to edit (create, delete and adjust to changes to their definition in the ABAP Dictionary) database objects derived from objects of the ABAP Dictionary.

Click the link below

http://help.sap.com/saphelp_47x200/helpdata/en/cf/21f0f0446011d189700000e8322d00/content.htm

Regards,

Vara

[Former Member]

hi

good

check the data element and the domain for that particular field is avtivated properly or not,if they have not activated than activat them and try again ,check the field lengh that you have given for the domain.

thanks

mrutyun^

[Former Member]

hi,

1. u have already created a table right. after you add a new field to the table ,

goto -> Table Maintenance Generator and delete the present contents and create a new Table Maintenance Generator, then the table will get activated without going to dump.

(or)

2. goto se14 and adjust the table.

[Former Member]

Hi guys,

Thanks to all of your suggestions, but maybe I didn't explained right.

The problem is not adjusting the table, or adding a new field to an existing table. The problem is when creating a table from scratch, with no data at all, at some point I'm not able to add no more fields...

And when does this happen? When I'm adding the 28º field I'm not able to activate the table, I get that error that I presented earlier....

Can a table only have 27 fields? Can't I create a table with more than 27 fields?

Do you have any suggestions...?

[Former Member]

Problem solved

thanks guys

[Former Member]

Can you post, How it's gets resolved?

[Former Member]

Sorry...The problem was related to the type element that I was using to my fields. In the majority they were CHAR255, well, using MSSQL, the maximum sum of all characters must be 4030. Maybe using another SGBD I wouldn't get this problem....

Solution: Reducing the element CHAR255 to CHAR100....OR CHAR200....It still has to be discussed

Hope that this can help anyone...