Announcement:
wanna exchange links? contact me at sapchatroom@gmail.com.
Posted by
Admin at
Reply from gourabdey91 on Dec 3 at 11:39 PM Hi Ben, Thanks for your reply... I can understand your answer but, what is the significance of cardinality(m:n) in foreign key relationship then?
| | | ---------------Original Message--------------- From: Ben Meijs Sent: Monday, December 03, 2012 4:36 PM Subject: How to Delete Dependent Data from Foreign Key Table Automatically The foreign key relation is not really implemented in the database. In abap, fk relations are only used on gui/dynpro level (value check, text tables, f4 searchhelp etc) Sap decided not to generate the referential integrity into the underlying database. Groeten, Ben Op 3 dec. 2012 om 21:58 heeft "Community_Member" email@removed<mailto:email@removed> het volgende geschreven: Question from Gourab_Dey on Dec 3 at 3:49 PM HI experts! I have created two database table zcheck and zforeign. I have created foreign key relationship between zforeign and zcheck table with foreign key cardinality 1: C(m:n). As per the theory of cardinality is concered, if m is '1', then the data from the dependent table i.e., zforeign will be deleted if we delete the corresponding entry from check table i.e., zcheck. But, this is not happening. The dependent data remains even after deleting the corresponding data from check table. Where is the problem? Please help, if some one knows the solutions of this problem.. Thanks in advance.. Reply to this email to post your response. | | Reply to this email to post your response. __.____._ | In the Spotlight Become a blogger at Toolbox.com and share your expertise with the community. Start today. _.____.__ |