Error while modifying the Ztable

[former_member213475]

Hi

I am modifying one Ztable. in that I'm changing the primary key fields as non primary key fields. simply unchecking the check boxes. For this table there is no table maintenance generator.

But I am getting the error as

Data base object for table <Ztable> is inconsistent.

Please suggest me, how to solve this issue

Thanks.

[RaymondGiuseppi]

Did you first check for existence of duplicate records when those primary keys would be removed, that would prevent activation of the table at database level.

Regards,

Raymond

[former_member213475]

I haven't checked. I need to confirm from my client.

Thanks

[Former Member]

If the entries in the table are not important then delete the entries and then try to activate.  

[former_member213475]

If I delete the entries in that table, then it is possible to do?

Thanks

[Former Member]

Yes, I think so.

[Former Member]

Hi,

Yes, delete duplicate enties in table and activate. It will get activated.

If you still face any problem  then you could do 'activate and adjust database' in SE14.

Best Regards,

Abirami

[former_member213475]

Thanks Abirami

But, with out deleting the entries, is it possible to solve this issue?

[Former Member]

Hi,

I dont think so. You could try better by taking back up of your table data and adjust in SE14.

Till duplicate entries exists, it will not allow you to activate the table.

Best Regards,

Abirami

[venkat_aileni]

Hi-

In your Z-Table as you have modified primary key fields to non-primary key fields. Hence there is an inconsistency in your table structure. How to overcome this error you have Activate and adjust this table in SE14.

What will happen after activating your table in SE14?

Assuming your table consists of 3 fields out of which first 2 fields are primary keys:

In below table field1 and field2 are key fields:

Field1 Field2 Field3

------------------------------

     1     1          6

     1     2          6

     1     3          6

Now I have changed field2 as non-primary field.

Goto SE14 adjust and activate this table.

After above step if you check this table it will contain only one entry, as now field1 is the only primary key. Once you adjust your table in SE14 all these entries(other 2 records 2nd and 3rd) gets automatically deleted.

Now table will have below entry:

Field1 Field2 Field3

------------------------------

     1     1          6

So be careful before adjusting your table in SE14.

Note: Deleting duplicate entries in your table will not allow you to activate your table, you have to for sure adjust your table in SE14.

-Venkat

[former_member213475]

Hi venkat,

Thanks for your valuable answer.

Regards,

Saran.