Split records from FISCALWEEK to CALDAY - need some ABAP help

Hi Gurus,

I am trying to load Budgets data into a cube via DSO.

The problem here is i have budgets data aggregated at FISCALWEEK level. but i need to split this data into 7 equal days and update 7 recrods in cube. Total amount should be divided by 7.

Eg:

Data in DSO is

WEEK | Cost |
*30.2009 | 10000|*
29.2009 | 12000|

Now i need to split these budgets into Day level and load to the cube.

CALDAY | WEEK | Cost |
20.04.2009|30.2009|1428.57
21.04.2009|30.2009|1428.57
22.04.2009|30.2009|1428.57
23.04.2009|30.2009|1428.57
24.04.2009|30.2009|1428.57
25.04.2009|30.2009|1428.57
26.04.2009|30.2009|1428.57

Any help would be appreciated.

Thanks

POPS