Show TOC

 Configuration Settings: Open Purchase Orders

 

This document contains configuration information for the Open Purchase Orders app.

SAP Jam Integration

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

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: Open Purchase Orders

KPI ID: sap.hba.ecc.mm.pur.OpenPO

KPI Description: Displays the aggregated effective value of open purchase order items for which goods receipts are expected within a predefined period of time.

Goal Type: Minimizing (Lower is better)

Data Source

Parameter

Value

SAP HANA View

<empty>

OData Service

/sap/hba/r/ecc/odata/mm/pur/PurchaseOrderQueries.xsodata

Entity Set

PurchaseOrderOpenGoodsReceiptSet

Value Measure

PurchaseOrderOpenEffctvAmount_E

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

Evaluation: Open Purchase Orders

Evaluation ID: sap.hba.ecc.mm.pur.OpenPO.OpenPurchaseOrders

Evaluation Description: Displays the aggregated effective value of open purchase order items for which goods receipts are expected within a predefined period of time.

Data Source

Parameter

Value

OData Service

/sap/hba/r/ecc/odata/mm/pur/PurchaseOrderQueries.xsodata

Entity Set

PurchaseOrderOpenGoodsReceiptSet

Value Measure

PurchaseOrderOpenEffctvAmount_E

Scaling Factor

Auto
Targets, Thresholds, and Trend

This table shows some example values.

Parameter

Value

Example Value

Goal Type

Minimizing

Value Type

Fixed Value

Critical

<empty>

200000000

Warning

<empty>

160000000

Target

<empty>

150000000

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_CmpltlyDlvrdPurOrdItmIsExcld

Equal to

X or Space

Select this field if completely delivered items should not be included.

P_DisplayCurrency

Equal to

EUR

Choose a currency in which the currency amounts should be displayed. Ensure that exchange rates for this currency exit in your SAP ERP system.

An entry in this field is required.

P_EvaluationTimeFrameInDays

Equal to

100

Choose the number of days from the current date (either into the past or into the future) to specify the time frame for the calculation.

An entry in this field is required.

P_OffsetDays

Equal to

0

Enter the number of days by which the evaluation period should be moved.

An entry in this field is required.

P_SAPClient

Equal to

<nn>

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

An entry in this field is required.
Drill-Down 1: Open Purchase Orders By Company

View ID: sap.hba.ecc.mm.pur.OpenPO.OpenPurchaseOrders.byCompany

View Title: By Company

Measures and Dimensions:

Parameter

Value

Dimension

Company Code

KPI Measure

Open Purchase Order Effective Value

Visualization Type:

  • Column

  • Single Axis

  • Absolute Values

  • Default Colors

Limit Data Records: none

Drill-Down 2: Open Purchase Orders By Purchasing Organization

View ID: sap.hba.ecc.mm.pur.OpenPO.OpenPurchaseOrders.byPurchasingOrganization

View Title: By Purchasing Organization

Measures and Dimensions:

Parameter

Value

Dimensions

  • Company Code

  • Purchasing Organization

KPI Measure

Open Purchase Order Effective Value

Visualization Type:

  • Column

  • Single Axis

  • Absolute Values

  • Default Colors

Limit Data Records: none

Drill-Down 3: Open Purchase Orders By Supplier

View ID: sap.hba.ecc.mm.pur.OpenPO.OpenPurchaseOrders.bySupplier

View Title: By Supplier

Measures and Dimensions:

Parameter

Value

Dimension

Supplier Name

KPI Measure

Open Purchase Order Effective Value

Visualization Type:

  • Bar

  • Single Axis

  • Absolute Values

  • Default Colors

Limit Data Records: none

Drill-Down 4: Open Purchase Orders By Material Group

View ID: sap.hba.ecc.mm.pur.OpenPO.OpenPurchaseOrders.byMaterialGroup

View Title: By Material Group

Measures and Dimensions:

Parameter

Value

Dimension

Material Group Name

KPI Measure

Open Purchase Order Effective Value

Visualization Type:

  • Column

  • Single Axis

  • Absolute Values

  • Default Colors

Limit Data Records: none

Drill-Down 5: Open Purchase Orders By MRP Controller

View ID: sap.hba.ecc.mm.pur.OpenPO.OpenPurchaseOrders.byMRPController

View Title: By MRP Controller

Measures and Dimensions:

Parameter

Value

Dimension

MRP Controller Name

KPI Measure

Open Purchase Order Effective Value

Visualization Type:

  • Column

  • Single Axis

  • Absolute Values

  • Default Colors

Limit Data Records: none

Tile

Title: Open Purchase Orders

Subtitle: Open Purchase Orders

Parameter

Value

Tile Format

Numeric Tile

Navigation

Generic Drill-Down

Semantic Object

PurchaseOrder

Action

analyzeSBKPIDetails

More Information

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

  • For SAP NetWeaver 7.31:

    Start of the navigation path http://help.sap.com/nw-uiaddonInformation published on SAP site Next navigation step Application Help Next navigation step SAPUI5 Application Frameworks End of the navigation path

  • For SAP NetWeaver 7.4:

    Start of the navigation path http://help.sap.com/nw74Information published on SAP site Next navigation step Application Help Next navigation step UI Technologies in SAP NetWeaver Next navigation step UI Development Toolkit for HTML5 (SAPUI5) Next navigation step SAPUI5 Application Frameworks End of the navigation path