Advanced View

This topic describes how to view the Mapper grid in Advanced View.

To view the Mapper grid in Advanced View

  1. In Process Runner, open a Process File and select Mapper > Simple View. The advanced view of the Mapper grid is displayed.
    2. s

    Following are the fields on the Mapper grid for the Advanced View:

    • (Only for Transaction and GUI Script) Active: Indicates the rows that are active and considered during the run.
    • (Only for BAPI/RFM and Data Extractor) Parameter Name: Indicates the rows that are active and considered during the run.
    • (Only for GUI Script) Looping: Displays SAP screen name.
    • (Only for Transaction) Screen Name: Displays SAP screen name.
    • (Only for BAPI/RFM, Transaction, and Data Extractor) Field: Displays SAP field name.
    • Field Description: Displays the description of the field.
    • (Only for BAPI/RFM and Data Extractor) Table: Displays Associated Type as defined in interface for BAPI. It could be SAP structure or Table.
    • Mapping Type: Displays the Mapping type for the row. Following are the mapping types:
      • Excel to SAP:  Places value received from Excel column to SAP.
      • SAP to Excel:  Places value received from SAP to given Excel column.
      • Fix Single Value:  Uses the value provided in the Map Value column.
      • System Value: Uses dynamically calculated value as provided in Map Value column.
      • Excel Cell Value:  Places value received from SAP to given Excel cell.
    • Map Value: Indicates the mapped value based on the Mapping Type. For example, if the Mapping Type is Excel to SAP, then the mapped value is the Excel column from where we received the data.
    • (Only for GUI Script and Transaction) Dynamic Skip: Changes the skip values.
    • Dynamic Formula: Changes the field value dynamically before sending it to SAP.
    • (Only for BAPI/RFM and Data Extractor) Block Type: Indicates how to loop through the Excel data.
    • (Only for BAPI/RFM and Data Extractor) Block Value: Indicates the number of rows that constitute a group of blocks or which column to look for similar values or blank rows. This column is available when you use loops and is tied to mapping performed in the Block Type column. Block Type and Block Values together provide very powerful and natural looping capability.
    • (Only for BAPI/RFM, GUI Script, and Data Extractor) Length: Sets the field length as required by SAP.
    • (Only for BAPI/RFM and Data Extractor) Type: Displays the field type as defined in SAP.
    • (Only for GUI Script) GUI Script: Displays the GUI Script that is being used.
    • (Only for Data Extractor) Convert to Text: Indicates that the SAP-returned value is converted to text and is then displayed in Excel, thereby resulting in no loss of data. For example, if you are trying to extract an 18-digit number from an SAP table and you do not select Convert to Text, then the number is incorrectly rounded off.
    • (Only for Data Extractor) Optional: Displays whether a field is optional or mandatory. All the mandatory fields must have mapping assigned to it or Process Runner displays a validation error when you run the file.
  2. Optionally, you can apply the following filters:
    • Option-wise: Click the filter icon that is visible only when you hover over the header field and select the option from the displayed list to filter the mapper grid data.
    • Custom-filter: Enter the text in the field, which is in the row after the header row, that must be used to filter the mapper grid data.

    Note: Users can drag over the rows to select the multiple rows simultaneously.

  3. To view the selected Excel file in the Mapper grid, select Excel View > Show/Hide Excel Data. The Excel data is useful during the debug run.
  4. To view the Excel toolbar, select Excel View > Show/Hide Excel Toolbar. The Excel toolbar has various options, such as source and sheet name.
  5. To view only active rows on the Mapper grid, select Active Rows.
  6. To view only inactive rows on the Mapper grid, select Inactive Rows.
  7. To view both active and inactive rows on the Mapper grid, select All Rows.