How to perform mass update of expiration date for price records in F4106??

How to perform mass update of expiration date for price records in F4106??

Example , for an item (say A) , 2 things have to be done across all branch plants

1)Current price = 0.25 to be set as expired w.e.f 12th Apr,2017 i.e. EXDJ to be updated from 31st Dec,2017 to 12th Apr,2017 

2)New price = 0.28 to be added to F4106 and set effective from 13th Apr,2017 to 31st Dec,2017.I wish to avoid SQL update!!!

I found a report R41830 and executed it in final mode. I kept the adjustment tab as blank because I wanted to try to update the expiration date only for the existing records. However , this resulted in an equal number of new records being created with the same price but new expiration date. So now the price records for item A are doubled i.e. half with expiry date as 31st Dec,2017 and half with 12th Apr,2017. Price effective date is same in both the cases.