Debtors: DSO Analysis, One Period (Credit Management)
Technical name: 0FIAR_C02_Q1001
Use
The DSO analysis (Days of Sales Outstanding) deals with the payment history of customers. It returns general information on the outstanding debts of a customer for a certain period in relation to the average daily business volume of the customer in question.
The DSO is measured in days and means that the customer owes the value of the daily business volume in DSO days.
To work out a DSO day, the balance (= outstanding debts, open customer items for the current period) is compared with the sales volume (= average sales volume for the previous period) using the following formula:
DSO = balance/sales for the previous period * 30
Filters
InfoObject |
Description of the InfoObject (and Restriction or Calculation Formula) |
0COMP_CODE |
Company code |
0FISCVARNT |
Fiscal year variant |
0CURTYPE |
Currency type (10 = company code currency) |
Variables Used
Variable |
Description |
0P_COCD |
For the characteristic 0COMP_CODE: Company code (single value entry, obligatory) |
0S_DEBIT |
For the characteristic 0DEBTOR (selection options, optional) |
0P_FVAEX |
For the characteristic 0FISCVARIANT: Fiscal year variant (SAP exit, determined from company code) |
0P_FPEEX |
For the characteristic 0FISCPER: Period/fiscal year (SAP exit, determined from personalization of the variable 0P_KEYDT) |
The variable 0P_FPEEX for the characteristic 0FISCPER (period/fiscal year) is determined from the personalization of the key date (variable 0P_KEYDT). The personalization of this key date is read in the SAP BW system and converted using the fiscal year variant of the company code in a period.
This means that it is not necessary to enter a value for the variable 0P_FPEEX for the characteristic 0FISCPER (period/fiscal year) for existing personalizations of the key date (variable 0P_KEYDT).
Rows
InfoObject |
Description of the InfoObject (and Restriction or Calculation Formula) |
0DEBTOR |
Customer |
Columns
InfoObject |
Description of the InfoObject (and Restriction or Calculation Formula) |
Balance for period |
Restricted key figure Cumulative balance (0BALANCE), restricted to a selected fiscal year period. 0FISCPER = 0P_FPEEX |
Sales of the prior period |
Restricted key figure Sales of period (0SALES), restricted to the period prior to the selected fiscal year period. 0FISCPER = 0P_FPEEX - 1 |
DSO |
Calculated key figure: Balance of period/sales of prior period * 30 |