topic Regarding Foreign Key Field Type in Application Development and Automation Discussions

Regarding Foreign Key Field Type

Former Member — Thu, 17 Dec 2009 13:08:44 GMT

Hi Experts,

After creating many Tables still i messed up when my junior colleague asked me regarding : While Creating a Foreign Key in a table we will have a n a POP UP in which in Below section

in Semantic Attributes:

Foreign key field type : Not Specified

Non-Key fields/Candidates

Key fields/candidates

Key fields of a Text Table

Cardinality __ :___

What it is the use of Foreign Key field type and Cardinality . I searched in SDN and didn't found anything useful can any one Explain me in Detail How can we use it or why to use this.?

Best Regards

SRiNi

Re: Regarding Foreign Key Field Type

Former Member — Thu, 17 Dec 2009 13:43:36 GMT

Hi Sreenivasa L,

Refer below help..

The cardinality (n:m) describes the foreign key relationship with regard to the number of possible dependent records (records of the foreign key table) or referenced records (records of the check table).

[About Cardinality|http://help.sap.com/erp2005_ehp_04/helpdata/EN/b2/fbb859c64611d295dd00a0c929b3c3/content.htm]

The Type of foreign key fields describes what the foreign key fields in the foreign key table mean.

[About Foreign key field type|http://help.sap.com/erp2005_ehp_04/helpdata/EN/b2/fbb85cc64611d295dd00a0c929b3c3/content.htm]

Hope it will solve your problem..

Thanks & Regards

ilesh 24x7

ilesh Nandaniya

Re: Regarding Foreign Key Field Type

Former Member — Thu, 17 Dec 2009 13:52:52 GMT

Please search SAP help , you will get a clear explaination on this.

You can also press F1 on these and get information.

In case issue is not resolved , just give in thread . I will put it in watch.

Re: Regarding Foreign Key Field Type

Former Member — Thu, 17 Dec 2009 15:28:31 GMT

Hi Harsha,

Thanks for information...