Function documentationInteractive Database Connection

 

You connect Interactive Excel to a database by logging on to an SAP system.

Prerequisites

  • You have installed Microsoft Excel 2010 or later and SAP Interactive Excel, version 3.0.

  • You have set up a connection to an SAP ERP backend system on which Enterprise Controlling Consolidation (EC-CS) or Business Consolidation (SEM-BCS) is installed.

  • The source database in the backend system for report data is accessed through your local area network. Therefore, you must have access to the appropriate database tables.

Features

Simple Connection of Interactive Excel to a Database

You connect Interactive Excel to a database by logging on to an SAP system from the SAP Interactive Excel tab in Microsoft Excel.

  1. Open an empty file or predefined a file that you created using the Interactive Excel add-in.

  2. Open the delivered template (SAPExcelWorkbook.xltm) or another file that was created by using Interactive Excel earlier.

  3. Click Start of the navigation path SAP Interactive Excel Next navigation step Log On End of the navigation path.

  4. In the SAP Logon dialog box, log on to the Business Consolidation (SEM-BCS) or Enterprise Controlling Consolidation (EC-CS) system.

    Interactive Excel is connected to the database and the Data Matrix tab is added to standard Microsoft Excel ribbon. Additional functions are available on the SAP Interactive Excel tab.

Note Note

You can connect a workbook to only one database in the backend system at a time.

End of the note.
Communication Between Interactive Excel and the Database

Data can be transferred between Interactive Excel and a database as follows:

  • You can save data entered in an Interactive Excel form to a totals InfoCube for SEM-BCS in SAP NetWeaver Business Warehouse or to a totals database table in an EC-CS system.

  • You can import data from a totals InfoCube for SEM-BCS in SAP NetWeaver Business Warehouse or from a totals database table for EC-CS into an Interactive Excel report.

  • You can use the master data and control parameters stored in the database as value proposals when defining data entry forms and reports.

Loading of Interface Texts for Interactive Excel

The language that you specify when logging on to the SAP system determines the language that appears on the user interface of Interactive Excel.