Delete fields on ztable

[Former Member]

good day gurus.

i made a ztable having 7 fields. After which, I activated and nothing goes wrong. No error at all. However, I decided to delete one field of my ztable.. Now there is now error which states:

TABL ZAP_OR_LIST was not activated

Check table ZAP_OR_LIST (08-0309/10/06/08/15:41)

Old key field ZLISTID has been deleted

Structure change at field level (convert table ZAP_OR_LIST)

Check on table ZAP_OR_LIST resulted in errors

This is my first time to encounter this problem. I search the forum but I havent found an answer to my question.

Please help me what to do to solve this problem.

Thanks a lot.

[Former Member]

Try to activate the table using TXN: SE14

[Former Member]

Hi..

try to activate the table and adjust the table as well.

Many thanks,

Raghu Posani.

[Former Member]

Hi,

Can u show me what fields are u created and which field u deleted

save ur table after field delete and activate again

Regards,

Sri

[Former Member]

Hi,

Even i have came accross the same problem.

Before deleting a key field, delete all the values stored in your table.

You can use code like,

Delete * from ztzble.

Now delete your field, also delete the table maintenance if you have created, before deleting the field.

[Former Member]

place the cursor on the field

press delete

and save the table

and activate using se14

give the table name

and give activate and adjust to database

it will be activated

[Former Member]

Hi,

You can run transaction se14 to adjust the database entries. However you also need to check if you have specified the key field in some other table as a foreign key or not and remove the foreign key relationship from those tables.

regards,

Advait

[Former Member]

Thank you gurus for your answers...

it helps me to solve my problem...