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