Downloading from SAP

New features in TRANSACTION version 10.6/10.7 > Advanced mapping > Downloading from SAP

Back to

Downloading from SAP

TRANSACTION allows you to download or read data from SAP, which is helpful for updating data or creating reports. This command allows you to assign columns for SAP fields which are being downloaded.

You can set up the TRANSACTION script for the download by using the Mapper's drag-and-drop feature or by using the options in the Mapping Type column.

To use the drag and drop feature

Drag the SAP field you want to Read From SAP to the appropriate data source field in the previewer.

To use the options in the Value column

Specify in the Value column the Excel column or the Access field to be used, according to the data source.

Read from SAP

The Read from SAP button acts as a kind of Auto Map in reverse—it downloads data from SAP and automatically maps the downloaded data to the columns or cells of your data source.

To automatically download from SAP and map

On the Mapping pane, click Read from SAP.
The button marks only field and log rows for download.

Key Points:

This command is available only for SAP version 4.6 and later and requires additional authorization in SAP.
Downloading can be performed when the recording is created using Non-Batch Input Mode and GUI scripting. See "Entering the Recording Properties" for more information.
Assign columns with no data as receiver columns. TRANSACTION does not check if there are any values present in the assigned Excel receiver column. It overwrites all values in the receiver columns, even when no value from SAP is returned.
TRANSACTION does not format the Excel receiver column. The Excel column must be formatted to appropriate data types before running the TRANSACTION script. For example, if the column is not formatted as Text and a value of 004 is assigned to that column, Excel converts this value to 4. To retain the value of 004, format that column as Text before the run.
TRANSACTION may run a little slower when this command is run. For this reason, use this command only when required. If the TRANSACTION script does not have any fields marked as Read From SAP, TRANSACTION automatically switches back to update only mode.
Note: This command works the same way for an Access database. Simply substitute <Access receiver field name> for <Excel receiver column ID>.

Also in this section

Editing in the Mapper

Filtering mapper settings

Advanced looping capability

Limiting input fields

Mapping Google spreadsheets

Setting conditions: IF statements

Validating data

Validate by list

Compensating for missing SAP screens and fields

Undo and Undo All

Mapping long text

Converting data types to strings

Attaching documents

Auto mapping

Editing a TRANSACTION script