Customise table inconsistency between ABAP Dictionary and the databas

[Former Member]

Hi all,

I have encountered a problem where by, I was not able to activate a table due to inconsistency between ABAP Dictionary and the database.

After I run the SE14--> Check Database object. It has show that there is a missing Unique Index(Primary Index) at the Database Level, but at ABAP Dictionary it is there.

I have try to recreate the primary index at the Database level, but failed. Because one of the primary key field is been dropped from this table.

So now, may I know how can I still make this table Active again?

Is it save to folllow the following solution that I found on internet?

-

---

Syntax error in SDCC, table inconsistency between ABAP Dictionary and the database, transport error 8 during the generation of ABAP Dictionary. When you call Transaction SDCC, a termination occurs due to a putative syntax error because a table is not known or active. When you check this with the ABAP dictionary (SE11), you notice, that the table is active or inactive, however it is not possible to activate it. The activation might terminate with the error message 'Inconsistency between ABAP Dictionary and database'. A check of the affected object also delivers this error.

Solution

Proceed as follows:

Log on as user DDIC

Call Transaction SE14

Enter the affected table name and

select EDIT

In the following screen, choose Table -> Reconstruct

Confirm the execution

Call Transaction SE11

Enter the affected table name

Display

Activate

Thanks.

CK

[former_member188883 · Accepted solution]

Hi,

1) What activity was performed during this such inconsistency appeared ?

2) Whats the name of incosistentent custom table and does that table contained data ?

Regards,

Deepak Kori

[Former Member]

I managed to solved this by

Solution

Proceed as follows:

Log on as user DDIC

Call Transaction SE14

Enter the affected table name and

select EDIT

In the following screen, choose Table -> Reconstruct

Confirm the execution

Call Transaction SE11

Enter the affected table name

Display

Activate

Thanks.

CK

[Former Member]

Hi,

Go to SE14 -> Enter object name -> Click on Edit -> Click on Indexes... -> Select the index -> Click on Activate and Adjust Database

I recommend you execute it, when the system is free

Best regards,

Orkun Gedik