Solved

how to do cascade deletion and updation through SE11

Posted on 2004-10-20
5
674 Views
Last Modified: 2013-12-08
Hi!
i learning SAP
i created two tables one parent and the other child (relation ship defined). when i deleted some records from parent table the related values were still there in child table. My database is Oracle.
can anyone plz help me out.
THANKS
0
Comment
Question by:Locate_dhiraj
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
5 Comments
 

Accepted Solution

by:
bacherjo earned 125 total points
ID: 12367491
Hi, I have never heard that this is possible, at least not in SE11. I think you have to got write your own deletion routines who do the job. The reason that this function is not there might be, you could end up deleting half of your sap because all tables are related.
Let me know when you find a function like this in SE11 or somwhere else in SAP !
J
0
 
LVL 23

Expert Comment

by:rama_krishna580
ID: 12419272
Hi,

For more detail info...look at here..
http://www.akadia.com/services/ora_mutating_table_problems.html

R.K
0
 

Assisted Solution

by:marbit
marbit earned 125 total points
ID: 12622546
SAP doesn't use database constraints for foreign key's. Relational integrity is maintained entirely by the application logic. So if you delete a row with open SQL, you will never see a cascade delete. It's the responsibility of your program to ensure relational integrity, i.e. you have to delete the dependent rows in the child table explicitly in the program code.
I don't comment wether this behaviour of SAP is good or bad - simply take it as a fact.
kind regards
0

Featured Post

Announcing the Most Valuable Experts of 2016

MVEs are more concerned with the satisfaction of those they help than with the considerable points they can earn. They are the types of people you feel privileged to call colleagues. Join us in honoring this amazing group of Experts.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Supply Chain Event Management Supply chain visibility is the ability of a company to track its products and business processes in supply chain towards building operational excellence. The goal of supply chain visibility is to improve and strength…
Note: You must have administrative privileges in order to configure lead or case queues. Salesforce.com (http://www.Salesforce.com) is a cloud-based customer relationship management (CRM) system. It is widely used around the world by sales and ma…
A short tutorial showing how to set up an email signature in Outlook on the Web (previously known as OWA). For free email signatures designs, visit https://www.mail-signatures.com/articles/signature-templates/?sts=6651 If you want to manage em…
Attackers love to prey on accounts that have privileges. Reducing privileged accounts and protecting privileged accounts therefore is paramount. Users, groups, and service accounts need to be protected to help protect the entire Active Directory …
Suggested Courses

734 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question