Skip to Content
avatar image
Former Member

A key field removal

Hi all,

I am trying to to remove a key field which was earlier a key field in a ztable.But when I am trying to activate the table it shows me a error like:

TABL ZTABLE was not activated

Check table ZTABLE (NAZMULA/09/17/08/01:40)

Old key field V_NUMBER is now non-key field

Structure change at field level (convert table ZTABLE)

Check on table ZTABLE resulted in errors .

How to overcome this?

Please suggest some solution..

Thanks in advance.

Nazmul

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

6 Answers

  • Sep 17, 2008 at 08:48 AM

    Hi

    SE11--> Utilities --> Database Objects >Database Utilities > Click on Activate and Adjust database.

    Thanks,

    Nelson

    Add comment
    10|10000 characters needed characters exceeded

  • Sep 17, 2008 at 08:51 AM

    Be aware that you might lose data rows during adjustment, since you removed a field from the primary key.

    Thomas

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Sep 17, 2008 at 08:53 AM

    Hi,

    go to se14 ->give table name -> EDIT -> click on Activate and adjust table.

    Regards,

    Srinivas

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Sep 17, 2008 at 11:18 AM

    Goto

    SE11 Tcode

    Enter your table name

    and press CHANGE

    in the menubar

    select Utilities-> Database Utility and in the screen press Adjust and Activate.

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member Former Member

      Hello dear,

      sorry for the prevois answer, U can do through SE14 but it should not be linked with any other table.I mean,if u use this is as a foreign key for another table U cant delete this.

      u plz check have u likned with any other table field.

      thanks and regards

      setty

  • avatar image
    Former Member
    Sep 17, 2008 at 12:51 PM

    1)click where used button to check where the table is being used.

    2)remove al the objects that are using your table.

    3)then go to se14 and click delete and adjust database.

    4)it will be activated then

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Sep 18, 2008 at 06:25 AM

    HI nazmul,

    If any changes are done at field level( irrespective of whether it is a key field or not ) in a database table, then the table has to be adjusted in the databse too.This is done using SE14(Database Utility).

    So, go to se14 and "ADJUST and ACTIVATE" your table after you have deleted the field or made any changes.

    Best of luck,

    Bhumika

    Add comment
    10|10000 characters needed characters exceeded