Data modelling: Reverse Image & multiple Update rules ODS

[Former Member]

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

[Former Member · Accepted solution]

Hi,

In this case I would definitely take the layer 1 ODS approach primarily to avoid having to manipulate the ABR images and secondly to have the layer 1 in synch with the corresponding R/3 data. A second layer ODS can then be used to consolidate data for reporting.

[Former Member · Accepted solution]

Karthik,

Do you know what will happen with the delta between the 1st Level and 2nd level ODS. Is there still a RIM.

If there is, I will still have a problem if. The only option is then the manipulation of the data in a start routine

[Former Member · Accepted solution]

Thats correct, between the 1st level and 2nd level you would have to have a start routine which determines RIM records and manipulates the 0recordmode for subsequent processing.