Table activation

[former_member195202]

Hi Folks,

I have created a table named ZEDH_PAR_0889. but I am not able to activate it. I deleted it and again created it. I am getting the error

*No active nametab exists for ZEDH_PAR_0889"

Here is the log display:

TABL ZEDH_PAR_0889 was not activated

Check table ZEDH_PAR_0889 (PESAS0/20.05.08/11:43)

A table called ZEDH_PAR_0889 exists in the database

No active nametab exists for ZEDH_PAR_0889

Termination due to inconsistencies

Table ZEDH_PAR_0889 (Statements could not be generated

Error number in DD_DECIDE (9)

Check on table ZEDH_PAR_0889 resulted in errors

Status of the table is "New". I ve read the other similar threads on the forum but the case was little different where someone changed the field of the table and getting error "No nametab exits"

Can anyone please help

[former_member195202]

My problem is same as this one

but this thread has got no solution

[vinod_vemuru2]

Hi Ravi,

Is this new table or already existing table? If it is old one then compare old and new versions n see the difference.

First check the status of check tables used in ur ztables whether all are exist and in active state. If yes then chek below things.

Probable reason could be some one created table with same name and deleted. But when they deleted it got deleted form data dictionary. But in Data base(Generally it is Oracle) it did not got dropped. Try creating new table with same fields and see what is happening. if it got activated then the above assumption will be correct. If not then let me know. If it got created then copy this new table to ur original name and activate. Before this u have to delete current table.

Thanks,

Vinod.

Edited by: Vinod Kumar Vemuru on May 20, 2008 4:49 PM

[former_member195202]

Hi Vinod,

Thanks for reply...

I ve deleted it many times after creating. I tried to create a new one and activate it. Every time it gives the same error

"No Active Nametab exists for ztable"

The status is always new. I ve tried to created with different number of fields ( 2, 3 4...etc.) but it seems as if the name is creating the problem. you are right that the name of the table has been replicated on the database level and that's why I am unable to activate it.

I tried another ztable ...which are giving no error while activating.

I guess the name of this table has to be dropped at database level..

[Former Member]

Hi Ravi,

Try this.

In the Menu select Utilities - > Database Object -> Database utilities.

There try "Activate and Adjust database" option. If it doesn't work, try to delete database table and create database.

Thanks and Regards,

Lakshmi.

[former_member195202]

Hi Santhanalakshmi,

This option is appearing as disabled since the table status is "New".

This option is also there in Transaction se14 but same way....it is disabled there....I guess this option would have been worked if the table was active earlier and later some changes would have been made..

But since this is new creation ( many times I ve deleted it to create and activate it again) and was never activated....so this option is not working...

[Former Member]

Hi Ravi... Check In The Version Management And u can find The table With Two Versions... And Delete The Old one... Hope This May Solve Your Problem...

Reward Points IF Helpful.

Regards,

Narin Nandivada

[former_member195202]

Hi Narin,

I have already tried that option....did'nt work

[Former Member]

so what happened finally?

[Former Member]

Have you maintained technical settings correctly?

Also check error log long text...that may help you to resolve the issue...

Regards

Praveen

[RaymondGiuseppi]

Check OSS [Note 306296 - No active nametab for <table> exists|https://service.sap.com/sap/support/notes/306296] - active nametab does not exist, database table exists.

Then as suggested by the note, use an EXEC-SQL statement to drop the database table or delete it from database server and not from Sap.

Also check technical settings and the translation of data classes into actua database. (Which version of SAP, which kind of database are you using)

Regards,

Raymond

[former_member193284]

Hi Ravi,,

use SE14 to adjust the table and then try activating.

thanks

[Former Member]

Before offering any more advice, please see the date on the OP.

Rob