topic Re: Delete fields on ztable in Application Development and Automation Discussions

Delete fields on ztable

Former Member — Mon, 06 Oct 2008 07:50:45 GMT

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.

Re: Delete fields on ztable

Former Member — Mon, 06 Oct 2008 07:53:15 GMT

Try to activate the table using TXN: SE14

Re: Delete fields on ztable

Former Member — Mon, 06 Oct 2008 07:54:25 GMT

Hi..

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

Many thanks,

Raghu Posani.

Re: Delete fields on ztable

Former Member — Mon, 06 Oct 2008 07:55:24 GMT

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

Re: Delete fields on ztable

Former Member — Mon, 06 Oct 2008 07:58:40 GMT

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

Re: Delete fields on ztable

Former Member — Mon, 06 Oct 2008 08:00:58 GMT

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.

Re: Delete fields on ztable

Former Member — Mon, 06 Oct 2008 08:03:29 GMT

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

Re: Delete fields on ztable

Former Member — Mon, 06 Oct 2008 08:06:51 GMT

Thank you gurus for your answers...

it helps me to solve my problem...