Reply from Ben Meijs Ctac on Dec 4 at 2:02 AM That's a very good question, which you should ask SAP. I'm not really sure why they choose to incorporate this into the dictionary without incorporating it in the underlying databases.
That said, I always look at is from a documentation point of view, although I wonder if anyone if this has helped anyone ever.
As a side note: with the SAP HANA in-memory database, this will all change dramatically.
Met Vriendelijke Groet / kind regards,
Ben Meijs
Op 3 dec. 2012, om 22:43 heeft Ben Meijs Ctac email@removed<mailto:email@removed> het volgende geschreven:
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: 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.   _.____.__ |
