how to do cascade deletion and updation through SE11

Posted on 2004-10-20
Medium Priority
Last Modified: 2013-12-08
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.
Question by:Locate_dhiraj

Accepted Solution

bacherjo earned 500 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 !
LVL 23

Expert Comment

ID: 12419272

For more detail info...look at here..


Assisted Solution

marbit earned 500 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

Featured Post

Free Tool: Port Scanner

Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Salesforce.com is a cloud-based customer relationship management (CRM) system. In this article, you will learn how to add and map custom lead and contact fields to your Salesforce instance.
Get to know the ins and outs of building a web-based ERP system for your enterprise. Development timeline, technology, and costs outlined.
Through the video, you can check the migration process of Outlook PST file to PDF. Kernel for Outlook to PDF tool can convert Outlook emails with all attributes like Subject, To, From, Cc, Bcc and other folders such as Inbox, Outbox, Sent Items, Jun…
To export Lotus Notes to Outlook PST or Exchange and Domino Server files to Exchange Server or PST files with ease, go for Kernel for Lotus Notes to Outlook conversion tool. Through the video, you can watch the conversion process. A common user with…

600 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