2023 Oct 12 12:17 PM
I changed the data element of the column of table from NUMC1 to NUMC4. Then tried to activate the data element. It got partly activated and errors occurred while activating dependent table. Error shows table does not exist in database.
Errors are
The SQL statement was not executed.
Table ZPMEMS_MASTER (Error adjusting the database).
Please help to resolve.
Regards
Sanjeev Kumar Gulliya
2023 Oct 12 12:25 PM
Everything is mentioned in Error long text I believe. Please check it for more details.
In short you need to use Database utility (t-code SE14) and "Activate and adjust database". It is needed because this change you did could affect the data which are already in the DB table. Please be careful with this. Especially if you are decreasing the size of the column, lets say from CHAR4 to CHAR1 (not your case...).
2023 Oct 12 3:57 PM
Did you read the activation log from SE11 (Menu Utilities, Activation Log)
2023 Oct 12 5:31 PM
It has been asked in the forum many times. People are giving the same answers again and again.
2 weeks ago
I've got the same error when I changed some the data elements...
I noticed that when activating the DB, SAP creates a temporary table. In my case, I modified the DB several times and SAP created several indexes in these temporary tables (there was no index in the transparent table) and that's why it didn't activate.
I solved on SE14 -> "Extra -> Invalid Temporary Table". Delete all temporary table, go back to SE11 and activate your table
Alander Fosse.