10-06-2008 8:50 AM
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.
10-06-2008 8:58 AM
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
10-06-2008 8:53 AM
10-06-2008 8:54 AM
Hi..
try to activate the table and adjust the table as well.
Many thanks,
Raghu Posani.
10-06-2008 8:55 AM
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
10-06-2008 9:00 AM
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.
10-06-2008 8:58 AM
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
10-06-2008 9:03 AM
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
10-06-2008 9:06 AM
Thank you gurus for your answers...
it helps me to solve my problem...