Foreign Key

[Former Member]

Hi,

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

[Former Member]

hi,

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

Theja

[Former Member]

Hi,

Check the sap help on Foregin key and Check table

http://help.sap.com/saphelp_nw04/helpdata/en/cf/21ea77446011d189700000e8322d00/content.htm

http://help.sap.com/saphelp_nw04/helpdata/en/cf/21eaab446011d189700000e8322d00/frameset.htm

Regards

vijay

[Former Member]

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.