Skip to Content
avatar image
Former Member

Handle Deleted Deliveries

Hi ,

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

Nayab

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Best Answer
    avatar image
    Former Member
    Oct 23, 2015 at 03:41 PM

    Hi,

    your DSO1 Key fields should be combination of DSO2 and DSO3 key fields.

    can you post the example with data?

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member Suhas Karnik

      Hi Suhas,

      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)


      Thanks