Background documentationOnline Data Entry with Interactive Excel

 

You can use Interactive Excel for data entry within a subsidiary in different scenarios. Each scenario is determined by decisions taken within a subsidiary concerning the technical organization and procedures for data entry.

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

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

    For information, see Interactive Database Connection.

  • You can make different formatting settings and general definitions for your work with Interactive Excel.

    For information, see Interactive Excel Settings.

  • You can create a data matrix as a data entry form or report and used the data matrix to enter financial data in the consolidation backend system.

    For information, see Data Matrix.

  • You can export financial data entered in a data matrix into a backend system.

    For information, see Saving of Financial Data to a Database.

  • You can view important information about the status and the origin of data in a data matrix, a pivot table, or an individual cell on a worksheet.

    For information, see Information about the Origin of Data.

  • As a security measure or for test or presentation purposes, you can create a copy of a worksheet or a workbook.

    For information, see Creating a Snapshot of a Worksheet or Workbook.

  • After the completion of data entry in Interactive Excel, you can continue processing the data in the SAP system. In particular, you can perform consolidation tasks that use the reported financial data maintained in Interactive Excel as input data.

Scenario Example

  1. You must assign the Interactive Excel data collection procedure to the data collection method that you assign to one data collection task for the consolidation units, for example, companies, which will enter their reported financial data by using Interactive Excel.

  2. A subsidiary creates its own data entry matrices in Interactive Excel based on the master data and the control parameters in the consolidation backend system. It may also run a preparation for data entry for the matrices.

  3. The subsidiary enters its financial data in the matrices and saves the data to the totals InfoCube of Business Consolidation (SEM-BCS) or to the totals database table of Enterprise Controlling Consolidation (EC-CS).

Note Note

The parent company does one of the following:

  • Allows its subsidiaries to define their own matrices

  • Creates templates for matrices centrally and distributes them to its subsidiaries

End of the note.

More Information