Show TOC

 Configuration Settings: Aging Analysis

 

This document contains configuration information for the Aging 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_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: Aging Analysis

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

KPI Description: With this app, accounts payable managers can recognize the trends in the total payable amount, the not due amount, and the overdue amount in their businesses

Goal Type: Minimizing

Data Source

Parameter

Entry

SAP HANA View

sap.hba.r.sfin700/AccountsPayableFlexibleAgingQuery

OData Service

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

Entity Set

AccountsPayableFlexibleAging

Value Measure

AmountInDisplayCurrency_E

Semantic Object/Action

<empty>

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

Evaluation: Payable Amount

Evaluation ID: sap.hba.sfin.ap.AgingAnalysis.PayableAmount

Evaluation Description: With this app, accounts payable managers can recognize the trends in the total payable amount, the not due amount, and the overdue amount in their businesses

Data Source

Parameter

Value

OData Service

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

Entity Set

AccountsPayableFlexibleAging

Value Measure

AmountInDisplayCurrency_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

600000

Warning

500000

Target

400000

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_KeyDate

Equal to

<space>

Enter a date that should be used to compare against the due dates of payables. Payables whose due dates are before the key date are overdue; those whose due dates are on or after the key date are not yet overdue.

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_AgingGridMeasureInDays

Equal to

30

Enter the number of days in an interval. The app displays the overdue amount in intervals before the key date that you specify in the P_KeyDate input parameter and the not yet overdue amount in intervals after the key date.

An entry in this field is required.

P_NumberOfAgingGridColumns

Equal to

4

Enter the number of intervals for overdue amount and for not yet overdue amount, respectively.

An entry in this field is required.

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.

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 Company Code

View ID: sap.hba.sfin.ap.AgingAnalysis_sap.hba.sfin.ap.AgingAnalysis.PayableAmount_01

View Title: By Company Code

Measures and Dimensions:

Parameter

Value

Dimension

Company Code

Measures

  • Not Due Amount

  • Overdue Amount

Visualization Type:

  • Bar

  • Single Axis

  • Absolute Values

  • Manual Semantic Colors

Limit Data Records: 200

Drill-Down: By Aging

View ID: sap.hba.sfin.ap.AgingAnalysis_sap.hba.sfin.ap.AgingAnalysis.PayableAmount_02

View Title: By Aging

Measures and Dimensions:

Parameter

Value

Dimension

Aging Interval

KPI Measure

Amount in Display Currency

Visualization Type:

  • Column

  • Single Axis

  • Absolute Values

  • Default Colors

Limit Data Records: <empty>

Drill-Down: By Business Area

View ID: sap.hba.sfin.ap.AgingAnalysis_sap.hba.sfin.ap.AgingAnalysis.PayableAmount_03

View Title: By Business Area

Measures and Dimensions:

Parameter

Value

Dimension

Business Area

Measures

  • Not Due Amount

  • Overdue Amount

Visualization Type:

  • Bar

  • Single Axis

  • Absolute Values

  • Manual Semantic Colors

Limit Data Records: 200

Drill-Down: By Reconciliation Account

View ID: sap.hba.sfin.ap.AgingAnalysis_sap.hba.sfin.ap.AgingAnalysis.PayableAmount_04

View Title: By Reconciliation Account

Measures and Dimensions:

Parameter

Value

Dimension

Reconciliation Account

Measures

  • Not Due Amount

  • Overdue Amount

Visualization Type:

  • Bar

  • Single Axis

  • Absolute Values

  • Manual Semantic Colors

Limit Data Records: 200

Drill-Down: By Currency

View ID: sap.hba.sfin.ap.AgingAnalysis_sap.hba.sfin.ap.AgingAnalysis.PayableAmount_05

View Title: By Currency

Measures and Dimensions:

Parameter

Value

Dimension

Currency

Measures

  • Not Due Amount

  • Overdue Amount

Visualization Type:

  • Bar

  • Single Axis

  • Absolute Values

  • Manual Semantic Colors

Limit Data Records: 200

Drill-Down: By Payment Method

View ID: sap.hba.sfin.ap.AgingAnalysis_sap.hba.sfin.ap.AgingAnalysis.PayableAmount_06

View Title: By Payment Method

Measures and Dimensions:

Parameter

Value

Dimension

Payment Method

Measures

  • Not Due Amount

  • Overdue Amount

Visualization Type:

  • Bar

  • Single Axis

  • Absolute Values

  • Manual Semantic Colors

Limit Data Records: 200

Drill-Down: By Vendor Group

View ID: sap.hba.sfin.ap.AgingAnalysis_sap.hba.sfin.ap.AgingAnalysis.PayableAmount_07

View Title: By Vendor Group

Measures and Dimensions:

Parameter

Value

Dimension

Vendor Account Group

Measures

  • Not Due Amount

  • Overdue Amount

Visualization Type:

  • Bar

  • Single Axis

  • Absolute Values

  • Manual Semantic Colors

Limit Data Records: 200

Tile

Title: Aging Analysis

Subtitle: Payable Amount

Parameter

Value

Tile Format

Numeric Tile

Navigation

Generic Drill-Down

Semantic Object

AmountInDisplayCurrency_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.