topic Re: Error in table in Application Development and Automation Discussions

Error in table

Former Member — Mon, 17 Mar 2008 12:13:49 GMT

Hi All,

There is Z table which is created by some one with status New while I am tring to activate it ,it is giving error as below.

Check table ZABSENTMAS (ABAP06/17.03.08/17:36)

ZABSENTMAS: Inconsistency DD <-> DB (check table with analysis tool)

A table called ZABSENTMAS exists in the database

No active nametab exists for ZABSENTMAS

Termination due to inconsistencies

Table ZABSENTMAS (Statements could not be generated)

Error number in DD_DECIDE (9)

Check on table ZABSENTMAS resulted in errors

I checked with all the data elements and data domains all are error free and active.

can anybody tell me how to resolve this error.

Thx,

Tanisha

Re: Error in table

Former Member — Mon, 17 Mar 2008 12:22:53 GMT

hi Tanisha,

Remove the check table ZABSENTMAS for that field and freshly try assigning then it defaultly give a table..... make use of it to solve the existing problem..

Regards,

Santosh

Re: Error in table

Former Member — Tue, 18 Mar 2008 03:53:08 GMT

Check whether any of the fields in your table has check table as ZABSENTMAS. Remove that and then try to activate.

Hope this helps.

Thanks

Balaji

Re: Error in table

Former Member — Tue, 18 Mar 2008 04:04:34 GMT

Hi,

First thing remove the check table and activate the table which u have created and check for inconsistency..... if that is not a problem then foreign key assignment that the field structure u hav assigned and the field u hav refered is that both r same or not...

Thanks,

Arunprasad.P

Reward if useful.

Re: Error in table

Former Member — Tue, 18 Mar 2008 04:20:52 GMT

Hi Tanisha

This error is due to inconsistency in data dictionary and database level design,

since u added one field or change any field properties

so goto se14 tcode and activate and adjust the database table.

then activate ur table in se11 tcode .

i hope ur problem will resolve

please reward points if useful.

note: if ur table contain entries then u have to delete those one.

Re: Error in table

Former Member — Tue, 18 Mar 2008 05:45:33 GMT

Hi Santosh,

Thanks for reply.

The problem is I cant see any check table or the field that is specifiel in eror msg.

Thanks.

Tanisha

Re: Error in table

Former Member — Tue, 18 Mar 2008 06:00:03 GMT

Hi Everybody,

Thanks for the input.

I tried all the options,firstly there is no check table or foreing key assignment in the table.If I go to SE14 there all the options for adjust and activate for this table is inactive so I am not able to use it.Its staus is NEW the error message in log is

Nametab of table ZABSENTMAS with status A does not exist.

I am not able to findout whats the problem.

Thanks.

Tanisha

Re: Error in table

Former Member — Tue, 18 Mar 2008 10:02:47 GMT

If you have the table in QA or PROD check the compare the table fields

regards

Shiva