Announcement:
wanna exchange links? contact me at sapchatroom@gmail.com.
Posted by
Admin at
Reply from Ben Meijs Ctac on Dec 3 at 4:36 PM 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.
| | | ---------------Original Message---------------
From: Gourab_Dey
Sent: Monday, December 03, 2012 3:49 PM
Subject: How to Delete Dependent Data from Foreign Key Table Automatically
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. __.____._ |   _.____.__ |
