Inbound sales price for IBP for weekly bucket

Hi SDners,

We are working on CPI-DS ingratiation with IBP inbound sales price from S4Hana to IBP

below is the requirement

we need post the data in IBP from S4 based Weekly bucket.

S4Hana data is like in below table

material price condition startdate enddate amount 1000 v001 12/1/2018 11/2/2018 200 48

We need to populate the data in IBP as below as we need to generate the rows based on the weeks calculation and rest data will be same as it is

1000 v001 12/1/2018 19/1/2018 100 w1 1000 v001 20/1/2018 27/1/2018 100 w2 1000 v001 28/1/2018 4/2/2018 100 w3 1000 v001 4/2/2018 11/2/2018 100 w4

Regards,