Expert Excel Controls

This topic describes the how to configure the expert Excel controls.

Note: To leave a single data field unchanged, you can use Suppress field on Zero, Suppress field on Blank, or Suppress field on Blank or Zero. Instead of the entire row if we want to suppress only selected fields, we can use dynamic skip type Suppress Field on Blank or Zero or Space(s). For information about how to keep a particular data field unchanged, see F-Suppress Field on Blank or Zero. To suppress multiple fields or when you do not want to send the values for those fields during the Process file run, you can use the feature Disable mapped fields if mapped value in Excel as explained in this procedure.

To configure the options in Expert tab

  1. In Process Runner, open the Process file that you want to update.
  2. Go to the Edit tab and click the pop-up icon. The Basic tab > Excel Controls window is displayed.
  3. Select Expert and select the following options:
    • To suppress the fields where a particular symbol, such as back slash (/) is encountered in the Excel data during the run, select Disable mapped field if mapped value in excel cell is and enter the symbol in the box. This option is applicable to all the fields where (/) is present in the Excel data.
    • To suppresses if the fields are blank during the run, select Disable mapped field if mapped value in excel cell is blank.
    • To clear all the data from external Excel file before running any Process file, select Clear data from Excel Sheet before each Run and select to either delete all the data from Excel or delete only SAP to Excel Columns; enter the value for the columns.
    • (Only for Transaction) To enable Process Runner to consider the Excel cell values, select Vertical Transaction Repeater (VTR).
    • (Only for Transaction) To determine how the downloaded file must be treated, select an option in the Downloaded File post processing dropdown list.
    • (Only for BAPI/RFM) To determine the cell delimiter, select the option from In Cell-Delimiter dropdown list.
  4. Select OK. The changes are saved.