Displaying the Version of Your SAP IBP System

You can display the version and hotfix level of the SAP IBP system you're logged on to from the SAP Integrated Business Planning, add-in for Microsoft Excel (Excel Add-in).

You can display the version and hotfix level of the SAP IBP system that you're logged on to in one of the following ways:
  • Hovering your mouse over the Help button in the SAP IBP ribbon.

  • Using the formula =SOP_Connection_Name in the planning view.

  • Using the following formula in the planning view template, providing a subtract of your tenant URL for the placeholder <systemURL> : =IF(ISNUMBER(SEARCH("<systemURL>";IBPServer()));"Productive";"")& IF(ISNUMBER(SEARCH("<systemURL>";IBPServer()));"Test";"")

Prerequisites

To display the version of your SAP IBP system by hovering your mouse over the Help button, you must do the following: in Microsoft Excel, under Start of the navigation pathGeneral Next navigation step User Interface OptionsEnd of the navigation path, in the ScreenTip style field, select Show feature descriptions in ScreenTips. For more information about ScreenTips, see https://support.microsoft.com/en-us/office/show-or-hide-screentips-72d92d6a-6d2a-40fd-9ac2-fb9413ffce18Information published on non-SAP site.

It makes sense to provide meaningful information about your systems in the connection manager, so that when users check the system that they're logged on to, the information they get is meaningful. For more information, see Setting Up a Connection to SAP IBP and the Planning Area.