Issues while changing primary key in table

[Former Member]

Hi

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.

[Former Member]

Hi,

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

Regards

Karthik D

[raja_narayanan2]

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

[Former Member]

Hi,

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

In that way it will work.

Regards,

Amit