Mapper Tab

The section describes the Mapper tab that provides a graphical representation for elements of corresponding Transaction or BAPI interface. It allows you to map SAP fields to Excel columns and cells or to dynamically generated system values.

You can loop fields to instruct Process Runner about how to store data in Excel and how to upload them to SAP.

Mapper is designed to ensure that you can focus on the important fields through features, such as dynamic search and filtering of row. The Mapper tab allows you to select multiple rows and assign mapping values to all the selected rows. This functionality can reduce the time taken to map large file, especially for BAPI. Mapper layout is different for Transaction, BAPI/RFM, and for GUI Scripting.

You can use the drag-and-drop functionality in the Mapper tab for quick mapping of data. Refer to the video to understand the drag-and-drop functionality.

This section contains the following topics:

Run Actions
Clipboard
Edit
Show

Run Actions

This topic describes how to use the options in the Mapper > Run Actions section to run the file. Some of the run options are available only for some of the technologies.

For information about the different run options, see Run Actions.

Clipboard

This topic describes how to use the options in the Mapper > Clipboard section to perform the following tasks:

Cut, copy, and paste the field
Delete the field
Clone the field

Note: The Clipboard section is not available for Data Extractor and BAPI/RFM technologies.

Edit

This section explains how to use the options in the Mapper > Edit section to perform tasks, such as selecting all the rows in the grid, updating the mapping type simultaneously for several rows, undoing and redoing the operations performed in Mapper.

To undo an action performed in Mapper, press Ctrl+Z on the keyboard or select Undo.
To redo what you have undone in Mapper, press Ctrl+Y on the keyboard or select Redo on the Mapper toolbar. You can undo changes, even after you have saved, and then save again, if you are within the undo limit that is 20.
In Row(s) Action, you can perform the following tasks:
- To select all the rows that are displayed in the master grid, select Select All Rows. This option is available for all the technologies.
- To activate all the selected rows in the master grid, select Activate Row(s) and to deactivate all the selected rows in the master grid, select Deactivate Row(s) . This option is available only for Transaction, Data Extractor, and GUI Scripting technologies.
In Fast Map, you can perform the following tasks:
- To not transfer data from SAP to Excel or Excel to SAP, select None. This option is available for all the technologies.
- To transfer data from Excel to SAP, which means that the changes made in Excel are uploaded to SAP, select Excel to SAP. This option is applicable only for Transaction, GUI Scripting, and RFM/BAPI technologies.
- To transfer data from SAP to Excel, which means that the data from SAP is written to Excel, select SAP to Excel. This option is applicable only for Transaction, Data Extractor, and RFM/BAPI technologies.
In Other Section, you have the following options:

Auto Map

This topic describes how to use the Auto Map options for Transaction technology.

To use the auto map options,

Open the Transaction Process file that you want to update and go the Mapper tab.
Select Other Action > Auto Map and one of the following options:
- Automap all check mark ("X") to Excel: Updates the mapping type of all the rows whose Mapping Type is Fix Single Value and the mapping value is X to Excel to SAP simultaneously.
- Automap download of all input fields Creates a copy of all the recorded input field rows whose mapping type is SAP to Excel and updates the mapping type to Excel to SAP in the copied fields.

Insert Advanced Row

This topic describes how to configure the Insert Advanced Row options for Transaction and GUI Scripting Process files.

To configure the advanced row options,

Open the Process file that you want to update and go to the Mapper tab.
Select Other Action > Insert Advanced Row and one of the following options:
- Insert "Save" File Window Row: Allows you to configure the following options in the Save-File Path and Name Settings window:
  - Field Description: Indicates the field description that is displayed in the Mapper grid.
  - Save File Option: Indicates whether the existing file must be overwritten or a new file must be created.
  - Map Type: Indicates the mapping type.
  - Map Value: Indicates the map value.
  - Suppress Excel message when saving file: Indicates that Process Runner must handle the Excel message internally.
  Note: SAP uses the Save File pop-up window of Windows operating system in some cases for saving a file. This pop-up might get skipped while recording. Therefore, Insert "Save" File Window Row is used to handle such pop-ups. For an example about when to use the Insert "Save" File Window Row option, see Handle Windows File Dialog.
- Insert "Open" File Window Row: Allows you to configure the following options in the Upload File Path and Name Settings window:
  - Field Description: Indicates the field description that is displayed in the Mapper grid.
  - Map Type: Indicates the mapping type.
  - Map Value: Indicates the map value.
- Insert "Browse for folder" Row: Allows you to configure the following options in the Browse For Folder Settings window:
  - Field Description: Indicates the field description that is displayed in the Mapper grid.
  - Map Type: Indicates the mapping type.
  - Map Value: Indicates the map value.
  Note: SAP uses the Browse File pop-up window of Windows operating system in some cases while browsing for a file. This pop-up might get skipped while recording. Therefore, Insert "Browse for folder" Row is used to handle such pop-ups.
