Skip to main content

Mapper tab of Process Runner DB

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 DS tables or to dynamically generated system values.

You can loop fields to instruct Process Runner DB about how to store data in DS 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

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 the following:

For information about how to configure the test run settings, see Test Run Settings. For information about how to stop a Process file run, see Stop.

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
  1. Open a process file.
  2. Go to the Mapper ribbon tab and select a field that is to be copied, moved, deleted or cloned.
  3. Select the appropriate button stationed at clipboard group of Mapper tab.

Note: The Clipboard section is not displayed 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.

  • 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 DS or DS to SAP, select None. This option is available for all the technologies.
    • To transfer data from DS to SAP, which means that the changes made in Database are uploaded to SAP, select DS to SAP. This option is applicable only for Transaction, GUI Scripting, and RFM/BAPI technologies.
    • To transfer data from SAP to DS, which means that the data from SAP is written to Database, select SAP to DS. This option is applicable only for Transaction, Data Extractor, and RFM/BAPI technologies.
  • In Other Section, you have the following options:

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,

  1. Open the Process file that you want to update and go to the Mapper tab.
  2. 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 DB 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 Dialogue.

    • 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.

      • Note: SAP uses the Open File pop-up window of Windows operating system in some cases for opening a file. This pop-up might get skipped while recording. Therefore, Insert "Open" File Window 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 SAP to Database Report Export.

  3. Select OK. The details are reflected in the Mapper grid.

Update Field Information

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,

  1. Open the Process file that you want to update and go to the Mapper tab.
  2. Select Other Action > Update Field Information. The Update field Information from SAP window appears.

  3. 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 DB.
    • Skip output (read) only fields: Skip the read-only output fields.
  4. 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
  5. Select Continue. The Connector for SAP window appears.
  6. 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 Restore Recording.

The Restore Recording option is available for all the technologies.

  1. Go to Mapper ribbon tab.
  2. Select Other Actions > Restore to original recording from drop-down menu.
  3. Confirm the restoration by selecting Yes at warning prompt.

Show

The Mapper tab of Process Runner DB consist of a Master Grid that represents characteristics and parameters of recording. This Master grid is partitioned for two types of view -  Simple View and Advanced View. The Master Grid at each technology varies and so does the view differ.

This section contains the following topics:

Simple View

This topic describes the Simple View of each technology in Process Runner DB.

To view the Mapper grid in Simple View,

  1. In Process Runner DB, open the Process File and select Mapper > Simple View. The simple view of the Mapper grid is displayed.

    • Transaction technology

    • BAPI/RFM technology

    • GUI Script technology

    • 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:
      • DS to SAP: Places the value received from DS to SAP.
      • SAP to DS: Places the value received from SAP to given DS.
      • 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.
    • Map Value: Indicates the mapped value based on the Mapping Type. For example, if the Mapping Type is DS to SAP, then the mapped value is the DS 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.
  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: You can drag over the rows to select the multiple rows simultaneously.

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

Advanced View

This topic describes the Advanced View of each technology in Process Runner DB .

To view the Mapper grid in Advanced View,

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

    • Transaction technology

    • BAPI/RFM technology

    • GUI Scripting technology

    • 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 DS:  Places value received from DS to SAP.
      • SAP to DS:  Places value received from SAP to given DS.
      • Fix Single Value:  Uses the value provided in the Map Value column.
      • System Value: Uses dynamically calculated value as provided in Map Value column.
    • Map Value: Indicates the mapped value based on the Mapping Type. For example, if the Mapping Type is DS to SAP, then the mapped value is the DS 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 DS 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 DS table, 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 DB 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 Database file in the Mapper grid, select Database View > Show/Hide Database Data. The data is useful during the debug run.
  4. To view the Database toolbar, select Database View > Show/Hide Database Toolbar. The Database 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.

Tab View for BAPI/RFM

This topic describes how to view the tabular view of BAPI/RFM technology in Process Runner DB.

The Mapper tab of Process Runner DB 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 Tables to SAP
  • Download Tables from SAP

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

To view the Mapper grid in Tab View,

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

    bapitabview

Was this article helpful?

We're sorry to hear that.