New features in TRANSACTION version 10.6/10.7 > Advanced mapping > Limiting input fields

Back to

Advanced mapping

Limiting input fields

To help limit errors during data input, you can restrict values available for certain fields in the Excel data file. These values are statically stored with the TRANSACTION script and do not change when other values are changed in the Excel or Text file during Run.

  1. In the SAP recording pane, select the field you on which you want to restrict values.
  2. Click the Properties slide-in. Select Validate by list.

    Properties with Validate by List

  3. Click the values button to create the validation list. Create your value list by using one of the following methods:
    • Import values from an Excel file
    • Import values from a CSV Text file
    • Type in the values manually

When you validate or run this script, the selected field values are validated against the list. If there are any errors, the corresponding row or record will not reach SAP for posting or for validation and a warning message is sent.

List of values supports wildcard characters. For example, if you use 1* in the values list to denote all values that start with 1 as valid values for the field.

In addition, this list will be available for input instead of the SAP values list when you use the look up function from in the RUNNER add-in for Excel.

Also in this section

Editing in the Mapper

Filtering mapper settings

Advanced looping capability

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

Downloading from SAP

Editing a TRANSACTION script