Handle Deleted Deliveries
DSO 1 is fed by DSO 2 and DSO 3
DSO 1 Key = Order ,Order Item
DSO 2 Key = Delivery , Delivery Item
DSO 3 Key = Order, order item , Schedule line
DSO 1 has 50 fields suppose , 30 populated by DSO 2 and 20 by DSO 3
Now there is a scenario If a delivery is deleted, record-mode will be 'R' and this will delete the entire line in the DSO1 including fields populated by DSO3 . If then a new delivery is created with reference to this order item (deleted) only new data that comes from DSO2 will be added as a
new line to the DSO1 . All the fields which DSO3 feeds will be empty in that case as no delta will come from it.
This could create serious problems with data consistency.
How to handle this ?
Thanks for your wonderful suggestion.Certainly the options you provided are very logical .
I would be please to inform you that i have found a very simple solution rather . What i will do is to convert all the records with record mode "R" to "X" in start routine b/w DSO2-->DSO1. This will selectively reset all the KPI's in DSO1 without disturbing other fields fed from DSO3.
I could arrive at this after ascertaining a wonderful SAP Note on this topic that explains exactly similar problem in a detailed manner. Marking this thread closed now.
Note No: 1358780 - Limitations of DATASTORE loading senarios( Solution C)