Skip to Content
0
Former Member
Apr 16, 2010 at 07:35 AM

Cardinality used in foreign key relationship of two table

1251 Views

Dear All,

I have taken eg:

Header table field: mandt , zcompanyname (primary key)

Line item table field: mandt, zjoindate (composite key field) , zleavedate (composite key field ) , zcompanyname.

Where i have link the above 2 tables using foreign keys relationships.

i am geting F4 help on zcompanyname field while entering data via table maintance generator.

eg: when i use cardinality relationship. 1:C for key/fields candidates.

mandt joindate leavedate company name

800 01.01.2006 01.02.2006 ASHOK ENGINEERING

800 01.03.2006 01.04.2006 BLUE STAR INFOTECH

800 01.05.2006 01.06.2006 BLUE STAR LIMITED

800 01.07.2006 01.08.2006 HAVELLS INDIA

800 01.09.2006 01.10.2006 NATIONAL POWER SYSTEMS

800 01.11.2006 01.12.2006 NPS DRIVE AUTOMATION

800 01.04.2010 16.04.2010 ASHOK ENGINEERING

eg: when i use cardinality relationship. 1:CN for key/fields candidates.

800 01.01.2006 01.02.2006 ASHOK ENGINEERING

800 01.03.2006 01.04.2006 BLUE STAR INFOTECH

800 01.05.2006 01.09.2006 BLUE STAR INFOTECH

where as iam not able to find the difference how the cardinality works in practically eg:

it is taking same company name entry with different dates but not with same dates due to primary key uniqueness logic.

but can any one explain me how can i difference between realtionship of cardinality example:

1:1 , 1:N , 1:C , 1:CN

Regards,

Rajesh Swami