topic Re: Foreign Key in Application Development and Automation Discussions

Foreign Key

Former Member — Wed, 09 Aug 2006 12:43:48 GMT

Hi,

Can someone help in creating a Foreign key on a field which is not a Primary key in the check table.

Former Member — Wed, 09 Aug 2006 12:44:39 GMT

hi,

a foreign is always a primary key in one of teh database tables, else it cannot be a foreign key.

Theja

Former Member — Wed, 09 Aug 2006 13:11:02 GMT

Hi,

Check the sap help on Foregin key and Check table

Regards

vijay

Former Member — Wed, 09 Aug 2006 13:20:08 GMT

Hi rachana,

1. The system will not allow

2. it would give message like this

Check table YHRT_CHKL_FUNMST has no key field with

domain YHRO_FUNTXT of the field FUNTXT

3. Even if we finally / indirectly manage to do,

the foreign key loses its purpose.

regards,

amit m.