Apply Dynamic Skip in Process Runner DB

Dynamic Skips or DS allows you to skip elements of the recording at run time based on criteria you specify. Frequently used criteria are already provided. You can also define your own skip criteria using Custom DS. Custom DS is written in VB.NET and similar to Macro that you write inside Excel/Word.

Dynamic Skips can be placed on a field or on a screen element.

If you have both Dynamic Skip (DS) and Dynamic Formula (DF) on the same field, then DF will manipulate the field prior to implementing DS.

• DS on Field

  

• DS on Screen

  

• How to See Dynamic Skip Control

  • Select Advance button in Mapper toolbar. An extra column for DS appears.

  

This section contains the following topics:

• Dynamic Skip on Field
• Dynamic Skip on Screen

Dynamic Skip on Field

The dynamic skip on field options are as follows:

• C-Skip on Blank or Zero
• F-Suppress Field on Blank or Zero
• H-Find Value or Suppress Field
• Z-Custom DS on Field

To know more about Data Governance Rule and how does this work, refer to Data Governance.

C-Skip on Blank or Zero

You can perform Skip Row on Zero, Skip Row on Blank or Skip Row on Blank or Zero. Refer to the following example of Skip Row on Blank or Zero.

To skip the row in which amount is either zero or blank,

1. Go to Mapper, and in the Dynamic Skip column for the Amount field, select C-Skip Row on Blank or Zero.

   

   

2. Select Run.
3. After a successful run, you can see the log column displaying Row Skipped due to DS.

   

F-Suppress Field on Blank or Zero

You can perform Suppress field on Zero, Suppress field on Blank or Suppress field on Blank or Zero. Refer to the following example of Suppress field on Blank or Zero.

Use this DS type instead of entire row if only selected fields should be suppressed.

Suppress only if the amount field is either zero or blank.

For amount field in Mapper, select Suppress field on Blank or Zero in Dynamic Skip column from the drop down.

To suppress the amount field

1. Go to Mapper tab.
2. Switch to Advanced View.
3. Select Suppress Field on Blank or Zero or Space(s) option from the drop down menu in Dynamic skip column for amount field.

   

   

4. Select Run in the toolbar.
5. On a successful run, you can see the log column displaying Material is changed.

   

That is because only the Gross Weight and Net wight, not the others.

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 DB, 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 DB and open GUI Script file in which this dynamic skip is to be configured.
2. Go to Mapper tab and select 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 Settings dialog and select OK. Refer to the table mentioned below to understand the influence of each settings parameter at Find Value Settings dialog.

   

   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 insightsoftware 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. The Change Info Record, which is the Initial Screen in SAP appears.
  2. Enter the relevant fields for Vendor, Material, Purchasing Org and Plant.

  3. 

     Select Enter. The detailed screen for Change info Records – General data appears.
  4. Select Conditions and select a valid date.

     

  5. Select Choose. The Change Gross Price Condition (PB00): Condition Supplements screen appears.
  6. 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.

  1. Enter the SAP T-Code IA06. The Change General Task List: which is the initial screen, appears.
  2. Enter the relevant fields for Group.

     

  3. Select Task list. The detailed screen for Change General Task List: Task list Overview appears.

     

  4. Select Select all option and then select Operation. The detailed screen of operations appears.

     

Z-Custom DS on Field

The above dynamic skips mentioned in previous chapter were the built in DS types provided in Mapper. To check the values “on the Fly” during run-time and perform some action based on that, you can use Custom DS.

Select Custom Dynamic Skip from the drop-down for amount field.

Custom DS screen will pop-up. This is a small IDE, where users can write their VB.Net code to perform various Run-Time actions based on the data they put in their excel data sheet.

Besides the inbuilt DS types, custom DS also supports various options.

Let us understand the pre-defined variables and return types that can be used in Custom DS on field with VB.Net code.

Example:

If Trim(iTable(iCurrentDatabaseRecordNumber,"i").Text) = "31"

Return 0

else

Return 1

End If

The above code tells Process runner if there is 31 in column I for the current row in current sheet then only execute (Return 0) the row else suppress (Return 1) it.

Here we will see a small example that if we encounter $ in amount field it should stop the transaction.

iValue contains the field value for which we have defined Custom DS.

It’s “amount” here.

Following is the VB.Net code.

If iValue.ToString() = “$” then

Return 4

End If

Returning 4 will stop the transaction there itself.

To test your code, enter $ in iValue & select the Test button.

It will display Result: 4 (the return value).

Look at the description below it.

** If there is any Syntax error in your code it will also notify about that.

Select the OK button. Run it.

Dynamic Skip on Screen

The dynamic skip on screen options are as follows:

• A-Execute only on the first call
• B-Suppress Screen with Previous
• C-Invert Screen with Previous
• Y-Data Governance Rule
• Z-Custom Dynamic Skip (DS)

Note: Dynamic Skips A,B,C and D do not require any map value. They are either exclusive to a screen (like A) or dependent on the preceding screen (B and C).

A-Execute only on the first call

This is similar to Suppress Screen with previous but the only difference is it will do it only on the first call. Consider the example that we just referred for Suppress Screen with previous. If we replace Suppress Screen with previous with Execute only on the first call, then it will post only the first document and not the others (refer the second screen).

Custom Dynamic Skip (DS)

Like Custom DS for fields we have Custom DS for screens too.

Refer the MM02 - Change Material transaction screen below. Business requirement is that If user adds/deletes any column then this transaction should not run. See how we can implement this using Custom Dynamic Skip.

To achieve this, we will add a custom dynamic skip in the first screen.

Have a look at the DS criteria. It will check if value is not equal to “100-110” for material number, then it will Return 3 which is for skipping call to SAP . If the material number is found then Return 0 will tell Process Runner DB to send the row to SAP and not suppress it.

Select Run. The message Call to SAP skipped due to Custom DS is displayed.

This is just a simplified example to clear the concept. Custom DS concept can be extended to many other scenarios.