Interactive Database Connection (SAP Library

Interactive Database Connection

Use

This central function of Interactive Excel enables you to do the following:

Save reported financial data from a data entry form to the database
Import up-to-the-minute data into reports defined in Interactive Excel
Use master data and control parameters stored in the database as value proposals when defining data entry forms and reports

Prerequisites

You have access to the appropriate database.

Features

Communication Between Interactive Excel and the Database

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

You can only save data entered in an Interactive Excel form to an Access database for the offline data entry program.
You can import data from an Access database or a SAP System into an Interactive Excel report.

Loading of Interface Texts for Interactive Excel

When using an Access database for the offline data entry program

The interface texts for Interactive Excel are stored in the Access database and originate in the SAP System. You specify the text language when you download master data and control parameters from the central SAP System into the database.

When using a SAP System as a database

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