topic Re: Field Name changes in Application Development and Automation Discussions

Field Name changes

Former Member — Tue, 22 Dec 2015 18:43:01 GMT

Hi ,

some time back have added a custom field in a structure ( field label length name is more than 10 characters .)

which eventually added this field in two transparent tables and one cluster table .

when we are doing an upgrade we noticed that we got some error on activating the cluster table ( Inconsistent )

when we try to activate the table it says

"Select a shorter name for ZZ_ADJWRITEOFF" The specified name is too long. Usually up to 30 characters are permitted for names.

There are some restrictions for certain objects. These objects are included in the following list together with the maximum length allowed:

say old field name : ZZ_ADJWRITEOFF and changed to new field name ZZ_ADJOFF

i verified cluster table and found zero records thought we dont have any impact and adjusted field name to 10 characters and activate the table .

i found that other two transparent tables has got valid records where this custom field is not blank . How do i adjust these table contents ?

Do we need to take the backup of these tables before my transports gets moved to production and ask DBA to adjust it ?

Please show me some pointers ?

Former Member — Wed, 23 Dec 2015 06:43:50 GMT

For any table adjustments, try using Transaction SE14 to adjust database.

tapomay_sanyal — Wed, 23 Dec 2015 10:52:37 GMT

Hi Chanda,

Better to take backup and then do database adjustments!

However in database utility se14 there is an option 'Save data & adjust'.

As there is change in field name only ,should not pose a problem, but I guess the particular column's data may be lost .so better to take back up.

---BR----

Tapomay

Former Member — Thu, 24 Dec 2015 02:33:08 GMT

Thanks .. i tried SE14 but no luck .

i have not changed anything (legth , position ..etc ) on the table except column name .

is this a bug in sap to alter the table ?

tapomay_sanyal — Thu, 24 Dec 2015 07:53:11 GMT

Hi Chanda,

No luck mean?

Did you try to adjust the tables?

As without adjusting IMO you wont be able to activate.

As per I recall if you select ADJUST---> save data then it tries for ALTER table if it cant then goes for conversion.

Give a look into below links:

Keep back up and try ,

-----BR----

Tapomay