Show TOC

 Invoice Price Change Locate this document in the navigation structure

 

The analytical app displays the Key Performance Indicator (KPI) Invoice Price Change for a company code when comparing two periods. You can identify the price changes of materials based on invoices. With Invoice Price Change you can find the price of a material in an invoice, the average price of a material, the weighted price of a material (where the weighting relates to the value in the invoices), the material price change in percent, the total spend for an evaluation base, such as a purchasing group or a material group, and the total weighted price change for an evaluation base, such as a purchasing group or a material group.

Key Features

  • Possible evaluation bases within a company code are:

    • the company code itself

    • a supplier

    • a material group

    • a purchasing organization

    • a purchasing group

    • a material

  • Possible periods are:

    • monthly

    • quarterly

    • yearly

  • Calculation rule:

    To determine a price change, two comparison periods are determined by input parameters and an evaluation base. Then all invoices for materials that have invoices in both periods are determined and used to calculate average and weighted prices for each period and for each material. The overall price change for the evaluation base is determined by the sum of the weighted prices for each material. The weighting is based on the spend.

  • Generic drill down:

    You can use the following measures:

    • weighted material price change

    • spend

  • Corresponding Query view: sap.hba.ecc.PurchasingMaterialPriceChangeQuery

  • KPI type: percentage, amount

  • Dimensions:

    • Input parameters:

      • SAP client

      • company code

      • overall spend as criterion for evaluation

      • supplier spend as criterion for evaluation

      • material group spend as criterion for evaluation

      • material spend as criterion for evaluation

      • purchasing organization spend as criterion for evaluation

      • purchasing group spend as criterion for evaluation

      • previous year as evaluation time frame

      • evaluation on quarterly basis

      • evaluation on monthly basis

    You must always specify the SAP client and the company code. Then you specify the evaluation base. This must be done uniquely. If you want to use the company code as the evaluation base, set the “overall spend as criterion for evaluation”to “X”. You must then set the other input parameters with respect to the evaluation base to “-”. If you want to use a different evaluation base in the company code, set the specific input parameter to the entity that needs to be investigated, for example, for P_VendorAsEvalBase (label Supplier Spend as Criterion for Evaluation) to the “ID of the vendor”, and all other input parameters for the evaluation base to “-”. If you want to compare years, set the “previous year as evaluation time frame” to “X”. If you want to compare on a monthly basis, set the “evaluation on monthly basis” to “X” and “evaluation on quarterly basis” to “-”. If you want to compare on a quarterly basis, set the parameters the other way around. If you want to evaluate for the entire year, set the “evaluation on monthly basis” and “evaluation on quarterly basis” to “-”.

    Example Example

    Purpose/Desired Result

    Setting to Be Made

    Company Code as evaluation base and Comparison of Years and Comparison on Quarterly Basis

    “Overall Spend as Criterion for Evaluation” = “X” and “Other Input Parameters with Respect to the Evaluation Base” = “-” and “Evaluation on Quarterly Basis” = “X” and “Evaluation on Monthly Basis” = “-” and “Previous Year as Evaluation Time Frame” = “X”

    Supplier “Test” as evaluation base and Comparison Within Current Year and Comparison on Monthly Basis

    “Overall Spend as Criterion for Evaluation” = “-” and “Supplier Spend as Criterion for Evaluation” = “Test” and “Other Input Parameters with Respect to the Evaluation Base”= “-” and “Evaluation on Quarterly Basis”= “-” and “Evaluation on Monthly Basis” = “X” and “Previous Year as Evaluation Time Frame” = “-”
    End of the example.

  • Filters:

    The following filters uniquely determine the invoice:

    • purchasing document

    • purchasing document item

    • account assignment number

    • material document year

    • material document

    • material document item

    Further filters:

    • supplier

    • material

    • material group

    • purchasing organization

    • purchasing group

  • Measures:

    • Spend amount in company code currency, and weighted material price change in percent

      These measures can be aggregated.

    • Material price change in percent, weighted material price in company code currency, previous weighted material price in company code currency, average material price in company code currency, and previous average material price in company code currency

      These measures are only valid with respect to a material and cannot be aggregated beyond materials.

    • Invoice material price in company code currency

      This measure is only valid for a specific invoice (see the Filters listed above on how to determine the invoice in question). This measure cannot be aggregated beyond the invoice.

System Landscape Requirements

The app consists of front-end components and back-end components. The back-end and the front-end components are delivered in separate products and have to be installed in a system landscape that is enabled for SAP Fiori.

SAP Smart Business Product

SAP Smart Business 1.0 for SAP ERP

Contains Virtual Data Model (VDM)

SAP HANA Analytics for ERP 1.0

SAP Business Suite Product

SAP enhancement package 7 for SAP ERP 6.0 SPS05

Component for Customer Incidents

Analytics based on HANA DB (MM-PUR-HBA)

More Information

App History: Invoice Price Change

App Implementation: Invoice Price Change