Using Financial Key Figures and Pricing

Objective

After completing this lesson, you will be able to use financial key figures.

Financial Key Figures

In a standard predefined SAP IBP planning area for demand planning processes, we have the following key figures that are used to show the quantities in monetary equivalent:

  • Actuals Revenue (ACTUALSREV):

    Used to store the actual revenue data that you upload. Since this key figure is currency-dependent, it models how currency conversion works in SAP IBP.

  • Actuals Price (ACTUALSPRICE):

    Used to store the calculated price based on the ACTUALSREV and ADJDELIVQTY key figures. No separate currency conversion is modeled because the conversion is already done for the input key figure ACTUALSREV.

  • Statistical Forecast Price (STATISTICALFCSTPRICE):

    Used to store price information mainly for future periods. You can forecast the price using a statistical forecasting method, but you can also enter or upload it manually. Since this key figure is currency-dependent, it models how currency conversion works in SAP IBP.

  • Sales Forecast Price (SALESFCSTPRICE):

    Used to store calculated price information. It is equal to ACTUALSPRICEm, if ACTUALSPRICE is not NULL. Otherwise, it is equal to STATISTICALFCSTPRICE. Past periods are equal to ACTUALSPRICE and future periods are equal to the forecasted or estimated price. No separate currency conversion is modeled because the key figure equals another converted-price key figure.

  • Sales Forecast Revenue (SALESFCSTREV):

    Used to store the calculated revenue based on SALESFCSTQTY and SALESFCSTPRICE.

  • Consensus Demand Plan Revenue (CONSENSUSDEMANDREV):

    Used to store the calculated revenue based on CONSENSUSDEMAND and SALESFCSTPRICE.

  • Marketing Forecast Revenue (MARKETINGFCSTREV):

    Used to store the calculated revenue based on MARKETINGFCSTQTY and SALESFCSTPRICE.

Other required key figures can be created to cover additional processes that may exist in customer business processes.

Financial Key Figures

Key Figure IDKey Figure Name 
ACTUALSREVActuals Revenue

Used to store actual revenue data that you upload. Being currency dependent, this key figure models how currency conversion works in SAP Integrated Business Planning.

ACTUALSPRICEActuals Price

Used to store the calculated price based on the ACTUALSREV and ADJDEL IVQTY key figures. There is no separate currency conversion modeled as the conversion is already done for the input key figure ACTUALSREV.

STATISTICALFCSTPRICEStatistical Forecast Price

Used to store price information mainly for future periods. You can forecast the price using a statistical forecasting method, but you can also enter or upload it manually. Being currency-dependent, this key figure models currency conversion works in SAP Integrated Business Planning.

SALESFCSTPRICESales Forecast Price

Used to store calculated price information Equals ACTUALSPRICE not NULL. Otherwise equals STATISTICALFCSTPRICE. Past periods are equal to ACTUALSPRICE; future periods are equal to the forecasted or estimated price. There is no separate currency conversion modeled as the key figure equals another converted price key figure.

SALESFCSTREVSales Forecast Revenue

Used to store the calculated revenue based on SALESFCSTQTY and SALESFCSTPRICE.

CONSENSUSDEMANDREVConsensus Demand Plan Revenue

Used to store the calculated revenue based on CONSENSUSDERAND and SALESFCSTPRICE.

MARKETINGFCSTREVMarketing Forecast Revenue

Used to store the calculated revenue based on MARKETINGFCSTQTY and SALESFCSTPRICE.

Convert Quantities to Financial Figures

Converting quantities to Financial Figures can be beneficial to sales and marketing people who work with budgets and revenues. Real-time conversion is supported by SAP IBP for demand, and is explored in this exercise.

Steps

  1. Log on to the add-in for Microsoft Excel, choose your planning view favorite, edit the view, and choose the following three new settings. Delete all other worksheets and save this view as a new favorite called Demand Revenue.

    SelectionValue
    Time SettingWeekly , next 20 weeks
    Planning LevelProduct ID, Customer ID
    Key FiguresConsensus Demand without Promotions, Statistical Forecast Price, and Consensus Demand Plan Revenue
    CurrencyUSD
    1. Log in to the add-in for Microsoft Excel with the login credentials provided by the instructor.

    2. In the Planning View section, choose FavoritesDemand Planning.

    3. Choose edit view, deselect all key figures, and choose the following three new key figures: Consensus Demand without Promotions, Statistical Forecast Price, and Consensus Demand Plan Revenue.

    4. Select the currency USD and choose OK.

    5. Save the view as a new favorite called Demand Revenue by selecting the favorites dropdown in the Planning View section of the IBP ribbon and choosing Add....

  2. Observe how the price influences the Consensus Demand Plan Revenue calculations. Change the price for Product HT_0## and Customer NA100 - High Tech Superstore.

    1. Change the price to 10 in the key figure Statistical Forecast Price four weeks from now and choose Simulate- Simulate(Basic).

    2. Observe that the key figure Consensus Demand Plan Revenue has now been calculated.

  3. Observe how key figure calculations are configured using the SAP Fiori UI.

    1. Log in to the SAP Fiori User Interface with the login credentials given by the instructor.

    2. Choose the Planning Areas Model Configuration app and select the radio button for ID ZSAP6.

    3. Go to the Key figure tab and review the calculation on key figure CONSENSUSDEMANDREV.