Data modelling: Reverse Image & multiple Update rules ODS

140 Views

Hi,

I have an ODS which is loaded by three data sources, being:

-2LIS_11_VAITM: Order& position fields

-2LIS_11_V_SSL: Total position delivery status

-2LIS_12_VCITM: COnfirmed delivery date

Initially all data seemed well. However, after some delta loads the following issue arose:

<b> The data of some data sources is lost in the process</b>

All data sources are of type ABR delivering an BIM, AIM, NIM and a RIM. The latter deletes a record from the ODS with the same key Fields, being 0DOC_NUMBER and 0S_ORD_ITEM.

This results in the loss of data from the other two data sources, leaving a record in the ODS with just one field filled.

I am considering to change the configuration and create 3 1st-Layer ODSses mirroring the SAP R/3 Tables, and a 2nd ODS on top combining these data flows. The records with the Reverse Image (RIM) will be deleted using a start routine.

Is this the right way or is there anybody who knows a better solution without ABAP-coding

Greetings, Floris