Get row index by value (GUI Table control)

User action Get Row by Value can be used in SAP GUI protocol fro SAP Grid view and Table control. In this article, we will take a look at the GUITableControl example.

Usecase

We have many rows in a table and we want to select/store a specific cell based on a value found on a given column.

Solution

In this example, we will need to Store value from the cell based on the value in the column.

Step 1. Record 2 Store actions

• Record the first Store on a grid/table level

• Record the second Store on the cell, where you want to get the value from

Step 2. Configure the first Store steps

• Change the Action Type to “Get row index by value“

• Enable “Export data as variable” switch and save the variable with the new name (you will reuse it in the second Store step in the Object properties).

• Go to the Dat Set and define the value for the reference of the target row

Step 3. Configure the second Store step

• Go to the object properties of the second Store step and take a look at the ID of the cell. The last 2 digits are representing the Row and Column index (starts from 0)

Example of the original ID : /app/con[0]/ses[0]/wnd[0]/usr/………/txtRV45A-KWMENG[2,5]

• Replace the Column index with the variable from the first Store step:

Example of the configured ID : /app/con[0]/ses[0]/wnd[0]/usr/………/txtRV45A-KWMENG[2,${RowIndex}]