Show TOC

 Configuration Settings: Overdue Payables

 

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

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

KPI Description: With this app, accounts payable managers can monitor the status of overdue payments in their areas of responsibility.

Goal Type: Minimizing

Data Source

Parameter

Entry

SAP HANA View

sap.hba.r.sfin700/AccountsPayableOverdueQuery

OData Service

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

Entity Set

AccountsPayableOverdue

Value Measure

TotalOverdueAmtInDspCrcy_E

Semantic Object/Action

<empty>

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

Evaluation: Today

Evaluation ID: sap.hba.sfin.ap.OverdueAging.Interval30Days

Evaluation Description: Overdue payables shown in an interval of 30 days as of today

Data Source

Parameter

Value

OData Service

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

Entity Set

AccountsPayableOverdue

Value Measure

TotalOverdueAmtInDspCrcy_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

500000

Warning

400000

Target

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_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 the four intervals before the key date that you specify in the P_KeyDate input parameter.

An entry in this field is required.

P_Currency

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.OverdueAging.Interval30Days.sap.hba.sfin.ap.OverdueAging_sap.hba.sfin.ap.OverdueAging.var.Interval30Days_1

View Title: By Company Code

Measures and Dimensions:

Parameter

Value

Measures

  • Critically Overdue Amount in Display Currency

  • Uncritically Overdue Amount in Display Currency

  • Payables Not Overdue in Display Currency

KPI Measure

Total Overdue Amount in Display Currency

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.OverdueAging.Interval30Days.sap.hba.sfin.ap.OverdueAging_sap.hba.sfin.ap.OverdueAging.var.Interval30Days_2

View Title: By Vendor Group

Measures and Dimensions:

Parameter

Value

Dimension

Vendor Account Group

Measures

  • Critically Overdue Amount in Display Currency

  • Uncritically Overdue Amount in Display Currency

  • Payables Not Overdue in Display Currency

KPI Measure

Total Overdue Amount in Display Currency

Visualization Type:

  • Bar

  • Single Axis

  • Absolute Values

  • Manual Semantic Colors

Limit Data Records: 200

Drill-Down: By Reason for Block

View ID: sap.hba.sfin.ap.OverdueAging.Interval30Days.sap.hba.sfin.ap.OverdueAging_sap.hba.sfin.ap.OverdueAging.var.Interval30Days_3

View Title: By Reason for Block

Measures and Dimensions:

Parameter

Value

Dimension

Payment Blocking Reason

Measures

  • Critically Overdue Amount in Display Currency

  • Uncritically Overdue Amount in Display Currency

  • Payables Not Overdue in Display Currency

KPI Measure

Total Overdue Amount in Display Currency

Visualization Type:

  • Bar

  • Single Axis

  • Absolute Values

  • Manual Semantic Colors

Limit Data Records: 200

Drill-Down: By Vendor: Intervals 30 days

View ID: sap.hba.sfin.ap.OverdueAging.Interval30Days.sap.hba.sfin.ap.OverdueAging_sap.hba.sfin.ap.OverdueAging.var.Interval30Days_4

View Title: By Vendor: Intervals 30 days

Measures and Dimensions:

Parameter

Value

Dimension

Vendor

Threshold Measure

Payables in 1st Due Period

Measures

  • Payables in 2nd Due Period

  • Payables in 3rd Due Period

  • Payables in 4th Due Period

  • Payables Not Overdue in Display Currency

Visualization Type:

  • Bar

  • Single Axis

  • Absolute Values

  • Default Colors

Limit Data Records: 200

Tile

Title: Overdue Payables

Subtitle: Today

Parameter

Value

Tile Format

Comparison Tile

Navigation

Generic Drill-Down

Semantic Object

TotalOverdueAmtInDspCrcy_E

Action

analyzeSBKPIDetails

Customizing

To define the threshold that determines when the overdue payment amount is critically overdue, carry out the Customizing activity Define Thresholds for Vendor Account Groups under Start of the navigation path Financial Accounting (New) Next navigation step Accounts Receivable and Accounts Payable Next navigation step Vendor Accounts Next navigation step Overdue Payables End of the navigation path.

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.