Working with Check Marks |
Checkbox is a control that a user clicks to select or deselect an option. A check mark in the checkbox indicates that the option is selected and checkbox empty indicates that the checkbox is not selected.
While recording, whenever a checkbox is selected it is auto-recorded in the mapper of the Process Runner script. Usually, a hard-coded ‘X’ in the Mapper represents that the checkbox was enabled. The same will work for selection boxes and not just checkboxes. Process Runner recognizes selection boxes and when these selection boxes are selected during recording, it is recorded as 'X' in Mapper as shown in the below screenshot where a selection is made from grid line item selection boxes.
You can also map the checkbox fields to Excel column using the below mentioned options .
A.Changing the mapping type to ‘Excel to SAP’:
'X' places a check mark in the checkbox and if ‘X’ is replaced with a blank/space then it unchecks that box while execution.Let us look into the below example where you have options to select Operative indicators - Planning element, Account Assignment element and Billing element.
The data file with 'X' for Planning Element, Account Assignment and Billing element fields indicates to enable respective check boxes in SAP and the empty spaces indicate the fields to be unchecked in SAP.
Go to the ‘Mapper’ tab and map the excel columns for these indicators as shown below.
Run the file. The check marks placed for the indicators in SAP are as per the data supplied.
B.Transaction Recording options:
'Automap all check mark ("X") to Excel' option in the Transaction Recording options window makes sure that the recorded check boxes are auto mapped to the excel columns after the recording is done.
The Mapper should look like this.
Next: How to get field description from SAP System
|