topic Re: Table Z does not exist in the database in Application Development and Automation Discussions

Table Z does not exist in the database

sanjeev1968 — Thu, 12 Oct 2023 11:17:11 GMT

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

Re: Table Z does not exist in the database

Tomas_Buryanek — Thu, 12 Oct 2023 11:25:45 GMT

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...).

Re: Table Z does not exist in the database

RaymondGiuseppi — Thu, 12 Oct 2023 14:57:13 GMT

Did you read the activation log from SE11 (Menu Utilities, Activation Log)

Re: Table Z does not exist in the database

Sandra_Rossi — Thu, 12 Oct 2023 16:31:10 GMT

It has been asked in the forum many times. People are giving the same answers again and again.

Re: Table Z does not exist in the database

alanfosse18 — Thu, 30 Jan 2025 07:58:04 GMT

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.