DATA INTEGRITY

1. The SAP service that ensures data integrity by handling locking is called:

A: Update

B: Dialog

C: Enqueue/Dequeue

D: Spool

Data Integrity: Lock multiple records in multiple tables before delete operation

The purpose of this post is to start a dialog that will, hopefully, lead to a better understanding of the way to handle deletion of multiple records from multiple inter-related tables in a multi-user environment.

Here is a diagram of one such (simplified) senerio:

I should mention that the forms that the parent tables are associated with also have embedded browses on them. The child tables are represented on these forms as embedded browses. (each parent and it's two children on one form)

The senerio is as follows. When you delete a record from parent 1, there will (sometimes) be a corresponding record in parent 2 that will also need to be deleted. In addition, all of the corresponding child records will also need to be deleted. I need to make sure that ALL of the records are deleted. There can be no orphans or corrupted relations.

Confused? Feel free to ask

Your feedback is always appreciated.I will try to reply Ur queries as soon as time allows.
Regards,
SAPhelpdesk