Field Name changes

[Former Member]

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:

• Transparent tables and their fields: 16
• Logical and physical pools/clusters and their fields: 10.

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]

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

[tapomay_sanyal]

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]

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]

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:

https://help.sap.com/saphelp_erp60_sp/helpdata/en/cf/21f1ab446011d189700000e8322d00/content.htm

https://help.sap.com/saphelp_erp60_sp/helpdata/en/cf/21f1c5446011d189700000e8322d00/content.htm

Keep back up and try ,

-----BR----

Tapomay