gettting a erro msg when deleting the already created field and chaning it

[Former Member]

Hi,

I am gettinga error msg when deleting the already created field and changing it to primary key

TABL ZCUSTEMAIL was not activated

Check table ZCUSTEMAIL

New or non-key field EMAIL_ID is now key field

Field EMAIL_ID is "NOT NULL"

ALTER TABLE is not possible

Structure change at field level (convert table ZCUSTEMAIL)

Check on table ZCUSTEMAIL resulted in errors

=========================================================================

End of activation of worklist

=========================================================================

this is ther procedure told in it

Message no. DT 064

Diagnosis

The structure of the table changed at field level. This change requires a conversion of the table. This situation can occur for example if the data type or field length of the domain upon which the field is based was changed. A conversion is also generally necessary if the key of the table changed.

Procedure

Convert the table using the Database Utility (SE14).

but i dont have authorization for se14

Arora

[former_member588853 · Accepted solution]

hi,

In se11, after changing your field datatypes or lenght..

go to utilities --> databaste utility -->

you will find a button some thing like <b>Adjust and Active database</b>.. click this button and activate your table..

your table is ready..

rewards if useful,

regards,

'Nazeer'

[Former Member · Accepted solution]

hi nazeer

database utility also give same erro as it also points to se14 is there anyother tcode to activate and adjust

regards

Arora

[varma_narayana · Accepted solution]

Hi..

You can get the solution for this in 2 ways.

1. Using Database Utility (SE14)

Selecting Activate and Adjust table

If u can get the Authorization from BASIS for this ... then do this..

There is no Tcode alternate for SE14

Otherwise.

If your table does not contain any data.

2. Perform these steps in SE11:

Copy ur Table to a new Table

Activate the New table

Then Delete the Original table

<b>Reward if Helpful</b>

[Former Member]

Hi Arora,

You need to adjust it using SE14.

If you don't have authorization ask your Basis to provide it.

The error will go once you activate using SE14.

Regards,

Atish