DSO Analysis

InfoCube InfoCube: 0FC_MC01

This MultiCube merges information on open items determined on the key date using the mass activity, and settled items determined for the interval using the mass activity. The DSO (Day Sales Outstanding) is calculated for monthly periods. For this reason it is necessary that intervals for settled items are at least one month long, and that the end of an interval matches the corresponding key date for determining open items.

Example Example

End of the example.

Example:

For the DSO calculation for the month of April, you must select the interval 04.01.04 04.30.04 for the extraction of settled items, and the key date 04.30.04 for the extraction of open items.

You can select the evaluation Calendar day, Calendar year/week, Calendar year/month and Calendar year. The system determines the value from the posting date.

DSO is calculated as follows:

DSO = Balance / Periodic business volume * 30

The balance is composed of all open items on the key date, and the periodic business volume is composed of all revenue posted in the period.

Data Modeling

Requires

Object Type

Name

Technical Name

InfoObject

Business area

0BUS_AREA

InfoObject

Calendar Day

0CALDAY

InfoObject

Calendar Year/Month

0CALMONTH

InfoObject

Calendar Year/Week

0CALWEEK

InfoObject

Calendar Year

0CALYEAR

InfoObject

Change Run ID

0CHNGID

InfoObject

Company code

0COMP_CODE

InfoObject

Country key

0COUNTRY

InfoObject

Currency Key for Local Currency

0CURKEY_LC

InfoObject

Division

0DIVISION

InfoObject

Indicator: Posting Date Lies in Extraction Month

0FCFLAGPOMO

InfoCube

Cleared Items

0FC_C06

InfoCube

Open Items

0FC_C07

InfoObject

Cleared Items

0FC_CI

InfoObject

Key Date of Analysis

0FC_KEYDATE

InfoObject

Open Item

0FC_OI

InfoObject

BAS: Postal Code

0POSTALCODE

InfoObject

Record type

0RECORDTP

InfoObject

Request ID

0REQUID