Back to

Advanced mapping

Validate by list

With the Validate by list feature, you can restrict values for a field. This list is available for input instead of the SAP values list when you use the look-up function from the add-in for Excel.

To validate by list

  1. In the Mapper, select the field you want to validate or restrict values on.
  2. Click the Properties pane and select the Validate by List check box.
  3. Click Values below the check box to create the validation list.
  4. Create your value list by using one of these methods:
    • Import values from an Excel file
    • Import values from a CSV text file
    • Type in values manually

    Note that these values are statically stored with the TRANSACTION script and do not change when the values in Excel or text file change during a run.

When you validate or run this script, the selected field values will be validated against that list. If there are any errors, the corresponding row or record will not reach SAP for posting or validation and the user will receive this error: The following column(s) contain(s) invalid data entries: <column>.

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

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