Calling the Wizard 

Use

A Wizard helps you with mapping between cells in a data sheet and the database fields in the SAP System when you work with Microsoft Excel as an Office application.

Prerequisites

A document is open. For more information see Creating or Opening Documents.

You have set up the layout. Further information can be found under Exporting Characteristics for Layout.

Procedure

  1. Select .

A dialog box appears.
  1. Select either a workbook or a template (locally stored file).
  1. Enter the required data and select Continue.

A dialog box appears.
  1. Enter the name of the table sheet and the name of the control sheet and select Continue.

A dialog box appears.
  1. Select a mode:

Mapping is done using characteristic names.

Mapping is done using characteristic names and characteristic descriptions including units of measure and long texts.
  1. Select Continue.

A dialog box appears with a table.
  1. Do the following to define the cells for the characteristic values:
    1. Click each row in the Cell for characteristic value.
    2. Use the arrow keys to move the pointer in the Office application area in the selected table sheet.

The system

    1. Once you have selected the cells you want for characteristic values, confirm this.
    2. Repeat steps from a to c for all characteristics.
  1. Select Continue.

See also:

Excel Documents