Debtors: DSO Analysis, Period Breakdown (Credit Management)
Technical name: 0FIAR_C02_Q1002
Use
This query serves as the basis for a graphical depiction of the DSO analysis in the form of a time series.
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 in a time period in the past, the balance (= outstanding debts, open customer items for the current period) is compared with the sales volume (= average sales volume for the prior period) using the following formula:
DSO = Balance of period/sales of 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) |
Free Characteristics
InfoObject |
Description |
0DEBTOR |
Customer |
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) |
0T_FPER |
For the characteristic 0FISCPER: Test on period/fiscal year for column headings |
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) |
0BALANCE |
Balance for period |
0SALES |
Sales of the period |
DSO |
Calculated key figure: Balance of period/sales of period * 30 |
Columns
The columns form a structure of the InfoCube 0FIAR_CO2:
0FIAR_C02_QT1002, Time series: 12 periods in the past.
InfoObject |
Description of the InfoObject (and Restriction or Calculation Formula) |
12 th period prior to the selected period (text variable 0T_FPER) |
Fiscal year/period 0FISCPER = 0P_FPEEX - 12 |
1th period prior to the selected period (text variable 0T_FPER) |
Fiscal year/period 0FISCPER = 0P_FPEEX -11 |
First period prior to the selected period (text variable 0T_FPER) |
Fiscal year/period 0FISCPER = 0P_FPEEX -1 |