Show TOC

 Configuration Settings: Cash Discount Forecast

 

This document contains configuration information for the Cash Discount Forecast 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_implementationInformation published on SAP site Next navigation step Configuration of SAP Fiori Infrastructure Next navigation step With SAP NetWeaver 7.5 Next navigation step English Next navigation step Configuration of SAP Fiori Infrastructure Next navigation step 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: Cash Discount Forecast

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

KPI Description: With this app, accounts payable managers can analyze the key figures for the forecast of cash discounts for their businesses.

Goal Type: Minimizing

Data Source

Parameter

Entry

SAP HANA View

sap.hba.r.sfin700/AccountsPayableCashDiscountForecastQuery

OData Service

/sap/hba/r/sfin700/odata/ap/kpi.xsodata

Entity Set

AccountsPayableCashDiscountForecast

Value Measure

ExpiringCshDiscInDspCrcy_E

Semantic Object/Action

<empty>

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

Evaluation: Expiring in 1 Month

Evaluation ID: sap.hba.sfin.ap.CashDiscountForecast.ExpiringIn1Month

Evaluation Description: With this app, accounts payable managers can analyze the key figures for the forecast of cash discounts for their businesses.

Data Source

Parameter

Value

OData Service

/sap/hba/r/sfin700/odata/ap/kpi.xsodata

Entity Set

AccountsPayableCashDiscountForecast

Value Measure

ExpiringCshDiscInDspCrcy_E

Scaling Factor

Auto

Decimal Precision

Auto
Targets, Thresholds, and Trend

This table shows some example values.

Parameter

Value

Example Value

Goal Type

Minimizing

Value Type

Fixed Value

Critical

<empty>

500000

Warning

<empty>

400000

Target

<empty>

300000

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

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_KeyDate

Equal to

<space>

Enter a date that is used to determine the period for analyzing cash discount forecast. The app displays the cash discounts that are expiring in the period determined by the P_CashDiscountForecastDays input parameter and the P_KeyDate input parameter.

An entry in this field is required. Enter a date in the format yyyymmdd. To specify today as the key date, enter a space.

P_CashDiscountForecastDays

Equal to

30

Enter the number of days after the key date. The app displays the cash discounts that are expiring in the period determined by the P_CashDiscountForecastDays input parameter and the P_KeyDate input parameter.

An entry in this field is required.

P_PaymentCycle

Equal to

1

Specify whether you make weekly or monthly payments.

An entry in this field is required. If you make weekly payments, enter 1. If you make monthly payments, enter 2.

P_PaymentDay1

Equal to

5

Enter the first payment day in the week or the month.

An entry in this field is required.

Example Example

If you specify to make weekly payments in the P_PaymentCycle input parameter and if you make payments on Mondays and Fridays, enter 1 for the P_PaymentDay1 input parameter and 5 for the P_PaymentDay2 input parameter.

If you specify to make monthly payments in the P_PaymentCycle input parameter and if you make payments on the 10th and the 20th day of each month, enter 10 for the P_PaymentDay1 input parameter and 20 for the P_PaymentDay2 input parameter.

End of the example.

P_PaymentDay2

Equal to

0

Enter the second payment day in the week or the month.

An entry in this field is optional. If you do not have a second payment day, enter 0.

P_PaymentDay3

Equal to

0

Enter the third payment day in the week or the month.

An entry in this field is optional. If you do not have a third payment day, enter 0. Also, if you specify to make weekly payments in the P_PaymentCycle input parameter, only two payment days are supported; the app ignores the third payment day you enter.

P_SAPClient

Equal to

200

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

An entry in this field is required.
Drill-Down: By Company Code

View ID: sap.hba.sfin.ap.CashDiscountForecast_sap.hba.sfin.ap.CashDiscountForecast.ExpiringIn1Month_01

View Title: By Company Code

Measures and Dimensions:

Parameter

Value

Dimension

Company Code

KPI Measure

Expiring Cash Discounts

Measures

  • Expired Cash Discounts Before Key Date

  • Available Cash Discounts on Key Date

Visualization Type:

  • Bar

  • Single Axis

  • Absolute Values

  • Default Colors

Limit Data Records: 200

Drill-Down: By Payment Terms

View ID: sap.hba.sfin.ap.CashDiscountForecast_sap.hba.sfin.ap.CashDiscountForecast.ExpiringIn1Month_02

View Title: By Payment Terms

Measures and Dimensions:

Parameter

Value

Dimension

Payment Terms

KPI Measure

Expiring Cash Discounts

Measures

  • Expired Cash Discounts Before Key Date

  • Available Cash Discounts on Key Date

Visualization Type:

  • Bar

  • Single Axis

  • Absolute Values

  • Default Colors

Limit Data Records: 200

Drill-Down: By Payment Date

View ID: sap.hba.sfin.ap.CashDiscountForecast_sap.hba.sfin.ap.CashDiscountForecast.ExpiringIn1Month_03

View Title: By Payment Date

Measures and Dimensions:

Parameter

Value

Dimension

Payment Date

Measures

  • Cash Discounts Expiring Before Next Payment Day

  • Cash Discounts for Invoices with Payment Block

Visualization Type:

  • Column

  • Single Axis

  • Absolute Values

  • Default Colors

Limit Data Records: <empty>

Tile

Title: Cash Discount Forecast

Subtitle: Expiring in 1 Month

Parameter

Value

Tile Format

Numeric Tile

Navigation

Generic Drill-Down

Semantic Object

ExpiringCshDiscInDspCrcy_E

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/ssbInformation published on non-SAP site Next navigation step Tools Next navigation step SAP Smart Business Foundation Component Next navigation step [Language] Next navigation step SAP Smart Business Modeler Apps End of the navigation path.