what is cardinality?how it works in ABAP?

Answer Posted / rohit.sapmm

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).
The left side (n) of the cardinality is defined as follows:
 n=1: There is exactly one record assigned to the check
table for each record of the
foreign key table.
 n=C: The foreign key table may contain records which do
not correspond to any record of
the check table because the foreign key field is empty.
This can occur for example if the
field of the foreign key table is optional, in which case
it does not have to be filled.
The right side (m) of the cardinality is defined as follows:
 m=1: There is exactly one dependent record for each
record of the check table.
 m=C: There is at most one dependent record for each
record of the check table.
 m=N: There is at least one dependent record for each
record of the check table.
 m=CN: There may be any number of dependent records for
each record of the check
table.

Is This Answer Correct ?    12 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How do you backup Sapscript layout sets? Can you download and upload? How?

805


What is interactive reporting?

811


What does an EXEC SQL stmt do in ABAP? What is the disadvantage of using it?

966


What are the two ways for restricting the value range for a domain? : abap data dictionary

711


How can a lock object be called in the transaction?

737






What is the maximum No. Of structures that can be included in a table or structure. : abap data dictionary

889


Differentiate between report and dialog program

794


What are the prerequisites for creating foreign key relationship?

834


What is IMG in SAP?

931


java script for push button in adobe forms.

2086


What is the client concept in sap?

741


What is the difference between a substructure and an append structure?

830


did u done enhancement framework?how u implemented?

5267


What is the diff between database view and maintenance view?

788


What is native sql?

792