Column

Field

Field description

A

Script ID

Assigns script row to a given script ID (script ID is defined on EI_ScriptName worksheet)

B

Run type

Defines whether the script row is used for:

A – actual run

T – test run

C – both test and actual run

Most of the script rows usually is the same for actual and test run, so that they are signed with C.  The rows, that are different for actual and test runs will be assigned A or T letter.

C

Level

Optional. Described in part Working with EasyInput. Level allows copying of a given part of the script for a given data line (e.g. document line item). For simple scripts (without sublevels) the level value may stay empty. For more complicated scripts this should be filled with values starting from 0. The first transaction data line should always have 0 value (may be left empty for simple scripts). 

D

Order

Optional. Described in part Working with EasyInput. Order allows diferentiation between data on the same level.

E

Inactive

Optional. Can be left empty or filled with „X” value. When set to value „X”, then the relevant script row is omitted.

F-J for

SAP GUI

Script

Script object, Script function, Field name, Field value

Standard script data recorded with SAP GUI script recorder (can be initiated directly from EasyInput).

The recording is usually extended by specifying the transfer fields (see description below for columns L/M)

In the column “Field value” either constant or Excel formula can be put instead of transfer defined by columns L/M.

Important! In order to delete entirely a script row or change a cell formatting, one has to unprotect the worksheet for changes (ribbon menu Review > Unprotect Sheet).

Important! In order to place a formula in Field Value column, one has to change this cell formating to General (righr mouse-click Context menu > Format Cells > General)

F-J for Transaction

Script

Program, Screen, Start ID, Field name, Field value

Standard transaction script recorded in the SAP system. The script can be recorded with the SHDB transaction, and than either copied manually (Ctrl+Y > Ctrl + C > Ctrl + V) or saved as file and uploaded from file.

The recording is usually extended by specifying the transfer fields (see description below for columns L/M)

In the column “Field value” either constant or Excel formula can be put instead of transfer defined by columns L/M.

Important! In order to delete entirely a script row or change a cell formatting, one has to unprotect the worksheet for changes (ribbon menu Review > Unprotect Sheet).

Important! In order to place a formula in Field Value column, one has to change this cell formating to General (righr mouse-click Context menu > Format Cells > General)

F-J for

BAPI/ Function

Script

Program, Screen, Start ID, Field name, Field value

Standard script data generated automatically by EasyInput, after the user inputs the SAP function module ID (after pressing the button Add an RFC-enabled function module)

The recording is usually extended by specifying the transfer fields (see description below for columns L/M)

In the column “Field value” either constant or Excel formula can be put instead of transfer defined by columns L/M.

Important! In order to delete entirely a script row or change a cell formatting, one has to unprotect the worksheet for changes (ribbon menu Review > Unprotect Sheet).

Important! In order to place a formula in Field Value column, one has to change this cell formating to General (righr mouse-click Context menu > Format Cells > General)

F-J for

OData

Script

Program, Screen, Start ID, Field name, Field value

Standard script data generated automatically by EasyInput, after the user inputs the OData service parameters (after pressing the button Add an OData service)

The recording is usually extended by specifying the transfer fields and adding && parameter in column G (see description below for columns L/M). In the column “Field value” (J) either constant or Excel formula can be put instead of transfer defined by columns L/M. In the runtime parameter && will be replaced by value defined in columns J/L/M.

Important! In order to delete entirely a script row or change a cell formatting, one has to unprotect the worksheet for changes (ribbon menu Review > Unprotect Sheet).

Important! In order to place a formula in Field Value column, one has to change this cell formating to General (righr mouse-click Context menu > Format Cells > General)

K

Field description

Informational field. Filled when Create description button pressed. Simplifies recognition of technical field names. 

L

Transfer Type

Optional. Can be left empty or filled with values WriteData or ReadData (and WriteReadData/ AssignDarta).

Functions when value is provided:

WriteData –copying data from Data Sheet to the script

ReadData –reading data from SAP and copying to Data Sheet

WriteReadData –writing data to the SAP system and then reading data back to Data Sheet (used sometimes in FM scripts)

AssignData – used ralely, usually together with filling the value of column Field value via functions based on parameters from section Line Activity Formulas. Does not pass any value, but assigns the pair level/order to a data column. Used for example in scripts, where no data is passed to the script, to assign the column in which any string initiates the start of the script (e.g. AssignData AA, and value START in column AA10).

Examples with  ACGL_HEAD-BLDAT field:

ACGL_HEAD-BLDAT/empty/WriteData/AF

BDC_CURSOR/ACGL_HEAD-BLDAT/ReadData/AF

Important! Reading possible for SAP GUI Scripts, for transaction scripts only when extended mode is selected in script or configuration, and in export parameters of Function/OData scripts.

M

Read/ write column

Optional. The Data Sheet column from which/ to which data will be copied in runtime. Can be filled with Data Sheet column letters only when Transfer type set (e.g. WriteData or ReadData).

Important! Values in this column can be filled in automatically via use of the ribbon button “Auto-fill read/write columns”.

N

Screen omitting/ Ignore errors

Optional. Can be left empty or filled with „X” value.

Transaction scripts

Value X can be set only in the row when Start ID (column H) has olso value X (screen row). Value X means, that the screen can be missing in the system, and the program should check it, and if the screen is really missing then try with the script without the screen.  Example of use: In FB50 transaction at the beginning the screen with the Company Code input may or may not appear depending on the customization.

SAP GUI Scripts

In SAP GUI scripts this column is used for error handling. Not empty value (e.g. X) means, that the script should continue, even though thwe line may be erroneous. This facilitates handling optional popup windows. If there is an error, then string #ERR# is put into Y (Read value) column.

P-S

Formula reference  column 1-4

Optional. Used only in scripts, where a formula is used to check in runtime whether a script line should be used or not. The fields contain references to Data Sheet (column letters). When the script is generated during runtime, data from given data sheet columns will be copied to the relevant script sheet columns (U-X). This allows script formula in column T and script value in column J to be calculated during runtime (e.g. differently for each data line). 

Special value ROW: When string ROW is put in these columns, then during runtime in respective script sheet column (U-X) are filled with row number of the line currently processed on the data sheet.

Special value FAST: When string FAST is put in these columns, then during runtime neither LOOP INDEX and READ VALUE are updated for this script line. This may increase performance of some scripts. 

Example of values:

AA

AB

..

AZ

ROW
FAST

To learn more about formula use please visit EasyInput forum.

T

False/True formula

Optional. Can be empty or filled with value True or False. In case of it’s value is False the relevant script row will be excluded from the script. Usually not set as fixed value, but as formula referencing data from relevant or preceding script rows, from columns U-Z. On the contrary to column E, the T column is calculated during runtime. Example of such a formula: =$T$96<>$U$96.

U-X

Value 1 -4

Values filled by the EasyInput during script generation, if columns P-S are defined. The values from these fields are used to calculate formula in the T column.

Y

Read value

If in the read/write column, the line is customized as ReadData row, then the value that is read in the script line apart from being put to the data sheet, is copied into this column. It can be than used in the formula in the T column (=$Y$255=”A”).

For SAP GUI scripts value “#ERR#” is also put in this column, when there is an error in the script line.

Z

Loop index

In this column, the consecutive transaction number (for level 0) and loop index (for level > 0) is copied during script execution. This allows to make formulas in column T to have different values e.g. for the first line item in a transaction (=$Z$255=1).