2022 Dec 20 4:24 AM
I tried removing the TEST_ASD as primary key. Now I can't activate it.
Quite not sure with the error log provided.
2022 Dec 20 6:36 AM
Hello Wane,
please perform where used list on the field and see where it has been used. If field is being used as a foreign key then it is quite possible that it will not allow to delete. Seems like this table-field is in relationship with any other table and playing role of foreign key over there,
2022 Dec 20 10:03 AM
Is there a workaround for this? User wants to delete one of the primary keys of a table.
2022 Dec 21 4:22 AM
Unfortunately, first you need to break foreign key relationship before deleting the primary key from this table, otherwise it would create inconsistency. This is a hard error by SAP on foreign-key concept and can't be avoided.
I think this table field is in relationship with another Z-table. Just remove the foreign-key relationship from another Z-table, come back and delete the primary key from this table.
2022 Dec 20 10:34 AM
SAP explains you the issu, the solution is to follow the SAP recommendation
2022 Dec 20 12:28 PM
(what was written after 'Check table' in the log?)
2023 Jan 04 9:08 AM
2023 Jan 04 9:32 AM
You forgot to deactivate a table value check, run the where-used search again (table value of a domain or another table)