topic Re: Issues while changing primary key in table in Application Development and Automation Discussions

Issues while changing primary key in table

Former Member — Thu, 04 Sep 2008 04:11:23 GMT

I have one table. In that two fields are primary key. I want to change the second PK as FK only. But when i am changing this field as FK. Its showing one error 'Primary Key Change not permitted for value Table ZCAUSECATMASTER' . How to avoid this error.

Please help me.

Re: Issues while changing primary key in table

Former Member — Thu, 04 Sep 2008 04:34:53 GMT

Hi,

Goto se14 and Adjust & activate the table there....

Regards

Karthik D

Re: Issues while changing primary key in table

raja_narayanan2 — Thu, 04 Sep 2008 04:38:49 GMT

Hi.....

Remove that primary key for the second field and assign your foregin key..table to that filed.....

So when you give entries in that second filed it will be validated with its foregin key table......its nothing but check table...

what all values in the foregin table only can given.....

regards

raja

Re: Issues while changing primary key in table

Former Member — Thu, 04 Sep 2008 04:42:39 GMT

Hi,

remove that PK field from the table,activate this table and again declare that field.

In that way it will work.

Regards,

Amit