How to log change history in dso when it’s not coming from source sap bw

Hi

I have a requirement where in I have to. Log the change change detail of the data.

existing record in dso

Key 1. Key 2. Valid from date Valid To date KPI

11 22 01012011 31129999 100

NEW RECORD COMING FROM SOURCE

Key 1. Key 2. Valid from date Valid To date KPI

11 22 01012011 31129999 200

Now the requirement is:

When we do the data load ,it will amend a new row in target adso with the same key 1 and key 2 value and first row valid to will b loading date -1 and second row valid from will b loading date ..So basically the expected output is like :

Key 1. Key 2. Valid from date Valid To date KPI

11 22 01012011 25072022 100

11 22 26072023. 31129999 200

pls help me how we can achieve it..