topic Re: Table Activation Error in Application Development and Automation Discussions

Table Activation Error

Former Member — Tue, 19 Aug 2008 12:15:03 GMT

Hello gurus,

I am getting this problem when i am trying to activate my Z table. I even tried adjusting the table through SE14 but the same error.

Error in code generation for deleting table ZVBAK

Message no. DA464.

Can anyone guide me on how to proceed.

Regards,

Ravi Kiran

Re: Table Activation Error

Former Member — Tue, 19 Aug 2008 12:17:22 GMT

Hi,

Pls try to click on that message Number and try to copy thre same here for clear idea..

Regards

Lekha

Re: Table Activation Error

Former Member — Tue, 19 Aug 2008 12:17:34 GMT

>Error in code generation for deleting table ZVBAK

is there any Table maintenance for the Ztable .

Re: Table Activation Error

Former Member — Tue, 19 Aug 2008 12:18:55 GMT

You are trying to delete ZVBAK table.

For this initially, you need to adjust the various objects which is refferring this table and once all objects are adjusted by removing this table, then delete the data which exists in this table and then delete the table...

Re: Table Activation Error

Former Member — Tue, 19 Aug 2008 12:25:42 GMT

Hello ,

Lekha: I have already copied the same error. this is what it says

Error in code generation for deleting table ZVBAK

Vijay: There exists no table maintenance generator

Ramesh : I am not trying to delete the table , i am trying to activate it and the error which is coming shows that it is not able to delete.

Please note that i have mentioned ZVBAK as an example, i am getting this error for all my Z tables .

Regards,

Ravi

Re: Table Activation Error

Former Member — Tue, 19 Aug 2008 12:33:12 GMT

Hi,

Try Transaction SE14

Re: Table Activation Error

Former Member — Tue, 19 Aug 2008 12:37:12 GMT

> i am getting this error for all my Z tables .

what are you doing exactly, and why you are activating tables. I hope simply you don't activate any table, if you make any changes to the table then only you will activate. What changes you are making..

Re: Table Activation Error

Former Member — Tue, 19 Aug 2008 12:45:40 GMT

Hey,

I am trying to add some more fields to the Z table and that is when i am getting the error when i am trying to activate it.

Initially i thought there might be some problem with that table but later when i had to add some fields to another Z table i came across the same error. Then i checked it again with other Z tables and that was when my problem was confirmed

Re: Table Activation Error

Former Member — Tue, 19 Aug 2008 12:55:27 GMT

hi,

Try using SE14. It will definitely solve your problem.

Re: Table Activation Error

Former Member — Wed, 20 Aug 2008 10:31:06 GMT

In SE11, enter your z table name and get into it. Goto Utilities -> Database Objects -> Database Utility. Use 'Activate and Adjust database' button. I guess this will solve ur problem.

Regards

Samson.

Re: Table Activation Error

Former Member — Wed, 20 Aug 2008 11:40:47 GMT

Hi,

For doing any ADDITION of fields or DELETING the Existing fields from TABLE,

1. You first need to empty it i.e. delete the Data inside the Table using transaction SE14

(Activate and Adjust Table - Delete Data).

2. Add or delete the fields now and then activate the Table. You would be able to do it.

Regards,

Amit.

Let me know if you have any more doubts.

Re: Table Activation Error

Former Member — Wed, 20 Aug 2008 11:55:37 GMT

Amit,

I dont think you need to adjust it always through SE14.You got to adjust it only when you change the order of the primary key.

Anyways that is not the problem here.

i think there is some problem with the Data Base itself and hence my tables are not getting activated.

None of my Z tables are getting activated when i make some modifcations and i have tried se14 in all ways but of no use.

Anyways we have posted the issue to SAP

lets see what might be the result.

Regards,

Ravi

Re: Table Activation Error

Former Member — Wed, 20 Aug 2008 12:52:46 GMT

Before activating have you deleted any field or added any field in between the existing fields ?

Re: Table Activation Error

Former Member — Thu, 21 Aug 2008 03:57:34 GMT

Hey Manjunath,

Nope i did not change the existing order of fields, just that i added 2 more fields at the bottom .

Regards,

Ravi

Re: Table Activation Error

Former Member — Thu, 21 Aug 2008 04:29:42 GMT

Hi,

If there is Table maintenance, please delete it and create again.

Thanks

Re: Table Activation Error

Former Member — Fri, 22 Aug 2008 08:53:16 GMT

Hi,

For doing any ADDITION of fields or DELETING the Existing fields from TABLE,

1. You first need to empty it i.e. delete the Data inside the Table using transaction SE14

(Activate and Adjust Table - Delete Data).

2. Add or delete the fields now and then activate the Table. You would be able to do it.

Regards,

Amit.

Let me know if you have any more doubts.

Re: Table Activation Error

Former Member — Fri, 22 Aug 2008 11:35:40 GMT

Hi,

If there is table maintenance generator for that

go and activate and see if not delete the exsisting

maintenance genator and create.

Regards,

Naveen.

Re: Table Activation Error

Former Member — Thu, 04 Sep 2008 05:08:53 GMT

Thanks Guys,

There was some problem with the Basis.

A job was supposed to be run , SAP Team helped us solve the problem.

Thanks for your support

Regards,

Ravi

Re: Table Activation Error

Former Member — Thu, 04 Sep 2008 05:26:04 GMT

Hi Ravi,

Did your changes affected the primary key fields of any related table or of the same table. i.e if you modify the primary key field also it throws error.

So if problem persists its better to recreate the same table with a different name...hope this may help.

Regards,

Linda.

Re: Table Activation Error

Former Member — Thu, 04 Sep 2008 06:49:07 GMT

Hi Linda,

there was no problem what so ever from ABAP side.

I do know that when we change the primary key field we have to adjust the database again.

A job was supposed to be run , which was skipped by mistake while configuring the client, that triggered the problem.

Anyways every thing is fine now.

Thanks !

Regards,

Ravi