Configuration Settings: Days Payable Outstanding Analysis

This document contains configuration information for the Days Payable Outstanding Analysis 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 Payable Outstanding Analysis

KPI ID: sap.hba.sfin.ap.DaysPayableOutstanding

Goal Type: Range

Data Source

Parameter	Value
SAP HANA View	sap.hba.r.sfin700/DaysPayableOutstandingQuery
OData Service	/sap/hba/r/sfin700/odata/ap/kpi.xsodata
Entity Set	DaysPayableOutstanding
Value Measure	DaysPayablesOutstanding
Semantic Object/Action	<`empty`>

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

Evaluation: Last 12 Months

Evaluation ID: sap.hba.sfin.ap.DaysPayableOutstanding.Last12Month

Data Source

Parameter	Value
OData Service	/sap/hba/r/sfin700/odata/ap/kpi.xsodata
Entity Set	DaysPayableOutstanding
Value Measure	DaysPayablesOutstanding
Scaling Factor	Auto
Decimal Precision	Auto

Targets, Thresholds, and Trend

Parameter	Value
Goal Type	Range
Value Type	FIXED
Critical High	500
Warning High	400
Target	100
Warning Low	50
Critical Low	10
Trend

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	EUR	Choose a currency in which the currency amounts should be displayed. Ensure that 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 SAP NetWeaver General Settings Currencies Check Exchange Rate Types .
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.

Input Parameter

Operator

Example Value

Explanation

P_DisplayCurrency

Equal to

EUR

Choose a currency in which the currency amounts should be displayed. Ensure that exchange rates for this currency exist in your SAP ERP system.

An entry in this field is required.

P_ExchangeRateType

Equal to

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 Start of the navigation path SAP NetWeaver Next navigation step SAP NetWeaver General Settings Currencies Check Exchange Rate Types End of the navigation path .

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: By Timeline

View ID: sap.hba.sfin.ap.DaysPayableOutstanding.Last12Month.Timeline

View Title: By Timeline

Measures and Dimensions:

Parameter	Value
Dimension	Year and Month
KPI Measure	Days Payable Outstanding

Visualization Type:

Column
Single Axis
Absolute Values
Default Colors

Limit Data Records: 12

Drill-Down: By Company Code

View ID: sap.hba.sfin.ap.DaysPayableOutstanding.Last12Month.CompanyCode

View Title: By Company Code

Measures and Dimensions:

Parameter	Value
Dimension	Company Code
KPI Measure	Days Payable Outstanding

Visualization Type:

Column
Single Axis
Absolute Values
Default Colors

Limit Data Records: 200

Drill-Down: By Vendor (Top 10 Highest DPO)

View ID: sap.hba.sfin.ap.DaysPayableOutstanding.Last12Month.VendorHighest

View Title: By Vendor (Top 10 Highest DPO)

Measures and Dimensions:

Parameter	Value
Dimension	Vendor
KPI Measure	Days Payable Outstanding

Visualization Type:

Bar
Single Axis
Absolute Values
Default Colors

Limit Data Records: 10

Drill-Down: By Vendor (Top 10 Lowest DPO)

View ID: sap.hba.sfin.ap.DaysPayableOutstanding.Last12Month.VendorLowest

View Title: By Vendor (Top 10 Lowest DPO)

Measures and Dimensions:

Parameter	Value
Dimension	Vendor
KPI Measure	Days Payable Outstanding

Visualization Type:

Bar
Single Axis
Absolute Values
Default Colors

Limit Data Records: 10

Tile

Title: Days Payable Outstanding

Subtitle: Last 12 Months

Parameter	Value
Tile Format	Comparison Tile
Navigation	Generic Drill-Down
Semantic Object	DaysPayablesOutstanding
Action	analyzeSBKPIDetails

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 .