topic Re: Error While adding a new key field in table! in Application Development and Automation Discussions

Error While adding a new key field in table!

Former Member — Tue, 26 Nov 2013 10:17:11 GMT

Hello All,

While adding a new key field to custom table, I am unable to activate it. I tried to activate it using SE14 as well.

The activation error received is : "Primary key change not permitted for value table". Could anybody help in this direction?

Note: Did not get any proper thread to solve this issue.

Regards,

Ansh

Re: Error While adding a new key field in table!

AbhijeetK — Tue, 26 Nov 2013 10:22:49 GMT

Hi Anshika,

I think You are changing the Primary Key of custom table, and your table contains values.

So it is not possible to change the Primary key while table contains value.

Thanks

Abhijeet Kankani

Re: Error While adding a new key field in table!

nabheetscn — Tue, 26 Nov 2013 10:24:48 GMT

Please check SAP note 96295

Re: Error While adding a new key field in table!

sivaganesh_krishnan — Tue, 26 Nov 2013 10:30:42 GMT

HI anshika,

The current table might have been used as check table in some other custom table which you have created earlier. So first delete the that foreign key first and again activate the current table. Also make sure that there is no value in the current table as you are changing the primary key.

It will not show any error then .

Regards,

Sivaganesh

Re: Error While adding a new key field in table!

Former Member — Tue, 26 Nov 2013 10:40:48 GMT

Hi,

Ansika

through se14 utility u can select the Delete data radio button and then after try activate and adjust the table ,may be u r table will get activated .

Thanks & Regards ,

pramodh.m

Re: Error While adding a new key field in table!

Former Member — Tue, 26 Nov 2013 12:01:50 GMT

Thank you for your reply Sivaganesh, I am checking on it.

Regards,

Anshika

Re: Error While adding a new key field in table!

kiran_k8 — Tue, 26 Nov 2013 12:31:49 GMT

Pramod,

Deleting the existing data from a Custom table is not advisable.By your option we may not have any issue in D and Q but in P if the existing data in the Z table gets deleted it will be a problem.Not a right option for this.

K.Kiran.