Error while creating new table

[Subhankar]

Hi

First I had deleted one custom table. Then I try to create the same table with different fields. Now I am gettinh the errors.

1. ZLV_COMP_TABLE: Inconsistency DD <-> DB (check table with analysis tool)

2. A table called ZLV_COMP_TABLE exists in the database

3. No active nametab exists for ZLV_COMP_TABLE

4. Termination due to inconsistencies

5. Table ZLV_COMP_TABLE (Statements could not be generated)

6. Error number in DD_DECIDE (9)

Please help me ... how can I create a table with same name.

thanks

Subhankar

[kesavadas_thekkillath]

Check OSS-notes 306296 573858

[Former Member]

Hi,

Use SE14 tcode and activate and adjust database.

Regards,

Vaishali.

[Former Member]

Hi subhankar,

it's clearly showing that there a table in the data dictionary with the same name.

try to change the table name or delete the prev table(if not necessary)..

thanks,

viswa

[Former Member]

Hello,

goto SE14 -- Give the table name

use Tables Radio button

click on Edit

check the Delete Data Radio button

click on ACTIVATE AND ADJUST DATABASE.

Now check the table in SE11.

If it still exits you can change the same table or Delete it again & create a new table with Same Name.

This might help your query.

Anil.

[shadow]

Hi ,

Go to tcde SE11

Enter the Table name ->Display->utilities->databaseutilities

select table option and select Activate and adjacent database.

it may be help full to you.

With Regards,

SHAIK.

[Former Member]

Hi,

I think this will work

1.Goto SE14 --> Give the table name

2.use Tables Radio button

3.click on Edit

4.Select Direct radio button

5.Click Delete database table tab.

Now check the table in SE11.

Regards,

Suman

[Subhankar]

Using SAP specified it is solved.

[Former Member]

Sudhakar,

Can you tell me how this is fixed. We have the same problem and would like to know how this is fixed

Thanks

Ja