Hello All,
I have a requirement that for one record in check table, there should be at max. one record in foreign key table.
For this, I have given the cardinality ratio of my foreign key field to be 1:C.
Despite this, I am able to enter more than one records in my foreign key table against a record in check table.
Please suggest me where I am going wrong.
Thanks,
Saurabh Buksh
3 Answers
-
Best Answer
Former MemberPosted on Nov 30, 2007 at 06:05 PMHi Saurabh,
If you are trying enter records with a insert or update instruction the integrity won't be checked.
What I learned from the book "Sams Teach Yourself ABAP/4 in 21 Days" is that there isn't integrity references in the database. The foreign keys integrity are checked by the user interface only.
Regards,
Charles
Add a comment
-
Posted on Nov 30, 2007 at 05:14 PM
Try with cardinality <b>1:1</b> instead of the 1:C
This is what I got from the Online Help..
<i>The right side of the cardinality has the following significance:
m = 1
For each record of the check table there is exactly one dependent record.
m = C
For each record of the check table there is at most one dependent record.</i>
Regards,
Naimesh Patel
Add a comment
-
Former MemberPosted on Dec 02, 2007 at 06:19 AM
HI
Cardinality of a relationship
The cardinality (n : m) describes the foreign key relationship with regard to the number of possible dependent records involved (records of the foreign key table) or referred records (records of the check table).
The right side of the cardinality has the following significance:
m = 1
For each record of the check table there is exactly one dependent record.
m = C
For each record of the check table there is at most one dependent record.
m = N
For each record of the check table there is at least one dependent record.
m = CN
For each record of the check table there are any number of dependent records.
Add a comment
Add a comment