Calculation by using start routine.

Hi Expets,

I have one requirement need to calculate sales Ratio and will be updated to target DSO.

Data flow is from Infocube to DSO .

All calculation has to be done in start routine and end routine.

My source_package having data like this.

Sales Office

Material

Sales

SO1

M1

100

SO2

M1

200

SO1

M2

300

SO1

M3

100

SO2

M1

100

Calculation by using Start Routine:

Sales will summarize based on sales office.

Sales Office

Material

Sales

Total Sales base on sales off and material wise

SO1

M1

100

500

SO1

M2

300

500

SO1

M3

100

500

SO2

M1

100

300

Then need to calculate Ratio based on individual material sales value.

Sales Office

Material

Total

Ratio

SO1

M1

500

100/500

SO1

M2

500

300/300

SO1

M3

500

100/500

SO2

M1

300

300/300

And final Ratio will be update to target DSO.

Please share some inputs.

Thanks,

Somesh.