Days Sales Outstanding Calculation in SAP BW

[former_member497297]

Hi,

We are implementing a DSO calculation based on count back method. Kindly share some ideas to acheive this in SAP BW.

Table 1 : Contents of the cubes are Country, Year, Months,number of days, AR and Sales.

To calculate D and DSO net. Logic is as follows

DSO is calculated based on country here later we might do it on comp code with same count back method.

- If AR > Sales then note down the number of days . In this case 2000 > 500 , number of days for December would be 31.

- Next step is AR - Sales, which is 2000-500 = 1500 (value of 'D').

- If D > Sales (current month -1). which is 1500 > 400 (November)

then note down the number of days in November, which is 30. Add 30 (November) to 31 (December).

- Repeat until D < Sales (current month -1). which is 100 < 700 for month of September.

Now perform the DSO calculation taking in September values for D, Sales and Number of days

(D/ Sales) * number of days. which is 100/700 *30 = 4 days.

Now final step would be Add all the days December + November + October + DSO Calculation for September.

which is 31+30+30+4= 95 days.

Then this process is repeated for month of November. where AR is 2500 and Sales is 400.

[sapna_jgurudutt]

Hi,

Can you clarify regarding the exact release, SP level and Patch level applied to BW ABAP?

Thanks & Regards,

Sapna