Configuration Settings: Days Beyond Terms

This document contains configuration information for the Days Beyond Terms 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 Beyond Terms

KPI ID: sap.hba.sfin.ar.Days Beyond Term

KPI Description: Total days beyond terms for the last 12 months, including the current month

Goal Type: Minimizing

Data Source

Parameter	Value
SAP HANA View	sap.hba.r.sfin700.DaysBeyondTermQuery
OData Service	/sap/hba/r/sfin700/odata/ar/kpi.xsodata
Entity Set	DaysBeyondTerm
Value Measure	BeyondTermDays
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.DaysBeyondTerm.Last12Months

Evaluation Description: Days beyond terms for the last 12 months

Data Source

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

Target, Thresholds, and Trend

Parameter	Example Value
Goal Type	Minimizing
Value Type	FIXED
Critical	(Not applicable)
Warning	(Not applicable)
Target	(Not applicable)
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 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 .

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

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

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

View Title: By Period

Measures and Dimensions:

Parameter	Value
Dimension	Year, Month
KPI Measure	Days Beyond Terms

Visualization Type:

Line
Manual Colors

Limit Data Records: 200

Drill-Down: Ratio of Payments Within Terms / Beyond Terms

View ID: sap.hba.sfin.ar.DaysBeyondTerm.Last12Months.Ratio

View Title: Ratio of Payments Within Terms / Beyond Terms

Measures and Dimensions:

Parameter	Value
Dimension	Year, Month
Measures	Payments Within Terms (%) Payments Beyond Terms (%)

Visualization Type:

Column
Single Axis
Percentage Values
Default Colors

Limit Data Records: 200

Drill-Down: By Customer (Top 10 Beyond Terms)

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

View Title: By Customer (Top 10 Beyond Terms)

Measures and Dimensions:

Parameter	Value
Dimension	Customer
KPI Measure	Days Beyond Terms

Visualization Type:

Bar
Single Axis
Absolute Values
Default Colors

Limit Data Records: 10

Tile

Title: Total Receivables

Subtitle: Today

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 .