Application Development Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Showing results for 
Search instead for 
Did you mean: 

Delete fields on ztable

Former Member
0 Kudos

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.

1 ACCEPTED SOLUTION

Former Member
0 Kudos

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

7 REPLIES 7

Former Member
0 Kudos

Try to activate the table using TXN: SE14

Former Member
0 Kudos

Hi..

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

Many thanks,

Raghu Posani.

Former Member
0 Kudos

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

0 Kudos

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
0 Kudos

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
0 Kudos

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
0 Kudos

Thank you gurus for your answers...

it helps me to solve my problem...