Data base table activation problem

[Former Member]

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,

[sergey_korolev]

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

[Former Member]

Dear Jugal,

The key field is required for each sap table.

So keep atleast one key field in your ztable.

Regards,

Dilip

[jayanthi_jayaraman]

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.

[Former Member]

Hi,

Have a look at this link

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

Thanks & Regards,

Judith.

[Former Member]

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,

[jayanthi_jayaraman]

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.

[Former Member]

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,

[Former Member]

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.

[Former Member]

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 ?

[Former Member]

Hi Jugal,

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

Regards.

SK

[Former Member]

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.

[Former Member]

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