Configuration Settings: Days Sales Outstanding

This document contains configuration information for the Days Sales Outstanding app.

SAP Jam Integration

For more information about integrating SAP Jam, see SAP Help Portal at Start of the navigation path http://help.sap.com/fiori_implementation Next navigation step Configuration of SAP Fiori Infrastructure With SAP NetWeaver 7.5 English Configuration of SAP Fiori Infrastructure Integrating SAP Jam (Optional) End of the navigation path .

SAP Smart Business Modeler

Before you can use this app, you need to configure it using the SAP Smart Business Modeler.

Note Note

To configure the app, please make copies of the KPI, evaluations, and drill-down configurations provided by SAP, and make your changes in these copies. Also, create your own tiles.

Please do not change the original versions provided by SAP, since new support packages and releases would overwrite your changes.

End of the note.

The KPI has been preconfigured as follows.

KPI: Days Sales Outstanding

KPI ID: sap.hba.sfin.ar.DaysSalesOutstanding

KPI Definition: Total days sales outstanding for the last 12 months ending today

Goal Type: Minimizing

Data Source

Parameter	Value
SAP HANA View	sap.hba.r.sfin700.DaysSalesOutstandingQuery
OData Service	/sap/hba/r/sfin700/odata/ar/kpi.xsodata
Entity Set	DaysSalesOutstanding
Value Measure	DaysSalesOutstanding
Semantic Object/Action	<`empty`>

The following templates for evaluations, drill-downs, and tiles are provided.

Evaluation: Last 12 Months

Evaluation ID: sap.hba.sfin.ar.DaysSalesOutstanding.Last12Months

Evaluation Description: Days sales outstanding for the last 12 months

Data Source

Parameter	Value
OData Service	/sap/hba/r/sfin700/odata/ar/kpi.xsodata
Entity Set	DaysSalesOutstanding
Value Measure	DaysSalesOutstanding
Semantic Object/Action	<`empty`>
Scaling Factor	Auto

Target, Thresholds, and Trend

This table shows some example values.

Parameter	Value	Example Value
Goal Type	Minimizing
Value Type	FIXED
Critical	<`empty`>	`100`
Warning	<`empty`>	`30`
Target	<`empty`>	`10`
Trend	(Not applicable)

Input Parameters and Filters

The following tables show the input parameters, filters, and some preconfigured example values. Use your own values where required, according to the data in your backend system.

Input Parameters

Input Parameter	Operator	Example Value	Explanation
P_DisplayCurrency	Equal to	USD	Choose a currency in which the currency amounts should be displayed. Ensure that the exchange rates for this currency exist in your SAP ERP system. An entry in this field is required.
P_ExchangeRateType	Equal to	M	Choose an exchange rate type that is used to convert the currency into the display currency. The current date is used as the date for the currency conversion. An entry in this field is required. The standard system includes the following exchange rate types: G (bank buying rate) B (bank selling rate) M (average rate) You can view the available exchange rate types in customizing in the SAP ERP system under SAP NetWeaver General Settings Currencies Check Exchange Rate Types .
P_RevnRollingAverageMonths	Equal to	1	Choose the number of months, beginning with the current month, for which the revenue is taken into account when the DSO figures are calculated. An entry in this field is required.
P_RblsRollingAverageMonths	Equal to	1	Choose the number of months, beginning with the current month, for which the open amounts are taken into account when the DSO figures are calculated. An entry in this field is required.

Filters

Filter	Operator	Example Value	Explanation
SAPClient	Equal to	200	Ensure that SAPClient has been added as a filter. Enter the client that you use in your SAP ERP system. An entry in this field is required.

Filter

Operator

Example Value

Explanation

SAPClient

Equal to

200

Ensure that SAPClient has been added as a filter.

Enter the client that you use in your SAP ERP system.

An entry in this field is required.

Drill-Down: Last 12 Months by Period

View ID: sap.hba.sfin.ar.DaysSalesOutstanding.Last12Months.ByPeriod

View Title: By Period

Measures and Dimensions:

Parameter	Value
Dimensions	Year, Month
KPI Measure	DaysSalesOutstanding

Visualization Type:

Column
Single Axis
Absolute Values
Default Colors

Limit Data Records: 200

Drill-Down: Last 12 Months by Customer (Top 10 by No. of Days)

View ID: sap.hba.sfin.ar.DaysSalesOutstanding.Last12Months.ByCustomer

View Title: By Customer (Top 10 by No. of Days)

Parameter	Value
Dimension	Customer
KPI Measure	DaysSalesOutstanding

Visualization Type:

Bar
Single Axis
Absolute Values
Default Colors

Limit Data Records: 10

Drill-Down: Last 12 Months by Company Code

View ID: sap.hba.sfin.ar.DaysSalesOutstanding.Last12Months.ByCompanyCode

View Title: By Company Code

Parameter	Value
Dimension	Company Code
KPI Measure	DaysSalesOutstanding

Visualization Type:

Table
Default Colors

Limit Data Records: 200

Tile

Title: Days Sales Outstanding

Subtitle: Last 12 Months

Parameter	Value
Tile Format	Numeric Tile
Navigation	Generic Drill-Down

More Information

For information on evaluations, drill-downs, and tiles, see SAP Help Portal at Start of the navigation path http://help.sap.com/ssb Next navigation step Tools SAP Smart Business Foundation Component [Language] SAP Smart Business Modeler Apps End of the navigation path .

For more information how the days sales outstanding figures are calculated, see the following documents: