05-04-2009 5:22 AM
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
05-04-2009 5:28 AM
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
05-04-2009 5:28 AM
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
05-04-2009 5:41 AM
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
05-04-2009 5:35 AM
Hi,
Try this, In SE11 itself, go to UTILITIES -> DATABASE UTILITY -> ACTIVATE AND ADJUST
Regards,
Anil
05-04-2009 6:09 AM
hi anil
DATA UTILITY is deactive , i am not able to select it
Thanks
05-04-2009 6:18 AM
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
05-04-2009 6:17 AM
Hi,
go to T CODE SE14, provide the table name click on "Activate and adjust database"
This will solve your problem.