ODS - Overwrite

[Former Member]

Hi

I have a ODS1 where wk and mtrl are keys.

ODS1

Week1 mtrl Qty

w1 m1 10

w2 m2 40

w2 m1 30

I would like to update (overwrite) this ODS with another ODS, say ODS2.

ODS2

w2 m2 20 (this ODS will have all W2's only )

W2 m3 30

My result (in ODS1) should be

w1 m1 10

w2 m2 20 (over write)

w2 m3 30 (overwrite)

W2 m1 0 (As there is no value for W1 m1 in

the 2nd ODS i should overwrite the

W2 m1 with '0').

Did any one face this type of situation?

Thanks.

[Former Member]

Hi Thejo,

I think so.

Delta is about pulling the new/updated records from the source system. It has no impact on the update rules.

Bye

Dinesh

[Former Member]

Hi Thejo,

You would have to use the ABAP routine in the update rules(for data coming from 2nd ODS) of the 1st ODS.

You can use the active table of the 1st and 2nd ODS to deifne your logic in the ABAP routine.

Bye

Dinesh

[Former Member]

Will delta be handled if use the logic in the upadte rules?