Configuration Settings: Working Capital Analytics - DPO Analysis

This document contains configuration information for the Working Capital Analytics - Days Payables Outstanding app.

SAP Smart Business Modeler

Before you can use this app, you might want to change the KPI evaluation and the KPI tile using the Smart Business Modeler.

The KPI has been configured as follows:

KPI: DPO (DirectCalculation)

KPI ID: sap.hba.sfin.wca.dpo

KPI Description: Days Payables Outstanding (direct calculation) for the current and previous 12 months

Goal Type: Maximizing

Data Source

Parameter	Value
SAP HANA View	sap.hba.r.sfin700.wca/WCADPOLast12MonthsQuery
OData Service	/sap/hba/r/sfin700/wca/odata/wca.xsodata
Entity Set	WCADPOLast12MonthsQueryResults
Value Measure	DaysPayablesOutstanding
Semantic Object/Action	DaysPayablesOutstanding/analyzeDPO

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

Evaluation: Last 12 Months

Evaluation ID: sap.hba.sfin.wca.dpo.Last12Months

Evaluation Description: Days Payables Outstanding (direct calculation) for current and previous 12 months

Data Source

Parameter	Value
OData Service	/sap/hba/r/sfin700/wca/odata/wca.xsodata
Entity Set	WCADPOLast12MonthsQueryResults
Value Measure	DaysPayablesOutstanding
Semantic Object/Action	DaysPayablesOutstanding/analyzeDPO
Scaling Factor	Auto

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 exchange rates for this currency exist in your SAP SFIN 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 SFIN system under SAP NetWeaver SAP NetWeaver General Settings Currencies Check Exchange Rate Types .
P_NetDueArrearsGridMsrInDays	Equal to	10	This parameter controls the analysis steps for days in arrears when navigating from the KPI tile into the Working Capital Analytics application.
P_SAPClient	Equal to	200	Enter the relevant SAP Client of you SFIN system
P_ExchangeRateDate	Equal to	00000000	The format of this field is YYYYMMDD. If you select a value other than 00000000, then every KPI is converted according to the respective conversion rate effective at the entered exchange rate date. When you select the value 00000000, the currency conversion rate for your chosen currency depends on the KPIs analyzed in the analysis steps you chose as follows: For the DPO (direct calculation) KPI, the currency conversion rate is converted according to the respective conversion rate effective at clearing date. For the Revenue KPI, the currency conversion rate is converted according to the respective conversion rate effective at posting date. For the Receivables KPI, the currency conversion rate is converted according to the respective conversion rate effective at the end of the month (month end date). For the Open Receivables KPI, the currency conversion rate is converted according to the respective conversion rate effective at today's date.
P_AgingGridMeasureInDays	Equal to	10	The parameter controls the analysis steps for aging when navigating from the KPI tile into the Working Capital Analytics application.
P_NetDueGridMeasureInDays	Equal to	10	The parameter controls the analysis steps for net due days when navigating from the KPI tile into the Working Capital Analytics application.

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 SFIN 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 SFIN system.

An entry in this field is required.

Tile

Title: DSO (Direct Calculation)

Subtitle: Last 12 Months

Parameter	Value
Tile Format	Numeric
Navigation	Analysis Path Framework
Semantic Object	DaysPayablesOutstanding
Action	analyzeDPO

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 .