- Insert Excel Report Row: Allows you to configure the following options in the Excel File Path and Name Settings window:
  - Field Description: Indicates the field description that is displayed in the Mapper grid.
  - Save File Option: Indicates whether the existing file must be overwritten or a new file must be created.
  - Map Type: Indicates the mapping type.
  - Map Value: Indicates the map value.
  Note: SAP displays the Excel Report in its own grid. Users might have to download such files externally. Therefore, you can edit the recording and insert a row to download the Excel report in addition to adding such a row through the recording. For information about how to insert such a row automatically, see Export Report from SAP to Excel.
- Insert "Set SPA/GPA Parameters" Rows(Available only for Transaction): Inserts a row at the top of the mapper grid to set the parameters manually from the mapper. Process Runner users can edit a recording to change the parameters of user preferences that are usually loaded at the initiation of the recording.
Select OK. The details are reflected in the Mapper grid.

Handle Windows File Dialog

This topic describes how to use the Insert "Save" File Window Row. Process Runner handles the Windows native dialog with a Windows API function called #FILE_DIALOGUE#. When you complete the recording of a transaction, Process Runner automatically inserts #FILE_DIALOGUE# in the Field column in the Mapper grid when it finds the Windows file dialog.

When recording a transaction, SAP may open file a dialog that cannot be recorded in the normal recording process or even in SHDB, LSMW, or ABAP programs. You may see a dialog when you try to download the file or upload the file or an attachment.

To insert #FILE_DIALOGUE# in the Mapper tab,

Open the Process file and in the Mapper tab, select the position where you want to insert #FILE_DIALOGUE#, right-click, and select Insert "Save" File Window Row. The #FILE_WINDOW# field is inserted.
Map this field and run the file. Process Runner automatically passes the value according to the mapping to the Windows file dialog as displayed in the first page.
Normally, MM06 exports the report to the specified location. For example, let us consider C:\Innowera\ as the specified location that contains the report Test.xml.

If a file already exists with the same name, an error message is displayed and the recording does not work.

To work around this scenario, the following parameters can be passed to #FILE_WINDOW#,
- #FILE_WINDOW#,1can be used to overwrite the existing file. For example, let us overwrite the existing report for material 100-100 with that of 100-200.
  
  The original file is replaced when you run the file. 100-200 is listed instead of 100-100.
- #FILE_WINDOW#,2 can be used to rename the existing file and then write a new file.

Add Fields

This topic describes how to use the Add Fields option to add a field or screen after the recording is completed. The Add Fields option is available only for Transaction and Data Extractor technologies.

To add a field,

Open the Process file that you want to update and go the Mapper tab.
Select Other Action > Add Fields. The Add/Activate More Fields window is displayed with the name and description about the inactive fields.
Select Show Advanced View. The screen name and mapping type are also appear.
Select the field that you want to add, update the mapping type in Map Type column, enter the map value in Map Value column, and select Active. The field is added, activated, and displayed in the Mapper grid.
Note: You can also select the map value from the dropdown options, which are the Excel column headers.
Select Close. The Add/Activate More Fields window is closed.

Update Field Info

This topic describes how to configure the options in the Update Field Information from SAP window to update the screen descriptions, data type, and length of the fields in case they were not extracted during the recording.

The Update Field Info option is available for Transaction, Data Extractor, and BAPI/RFM technologies.

To configure the options in the Update Field Information from SAP window,

Open the Process file that you want to update and go to the Mapper tab.
Select Other Action > Update Field Info. The Update field Information from SAP window appears.
To get the field descriptions, select Get field descriptions and the following options:
- Skip deactivated fields: Skips the fields that are deactivated from Process Runner.
- Skip output (read) only fields: Skip the read-only output fields.
To get the field length, select Get field length and the following option:
- Overwrite if field length is already maintained in mapper:. Overwrites the data of the field if the field length is already maintained in the Mapper
To add or delete fields and synchronize the fields, select Add/Delete field(s) and the following options
- Add new field(s) in mapper if found in SAP system: Adds the new fields.
- Delete existing field(s) in mapper if not found in the SAP System: Deletes the existing field(s) if they are not found in the specific SAP system.
Select Continue. The Connector for SAP window appears.
Enter the SAP logon credentials. The descriptions are refreshed and updated in the SAP logon language that is selected in the SAP Logon at <NameOfSAPSystem> window.

Restore to Original Recording

This topic describes how to use the Restore Recording option to restore the recording to its original settings. If you perform an operation that cannot be reversed and want to revert to the original recording,

Select Other Action > Restore Recording.
Select Yes to restore original recording.

The Restore Recording option is available for all the technologies.

