topic Re: Error while creating new table in Application Development and Automation Discussions

Error while creating new table

Subhankar — Sat, 14 Nov 2009 12:56:40 GMT

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

Re: Error while creating new table

kesavadas_thekkillath — Sat, 14 Nov 2009 13:03:36 GMT

Check OSS-notes 306296 573858

Re: Error while creating new table

Former Member — Mon, 16 Nov 2009 08:31:05 GMT

Hi,

Use SE14 tcode and activate and adjust database.

Regards,

Vaishali.

Re: Error while creating new table

Former Member — Mon, 16 Nov 2009 09:10:11 GMT

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

Re: Error while creating new table

Former Member — Mon, 16 Nov 2009 16:55:45 GMT

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.

Re: Error while creating new table

shadow — Tue, 17 Nov 2009 10:14:00 GMT

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.

Re: Error while creating new table

Former Member — Mon, 23 Nov 2009 13:07:37 GMT

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

Re: Error while creating new table

Subhankar — Fri, 11 Dec 2009 12:47:54 GMT

Using SAP specified it is solved.

Re: Error while creating new table

Former Member — Tue, 01 Feb 2011 15:14:22 GMT

Sudhakar,

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

Thanks