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: 

Table Z does not exist in the database

sanjeev1968
Member
0 Kudos
463

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

4 REPLIES 4

Tomas_Buryanek
Active Contributor
369

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

-- Tomas --

raymond_giuseppi
Active Contributor
0 Kudos
369

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

Sandra_Rossi
Active Contributor
0 Kudos
369

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

alanfosse
Explorer
0 Kudos
74

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.