Show

This section contains the following topics:

Simple View of Mapper Grid
Advanced View
Tab View for BAPI/RFM
Test F4 Lookup

Simple View of Mapper Grid

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

To view the Mapper grid in Simple View,

In Process Runner, open the Process File and select Mapper > Simple View. The simple view of the Mapper grid appears.

Simple View of Transaction technology
Simple View of BAPI/RFM technology
Simple View of GUI Script technology
Simple View of Data Extractor technology

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

(Only for Transaction and GUI Scripting ) 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 Scripting) Looping: Displays SAP screen name.
(Only for Transaction, BAPI/RFM, and Data Extractor ) Field: Displays SAP field name.
Field Description: Displays the description of the field.
Mapping Type: Displays the Mapping type for the row. Following are the mapping types:
- Excel to SAP: Places the value received from Excel column to SAP.
- SAP to Excel: Places the value received from SAP to given Excel column.
- Fix Single Value: Uses the value provided in the Map Value column.
- System Value: Uses the dynamically calculated value as provided in Map Value column.
- Excel Cell Value: Places the 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 Transaction and GUI Scripting) Dynamic Formula: Changes the field value dynamically before sending it to SAP.
(Only for GUI Scripting) Dynamic Skip: Changes the skip values.
(Only for GUI Scripting) Length: Sets the field length as required by SAP.

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: You can drag over the rows to select the multiple rows simultaneously.
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.
To view the Excel toolbar, select Excel View > Show/Hide Excel Toolbar. The Excel toolbar has options, such as source and sheet name.
To view only active rows in the Mapper grid, select Active Rows.
To view only inactive rows in the Mapper grid, select Inactive Rows.
To view both active and inactive rows in the Mapper grid, select All Rows.

Advanced View

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

To view the Mapper grid in Advanced View,

In Process Runner, open a Process File and select Mapper > Simple View. The advanced view of the Mapper grid appears.
- Advanced View of Transaction technology
- Advanced View of BAPI/RFM technology
- Advanced View of GUI Scripting technology
- Screenshot: Data Extractor technology

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.

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.
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.
To view the Excel toolbar, select Excel View > Show/Hide Excel Toolbar. The Excel toolbar has various options, such as source and sheet name.
To view only active rows on the Mapper grid, select Active Rows.
To view only inactive rows on the Mapper grid, select Inactive Rows.
To view both active and inactive rows on the Mapper grid, select All Rows.

Tab View for BAPI/RFM

This topic describes how to view the tabular view of BAPI/RFM technology in Process Runner. The Mapper tab of Process Runner consists of a Mapper grid that represents the characteristics and parameters of recording. The Mapper grid of BAPI/RFM Process files can be viewed in tabular form besides the Simple View and Advanced View.

The Mapper grid at the Mapper tab of BAPI/RFM Process file consist of three sections:

Upload to SAP
Download from SAP
Upload/Download from SAP

Due to these three sections, the GUI Script is availed with a feature to view the Mapper grid in tabular form also.

To view the Mapper grid in Tab View,

In Process Runner, open a BAPI/RFM Process file and select Show >Tab View.

Test F4 Lookup

Once the configurations are concluded, select Test F4 Lookup which will display a screen similar to SAP GUI.

Note: To utilize the Test F4 Lookup button, you will have to select the row in which the F4 Help Configuration is made successfully. Selecting other row/field displays an error message.

Note: See Configure F4 Help Lookup to know the configuration settings.

Following are the generic steps to search F4 Help:

Go to the required collective search help tab.
Enter the values in the given fields according to which the search is to be filtered.
Select Start Search.

The following options explain the influence of various options:
- Show/Hide Operators: Click this option to set the filters accordingly.
- Display Offline: Click this option to view the recent search records.
- Use Logon Shortcut: Check-mark this option and select the logon shortcut if created any.
- Maximum no. of records: Enter the number of records that is to be displayed.
- Show in SAP GUI: Selecting this option displays the records in actual SAP screen.
- Start Search: Click on this button to initiate the search of records.
- Close: Click here to close the window.
Corresponding records appear as shown below.

Auto Help Generator

User can directly also auto generate F4 Help configuration using the Auto Help Generator option from drop-down menu of Test F4 Lookup ribbon menu. Herein, user can only generate F4 Help configuration for All Active/Inactive Fields.

Refer to the table given below to understand the influence of various options.

Module	Option	Description/Sub Option
Generate F4 Help Configuration for All Fields	Select this option to instruct the Process Runner to automatically generate F4 Help for all the fields
	For All Active Fields	Implementing this option will instruct Process Runner to automatically generate F4 Help for all the active fields
	For All Inactive Fields	Implementing this option will instruct Process Runner to automatically generate F4 Help for all the Inactive fields

F4 Lookup Options