H-Find Value or Suppress Field

Sometimes there is no option available to position cursor on specific data row in table control while mass data upload process through screen output. therefore, the uploading procedure is interrupted. This is because automation of process is not possible through screen input.

In Process Runner, this can be task can be achieved easily through H-Find Value or Suppress Field... option of Dynamic Skip. Implementing this option will help the users to fix the desired position for specific data updating perspective.

Following are the generic steps to configure 'Find Value or Suppress Field' option of Dynamic Skip.

1. Start Process Runner and Open GUI Script file in which this dynamic skip is to be configured.
2. Go to Mapper tab and click on the particular field of Dynamic Skip for which 'H-Find Value or Suppress Field' is to be configured.
3. From the drop-down menu, select H-find Value or Suppress Field option to configure it.
4. Implement the required settings at the Find Value Settingsdialogue box and click OK. Refer to the table mentioned below to understand the influence of each settings parameter at Find Value Settings dialogue box.

Refer to the following image and table to configure Find Value Settings.

Module	Description
What to find	What to find section of 'Find Value Settings' is used to specify a value to be searched whether from SAP Grid or Excel Column. In other words it is also known as peculiar object oriented search. Sub-Option Description Find these value(s) Enter the fixed value to be searched from SAP grid. This value will be fixed for any number of records. By enabling this option you can change the data in any number of records for a particular value in SAP grid. Find value(s) set in this Excel column Enable this radio button and enter the column name from Excel for search value. By enabling this option the search value will not be fixed it will vary from record to record. By entering the column name for find value, you can change/modify the data for any number of records in SAP grid. This option is co- related with Until a first blank value is found in this column in the grid option.
Where to find	Where to find section of Find Value Settings is used to specify the column number of the grid so as to search the desired result. Sub-Option Description Column Number in Grid Enter the column number where to search the value.
How many rows to search for in the grid	This option is used to specify the end point of the search. The following are the two conditions among which user has to select one so as to stop the search through that condition. Sub-Option Description Until a first blank value is found in "Where to Find" column as set above By enabling this option, when a blank value is found in the column number of the searched value, the process will stop executing. Find this value option and until a first blank value is found in “Where to find” column as set above are co - related options. Until a first blank value is found in this column in the grid Enable this radio button and enter the value of the column in the field. By enabling this option when a blank value is encountered in the mentioned column number entered in field, the execution of search process will stop.
Search Options	The search options are used to enhance the search conditions so as to retrieve more specific and quick results. The search options tend to compare the data of external Excel file with SAP grid. Sub-Option Description Continue search from last found row Selecting this radio button will continue the search of the value from the last row found in SAP. Always search from first row Selecting this radio button will always start the value search from the first row of SAP. Data Search Option Sub-Option Description equals Performs the search with the condition that result shall be equal to provided SAP field. begins with Performs the search with the condition that result shall be begin with provided SAP field. ends with Performs the search with the condition that result shall be end with provided SAP field. contains Performs the search with the condition that result shall be consist of provided SAP field.
Advance settings	Sub-Option Description Change row counter as a first row Dynamically change row counter for all subsequent fields of the table if search is successful. Important: Please do not change this unless you understand the ‘Rows Counter’ or instructed by the Magnitude support team. Skip all subsequent fields of the table if search cannot find the value All immediately following subsequent fields in the same table will not be executed if search cannot find the desired value. Suppress SAP Popup Select this check-box to suppress any popup during the search operation.

Examples of this Section

Find this value

Let’s consider script ME12 as an example. In this option we have considered the value as RUE1 which is to be found. Now let’s see from where we will get that value.

1. Enter the SAP T-Code ME12; you will be presented with Change Info Record: which is the Initial Screen in SAP.
2. Enter the relevant fields for Vendor, Material, Purchasing Org and Plant.
3. Press Enter.

4. You will be transferred to detailed screen for Change info Records – General data.
5. Click Conditions and select a valid date.
6. Click Choose.

7. You will be transferred to Change Gross Price Condition (PB00): Condition Supplements screen.
8. Select the value/condition type for which you need to change the amount.

In this case when you mentioned the value as RUE1 in Find this value option then when you run the file with any number of records it will only update the data as per Excel wherever RUE1 value if found.

Find Value Set in this column

Let’s consider script ME12 with 5 records.

Following image represents Mapping configurations in the Mapper:

Now when run the file, all data will be modified as per Excel data file where ever it will find the values mentioned in ‘F’ column of Excel.

Where to find

This option is usually used to specify the location as to where the value is to be searched in the grid. Enter the column address where the search is to be conducted.

Let’s consider the same script ME12 example mentioned above in ‘Find this value’ option.

In that example we have enabled ‘Until a first blank value is found in “Where to Find” column as set above’ because when you run the file, it will search for the value ‘RUE1’ in column number 1 of SAP grid and when a blank value is found in that column in SAP grid; it will stop execution.

How many rows to search for in the grid

Let’s consider script IA06 as an example. Now let’s see from where we have entered the column number in above option ‘Find value set in this Excel column’ screenshot. When a blank value is found in ‘Operation Description’ column in SAP grid; it will stop execution.

How many rows to search for in the grid

1. Enter the SAP T-Code IA06; you will be presented with Change General Task List: which is the Initial Screen.
2. Enter the relevant fields for Group and click Task list.

3. You will be transferred to detailed screen for Change General Task List: Task list Overview screen.
4. Click Select all option and then click Operation.

5. You will be transferred to detailed screen of operations.