topic Re: Data base table activation problem in Application Development and Automation Discussions

Data base table activation problem

Former Member — Thu, 02 Jun 2005 10:35:11 GMT

Hi SAP Gurus,

There is a ztable for which we have removed a key field. We have also removed associated search help as well as maintenance view for that table. We have checked the list of program ( usisg where use list) that the removed field is not being used any where else. Still we are not able to activate the ztable. Please provide some quick and effective solution.

Regards,

Re: Data base table activation problem

sergey_korolev — Thu, 02 Jun 2005 10:42:50 GMT

Did you try to adjust the table (with Preserv data option) via Database Utility (SE14)?

Re: Data base table activation problem

Former Member — Thu, 02 Jun 2005 10:45:05 GMT

Dear Jugal,

The key field is required for each sap table.

So keep atleast one key field in your ztable.

Regards,

Dilip

Re: Data base table activation problem

jayanthi_jayaraman — Thu, 02 Jun 2005 11:01:46 GMT

Hi Jugal,

Adding to the previous points,

Atleast one key field is necessary for a table.

Go to SE14,give tablename and click table radio button.

Then enter.Then in next screen click Adjust and activate database.

Re: Data base table activation problem

Former Member — Thu, 02 Jun 2005 11:08:38 GMT

Hi,

Have a look at this link

http://help.sap.com/saphelp_40b/helpdata/en/cf/21ea43446011d189700000e8322d00/content.htm

Thanks & Regards,

Judith.

Re: Data base table activation problem

Former Member — Fri, 03 Jun 2005 04:59:31 GMT

Hi Gurus,

I went with all the suggestions, still i am where I was before. I tried to activate and adjust (se14) as well.

I am describing the problem again. one of a key field of this table need to be replaced by another key field. We replaced this field with another one. before that we deleted all the data for that Ztable. The replaced field do posessed a search help object with it. We have deleted that search help. and it is no longer exits. By using where use list we verified that search help was not being used in any where. Still while trying the activate the ztable we are getting an error message " Field ZTABL_-UNAME is used as a parameter in search help ZSHELP_UNAME

Check on table ZTABLE resulted in errors"

Thanks,

Re: Data base table activation problem

jayanthi_jayaraman — Fri, 03 Jun 2005 05:35:21 GMT

Hi,

I too faced problem like that.It's because of some inconsistency.

It's better to create the table again by pasting the same field.Just make a try.

Re: Data base table activation problem

Former Member — Fri, 03 Jun 2005 07:14:21 GMT

Hi Gurus,

Here is another querrie related to previous one.

If we delete the table and again create it with the desired fields with the same name. Will the newly created table overwrite the exitsting one in the quality server after transportation.

Regards,

Re: Data base table activation problem

Former Member — Fri, 03 Jun 2005 08:19:36 GMT

Hi Jugal,

Is there any referancing required for that field you have introduced.Plz check for it.

Regards.

Re: Data base table activation problem

Former Member — Fri, 03 Jun 2005 14:47:50 GMT

Hi Jugal,

So far as I know, The transport to the quality system will not succeed in the first place.

Try to get in touch with the Basis Administrator for your Quality system and delete the table there manually, just like you have done in the Development system.

Regards,

Anand Mandalika.

Re: Data base table activation problem

Former Member — Fri, 03 Jun 2005 14:49:09 GMT

By the way, when you are creating the table again, would it be too much of a concern to change the name of the table slightly? For example by adding an underscore (_) or something ?

Re: Data base table activation problem

Former Member — Fri, 03 Jun 2005 14:54:43 GMT

Hi Jugal,

If you create for the second time with the same name then when you transport it to quality then the changes will not be overwritten and it will adjust to the changed fields. Indeed i had the same doubt when i tried to change the fields but after transporting it the same it adjusted the fields which was changed.

Regards,

Jagath.

Re: Data base table activation problem

Former Member — Mon, 06 Jun 2005 19:23:45 GMT

We provided by solution by using the same name as the exisitng field name with a different data elament/domain name. as this is a ztable so no proble.

Thanks all for generous help.

Regards,

Jugal