Show TOC

 Configuration Settings: Overdue Receivables

 

This document contains configuration information for the Overdue Receivables 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: Overdue Receivables

KPI ID: sap.hba.sfin.ar.OverdueReceivables

KPI Description: Ratio of overdue amounts receivable divided by total open amounts receivable

Goal Type: Minimizing

Data Source

Parameter

Value

SAP HANA View

sap.hba.r.sfin700.OverdueAccountsReceivableQuery

OData Service

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

Entity Set

OverdueAccountsReceivable

Value Measure

OverdueReceivablesInPercent

Semantic Object/Action

<empty>

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

Evaluation: Today

Evaluation ID: sap.hba.sfin.ar.OverdueReceivables.Today

Evaluation Description: Overdue receivables - current status

Data Source

Parameter

Value

OData Service

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

Entity Set

OverdueAccountsReceivable

Value Measure

OverdueReceivables

Semantic Object/Action

<empty>

Scaling Factor

Percent

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

Targets, Thresholds, and Trend

Parameter

Example Value

Goal Type

Minimizing

Value Type

FIXED

Critical

0.3

Warning

0.15

Target

0.1

Trend

(Not applicable)

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

P_NetDueInterval1inDays

Equal to

30

Choose the number of days from today until the end of the first interval. The app will aggregate the overdue receivables from today until the end of P_NetDueInterval1inDays, and display the result in the drill-downs.

P_NetDueInterval2inDays

Equal to

60

Choose the number of days from today until the end of the second interval. The app will aggregate the overdue receivables from the end of P_NetDueInterval1inDays to the end of P_NetDueInterval2inDays, and display the result in the drill-downs.

P_NetDueInterval3inDays

Equal to

90

Choose the number of days from today until the end of the third interval. The app will aggregate the overdue receivables from the end of P_NetDueInterval2inDays to the end of P_NetDueInterval3inDays, and display the result in the drill-downs.

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.
Drill-Down: By Due Period

View ID: sap.hba.sfin.ar.OverdueReceivables.Today.ByDuePeriod

View Title: By Due Period

Measures and Dimensions:

Parameter

Value

Dimension

Net Due Interval

Measures

  • Receivables Not Overdue

  • Receivables in 1st Due Period

  • Receivables in 2nd Due Period

  • Receivables in 3rd Due Period

  • Receivables in 4th Due Period

Visualization Type:

  • Column

  • Single Axis

  • Absolute Values

  • Manual Colors

Limit Data Records: 200

Drill-Down: By Customer (Top 10 Receivables, Chart)

View ID: sap.hba.sfin.ar.OverdueReceivables.Today.ByCustomerChart

View Title: By Customer (Top 10 Receivables, Chart)

Parameter

Value

Dimension

Customer

Measures

  • Receivables in 1st Due Period

  • Receivables in 2nd Due Period

  • Receivables in 3rd Due Period

  • Receivables in 4th Due Period

Visualization Type:

  • Bar

  • Single Axis

  • Absolute Values

  • Manual Colors

Limit Data Records: 10

Drill-Down: By Customer (Top 10 Receivables, Table)

View ID: sap.hba.sfin.ar.OverdueReceivables.Today.ByCustomerTable

View Title: By Customer (Top 10 Receivables, Table)

Parameter

Value

Dimension

Customer

Measures

  • Receivables Total Overdue

  • Open Items

Visualization Type:

  • Table

  • Default Colors

Limit Data Records: 10

Drill-Down: By Company Code (Chart)

View ID: sap.hba.sfin.ar.OverdueReceivables.Today.ByCompanyChart

View Title: By Company Code (Chart)

Parameter

Value

Dimension

Company Code

Measures

  • Receivables in 1st Due Period

  • Receivables in 2nd Due Period

  • Receivables in 3rd Due Period

  • Receivables in 4th Due Period

Visualization Type:

  • Bar

  • Single Axis

  • Absolute Values

  • Manual Colors

Limit Data Records: 200

Drill-Down: By Company Code (Table)

View ID: sap.hba.sfin.ar.OverdueReceivables.Today.ByCompanyTable

View Title: By Company Code (Table)

Parameter

Value

Dimension

Company Code

Measure

Receivables Total Overdue

Visualization Type:

  • Table

  • Default Colors

Limit Data Records: 200

Drill-Down: By Accounting Clerk (Chart)

View ID: sap.hba.sfin.ar.OverdueReceivables.Today.ByAccountingClerkChart

View Title: By Accounting Clerk (Chart)

Parameter

Value

Dimension

Accounting Clerk

Measures

  • Receivables in 1st Due Period

  • Receivables in 2nd Due Period

  • Receivables in 3rd Due Period

  • Receivables in 4th Due Period

Visualization Type:

  • Bar

  • Single Axis

  • Absolute Values

  • Manual Colors

Limit Data Records: 200

Drill-Down: By Accounting Clerk (Table)

View ID: sap.hba.sfin.ar.OverdueReceivables.Today.ByAccountingClerkTable

View Title: By Accounting Clerk (Table)

Parameter

Value

Dimension

Accounting Clerk

Measure

Receivables Total Overdue

Visualization Type:

  • Table

  • Default Colors

Limit Data Records: 200

Tile

Title: Overdue 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/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.