GUI Script

GUI Script

Mapping types in GUI script are similar to those of transaction types. These mapping types deal with single line records.

 

GUI_MappingTypes

 

1. DS to SAP: Tells Process Runner DB to get the value from database.

 

2. Fix Single Value: Tells Process Runner DB to use value provided in "Map Value" column

 

3. System Value: Tells Process Runner DB to use dynamically calculated value as provided in "Map Value" column. Eg. In the below capacity planning download we want to assign a specific type of file name for the downloaded file consisting of year,month, day.

 

CM01_Mapper_SystemValue

 

CM01_CapacityPlanning

 

You can see below how the file is created, after assigning system value as a mapping type.

 

CM01_Doc

 

There are mapping types to deal with multi-line (Header detail) documents by using loops. Please expand the below 'GUI Script - Header Detail' section to know more on this.

 

hmtoggle_plus1GUI Script - Header Detail

Following are the various mapping types supported in GUI Script module:

Where you know that number of detail rows is always fix, say 4 rows.

 

GUI_Header_Detail

 

The mapping should be as below.

 

GUI_Mapping_Types_Fix

 

In this type, Process Runner DB automatically determines new transaction when value changes. For example, you have Price Unit repeated for each line in column Field 13, you can use this mapping type and every time there is new price Unit, Process Runner DB will start a new Header-Detail transaction automatically.

 

GUI_On Change_Field

 

The mapping should be as below.

 

GUI_Mapping_Types_OnChange

 

 

Next:

Data Extractor