table deleted and new created with same name !!!

[Former Member]

Hello friend,

We are facing a strange problem; actually we deleted the tabled and recreated with same name , now it gives some error while activating it...

something like inconsistency DD_- DB or so

Any idea what can be done to fix this issue..

Regards,

[Former Member]

Hello Shah,

Have you set the technical attributes. Check it.

Reward If useful

-

---

Sasi.

[Former Member]

yes, technical attributes are set

[Former Member]

I am getting following error

Nametab of table ZP_VBAP with status A does not exist

Regards,

[Former Member]

Hi,

Goto SE11>open ur table in change mode>menu bar>Utilities>Database utility.

There u will find option "Delete database table" press it..

Come back and reactivate your table..

Thanks and Regards,

Vikas Bittera.

[Former Member]

DELETE DATABASE TABLE button is not active

[Former Member]

And also this error while activating....

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

[Former Member]

Hi,

This is saying that there is inconsistency between database and data dictionary objects..

and did u go to database utility by coming in change mode of table from SE11??

Thanks and Regards,

Vikas Bittera.

[raymond_giuseppi]

Did you try SE14 to adjust the database.

Nevertheless the table should have been destroyed in the data base.

Regards

[Former Member]

Hi,

In SE11 click on UTILITIES->DATABASE UTILITIES and adjust database and activate. Hope will solve ur issue.

<b>reward points for helpfull answers</b>

Thanks

Tanweer

[Former Member]

how to adjust database there in database utilities ?

Regards,

[Former Member]

Hi,

in database utility you will find one push button in the last with name 'Activate and Adjust databse' click there it will automatically do the adjustment and activation.

<b>Kindly reward Points for Helpfull Answers</b>

Thanks

Tanweer

[Former Member]

These buttons are dis-abled...cant click on these buttons

[Former Member]

Hi,

Yes go in the change Mode

<b>Kindly reward Points for Helpfull Answers</b>

Thanks

Tanweer

[Former Member]

I am in change mode of table, from there I click on databse utilities and now all these buttons are disabled.....

Regards,

[Former Member]

Ohh..

Then i would suggest, copy your current table with another name.. delete the previous one.. goto SE14, adjust the database..

and then rename the new table with the previous name

Thanks and Regards,

Vikas Bittera.

[kostas_tsioubris]

Hi,

what I would recommend is to delete the table again from R/3 and then write a simple program calling native SQL in order to make sure that the table is deleted in the database too.

Probably, the database definition of your table still exists in your database or something and this is the reason you get these problems.

I don't know if I am correct but since you are in stall now, you can try it.

Kostas

[Former Member]

But what I do not understand, why I cant re-adjust the table in databse utilities ?

Regards,

[kostas_tsioubris]

Maybe doing a re-check in the system using transaction DB02 will be helpful. Also let us know if you are able to update the statistics using transaction DB20.

If the above doesn't work give a try to running a native SQL statement and try again from the beggining.

Kostas

[Former Member]

pls let me know how and which statistics I have to update.....

Regards,

[kostas_tsioubris]

Go to transaction DB20 and give your table name. Does DB20 recognize it as a table? Refreshing the statistics might help (I assume) since there are some db calls in it.

Kostas

[Former Member]

it did not recognize the table and says msg, table does not exists in abap dictionary...

Regards,

[kostas_tsioubris]

Please give us also the exact error message when trying to activate the table and to db you are on (oracle?)

.

[Former Member]

Error:

TABL ZP_VBAP was not activated

Check table ZP_VBAP (HAIDE01/03.09.07/16:25)

Table is not yet classified

Index ZP_VBAP-Z01 must be created in the database

Index ZP_VBAP-Z04 must be created in the database

Index ZP_VBAP-Z05 must be created in the database

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

Check on table ZP_VBAP resulted in errors

Yes the db is oracle...

Regards,

[Former Member]

Any idea / suggestion for me ?

Regards,

[kostas_tsioubris]

Are there any logs in transaction SM21? I am out of ideas now. Maybe running a db02 check and if this doesn't work drop the table using native sql (first delete it from r/3 though) will help you.

Also the reconstruct button in SE14 is active?

Transaction SE14 enter the table name and select EDIT, choose Table -> Reconstruct.

Kostas

Message was edited by:

Kostas Tsioubris

[Former Member]

button recontruct in se14 is disabled.....

drop table we already tried..... ( using statement drop table and created again )...

humm.... looks very stange to me this issue...

regards,