topic Re: foreign key in Application Development and Automation Discussions

foreign key

Former Member — Sat, 03 Apr 2010 18:20:21 GMT

Hi All,

I have created 2 tables and made primary key of one table as a foreign key for 2nd table but it is accepting the other values which are not there in foreign key table. i have followed the nor mal procedure like going to foreign key and giving the check table and accepting the proposal.

Can anyone please guide me what can be the problem.

thanks

Ritika

Re: foreign key

Former Member — Sat, 03 Apr 2010 21:18:47 GMT

Hi,

can you tell something more about primary keys of those tables? How many key fields consist those tables?

Are you sure you entered foreign key for all key fields? Is the requirement of the domain equality fulfilled?

Regards

Re: foreign key

Sandra_Rossi — Sat, 03 Apr 2010 21:35:48 GMT

There is a checkbox "Check required" in the foreign key.

Re: foreign key

Former Member — Sun, 04 Apr 2010 04:17:18 GMT

Please refer to [Foreign Keys|http://help.sap.com/saphelp_nw04/helpdata/en/cf/21ea77446011d189700000e8322d00/frameset.htm]

Hope this helps.

Re: foreign key

Former Member — Mon, 05 Apr 2010 07:50:07 GMT

Hi ritika,

there are two things....

one is check field and other is check table.

the table in which you befine the foreign key is the check field and the foreign table is the check table.

now if check table have many primary key then you have to define all the keys with foreign key.....

you can also define keys of check table as generic key or with constant key....

in generic key you need not to check that field with any field

in constant key you have to check it with constant.....

hope this helps,

Thanks,

Tanmaya

Re: foreign key

Former Member — Mon, 05 Apr 2010 11:48:29 GMT

Can you please tell me what cardinality you have specified while creating a foreign key??

It should be 1:N.

Re: foreign key

Former Member — Tue, 06 Apr 2010 13:56:25 GMT

thank you every one for the response.....i checked in the example table actually in 4.7 it is a bug.... it does not validate the input it saves the record any way.

in another versions my process works fine.

Re: foreign key

Former Member — Thu, 08 Apr 2010 09:38:58 GMT

Hi,

Just check with this..

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

Regards

Devinder