Problem with Z table , showing some error

[former_member459142]

Hi Experts

I have a Z table , it is not going to be active because of some errors , i am not able to get the exact reasone of error please help me out.

These are the following errors

1- ZSIILPM001: Inconsistency DD <-> DB (check table with analysis tool) 2- No active nametab exists for ZSIILPM001 3- Termination due to inconsistencies 4- Table ZSIILPM001 (Statements could not be generated)

Thanks

[former_member459142]

Hi,

Try this, In SE11 itself, go to UTILITIES -> DATABASE UTILITY -> ACTIVATE AND ADJUST

Regards,

Anil

[former_member242255]

check whther you have filled all the fields in the technical settings of the table and

basic requirements like primary key, MANDT field and check talbe all..

even if you are getting the same errors

then u can go to SE14 and adjust the table.

give the table name and click adjust and activate

Edited by: Sravan Kumar on May 4, 2009 6:28 AM

[former_member459142]

hi sravan

ya all fields in Technicle Setting is filled and I have gone to SE14 here ALL 3 buttons is deactive for adjust and activate

then i clicked on Object log so here i am getting this error

1 - Nametab of table ZSIILPM001 with status A does not exist

Thanks

[Former Member]

Hi,

Try this, In SE11 itself, go to UTILITIES -> DATABASE UTILITY -> ACTIVATE AND ADJUST

Regards,

Anil

[former_member459142]

hi anil

DATA UTILITY is deactive , i am not able to select it

Thanks

[Former Member]

Hi,

Do you have any foreign key relationship in this table....

if so, Then remove the relationships... try to activate the table.... once it is activated give the relationship once again... and also check that the relationship which your are giving is correct...

Regards,

Siddarth

[Former Member]

Hi,

go to T CODE SE14, provide the table name click on "Activate and adjust database"

This will solve your problem.