topic Re: Problem with Z table , showing some error in Application Development and Automation Discussions

Problem with Z table , showing some error

former_member459142 — Mon, 04 May 2009 04:22:26 GMT

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

Re: Problem with Z table , showing some error

former_member242255 — Mon, 04 May 2009 04:28:14 GMT

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

Re: Problem with Z table , showing some error

Former Member — Mon, 04 May 2009 04:35:12 GMT

Hi,

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

Regards,

Anil

Re: Problem with Z table , showing some error

former_member459142 — Mon, 04 May 2009 04:41:26 GMT

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

Re: Problem with Z table , showing some error

former_member459142 — Mon, 04 May 2009 05:09:58 GMT

hi anil

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

Thanks

Re: Problem with Z table , showing some error

Former Member — Mon, 04 May 2009 05:17:41 GMT

Hi,

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

This will solve your problem.

Re: Problem with Z table , showing some error

Former Member — Mon, 04 May 2009 05:18:14 GMT

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