Configuration Settings: Cash Position

This document contains configuration information for the Cash Position app.

SAP Jam Integration

For information on how to configure SAP Jam, see http://help.sap.com/sapjam.

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: Cash Position

KPI ID: sap.hba.ecc.cashmgr.cashposition

KPI Description: With this app, you can check cash positions by location, company, and currency.

Goal Type: Maximizing

Data Source

Parameter	Entry
SAP HANA View	(Not applicable)
OData Service	/sap/hba/r/sappl604/odata/fin/kpi.xsodata
Entity Set	CashPositionQueryResults
Value Measure	BalAmtInDisplayCrcy_E
Semantic Object/Action	<`empty`>

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

Evaluation: Today

Evaluation ID:sap.hba.ecc.cashmgr.cashposition.cashpositionV

Evaluation Description: With this app, you can check cash positions by location, company, and currency.

Data Source

Parameter	Value
OData Service	/sap/hba/r/sappl604/odata/fin/kpi.xsodata
Entity Set	CashPositionQueryResults
Value Measure	BalAmtInDisplayCrcy_E
Semantic Object/Action	<`empty`>
Scaling Factor	Auto

Targets, Thresholds, and Trend

This table shows some example values.

Parameter	Value
Goal Type	Maximizing
Value Type	Fixed Value
Critical	10000000
Warning	100000000
Target	<`empty`>
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_TargetCurrency	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.
P_CashDurationInDays	Equal to	0	Enter the Cash Duration in Days. An entry in this field is required.
P_CashManagementGrouping	Equal to	CF2	Choose cash management grouping. An entry in this field is required.
V_SAPClient	Equal to	002	Enter the client that you use in your SAP ERP system. 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: By Country

View ID: sap.hba.ecc.cashmgr.cashposition.cashpositionV.one

View Title: By Country

Measures and Dimensions:

Parameter	Value
Dimension	Country Name
KPI Measure	Balance Amount in Group Currency

Visualization Type:

Bar
Single Axis
Absolute Values
Default Colors

Limit Data Records: 200

Drill-Down: By Bank

View ID: sap.hba.ecc.cashmgr.cashposition.cashpositionV.two

View Title: By Bank

Measures and Dimensions:

Parameter	Value
Dimension	Bank Name
KPI Measure	Balance Amount in Group Currency

Visualization Type:

Bar
Single Axis
Absolute Values
Default Colors

Limit Data Records: 200

Drill-Down: By Country

View ID: sap.hba.ecc.cashmgr.cashposition.cashpositionV.three

View Title: By Country

Measures and Dimensions:

Parameter	Value
Dimension	Company Name
KPI Measure	Balance Amount in Group Currency

Visualization Type:

Bar
Single Axis
Absolute Values
Default Colors

Limit Data Records: 200

Drill-Down: By Currency

View ID: sap.hba.ecc.cashmgr.cashposition.cashpositionV.four

View Title: By Currency

Measures and Dimensions:

Parameter	Value
Dimension	Currency
KPI Measure	Balance Amount in Group Currency

Visualization Type:

Bar
Single Axis
Absolute Values
Default Colors

Limit Data Records: 200

Drill-Down: By Bank and Currency

View ID: sap.hba.ecc.cashmgr.cashposition.cashpositionV.five

View Title: By Bank and Currency

Measures and Dimensions:

Parameter	Value
Dimensions	Bank Name Currency
KPI Measure	Balance Amount in Group Currency

Visualization Type:

Bar
Single Axis
Absolute Values
Default Colors

Limit Data Records: 200

Drill-Down: By Currency and Country

View ID: sap.hba.ecc.cashmgr.cashposition.cashpositionV.six

View Title: By Bank and Currency

Measures and Dimensions:

Parameter	Value
Dimensions	Country Name Currency
KPI Measure	Balance Amount in Group Currency

Visualization Type:

Bar
Single Axis
Absolute Values
Default Colors

Limit Data Records: 200

Drill-Down: By Transaction Currenc

View ID: sap.hba.ecc.cashmgr.cashposition.cashpositionV.seven

View Title: By Transaction Currency

Measures and Dimensions:

Parameter	Value
Dimensions	Currency
KPI Measure	Balance Amount in Group Currency
Measure	Amount in Transaction Currency

Visualization Type:

Table
Default Colors

Limit Data Records: 200

Tile

Title: Cash Position

Subtitle: Today

Parameter	Value
Tile Format	Numeric Tile
Navigation	Generic Drill-Down

More Information

For information on evaluations, drill-downs, and tiles, see SAP Smart Business on SAP Help Portal:

For SAP NetWeaver 7.31:
http://help.sap.com/nw-uiaddon Application Help SAPUI5 Application Frameworks
For SAP NetWeaver 7.4:
http://help.sap.com/nw74 Application Help UI Technologies in SAP NetWeaver UI Development Toolkit for HTML5 (SAPUI5) SAPUI5 Application Frameworks