EI_Data – EasyInput data worksheet (this is the default name that can be changed while configuring the script)
EasyInput data worksheet elements (by default EI_Data)
Product EasyInput uses ribbon menu. This ribbon is used to perform the product tasks and the most frequently changed settings.
Important! EasyInput ribbon menu is worksheet-relevant. When the script worksheet is selected by the user, then the script relevant buttons will be presented.
Rows 1-4 of the data worksheet are reserved for steering data. Steering data are used for example by the F4 search help functionality. See description of creating references between script and data worksheet.
|
Steering row |
Description |
|
1 – Table-field info |
Table-Field string describing table and table field. The 1st row is crucial for the F4 help to work for a column. Usually the value in this row is copied from the script. Some transactions however, have their screen field meaning set only in runtime. For such transaction it can be necessary to fill the data manually based on the F1 help in SAP GUI and technical info. Important: In difficult cases, when no table-field pair gives the F4 functionality, one can put Table-Field-SearchKey where searchkey is the ID of the searchkey with required F4 functionality.
Important! For OData services, this string can contain additional three values for searching through OData services, e.g.: ---OD_SAP_V2-Kostl- &cprotocol&://&chost&:&cport&/sap/opu/odata/sap/FCOM_COSTCENTER_SRV/F4_CostCenterSet/?$format=json These values describe: OData service version, the column containing the searched value, OData query returning data table. |
|
2 – Data Type-Length info |
Describes data type and length of the field. This data is informational. |
|
3 – Length String |
String containing so many characters (digits) as the length of the field assigned to the column. Thanks to this string the user can simply adjust column with to the length of the data (especially important for the descriptions strings) |
|
4 – Optional fixed value string |
An optional string containing list (separated by “;” ) of values that should be allowed in the column. E.g. “1000;2000;3000;/”. When the user introduces such a string and then calls the function Create references in data sheet columns (on Script worksheet) from the script sheet in the ribbon, the standard Excel value help for the column will be created. Additionally the string is used in Data pre-check ribbon function. Special string “&R&” put into this field defines this column as required (cannot be empty). |
Rows 6 and 9 from AA column upwards can be edited manually, so that the data column descriptions were comprehensible for the user. The texts in the 9th row (as well as the steering data in rows 1-3) can be generated automatically based on the script (with the use of Create References in Data Sheet columns function accessible via the EasyInput ribbon – see the Script creation) .
The columns A-G of the data worksheet are reserved columns for the transaction processing messages. The columns B,C,D describe the test run results. The columns E,F,G describe the actual run results. This area can be cleared manually by selecting it and choosing Clear contents form the context menu.
The Y column of the data worksheet is reserved for data level. For simple transaction this field can be left empty. For transaction consisting of data at various levels (e.g. header level=0 and line item level=1), one should enter data level in this field starting with 0. This allows the programs to distinguish between header lines and line item lines (that can be more than one for a transaction).
Important! Levels allow a loop over a script section. If within a script there are lines describing only one line item in the document, and when they are assigned level 1, and there are more than one data lines on data sheet assigned to level 1 as well, then the script part will be repeated for each data line.
If a transaction has different data on the same level (e.g. line item level and delivery item level), than they can be distinguished by a string in the Z column (order). Filling this order field is optional. Order can be any string distinguishing data on the same level (e.g. A and B).
Important! If data on a sublevel/ order is optional one can put string “_O” at the end of order string (e.g. “A_O” or just “_O”). Alternatively one can set the default on the configuration worksheet.
Important! If data on a sublevel/ order is required one can put string “_R” at the end of order string (e.g. “A_R” or just “_R”). Alternatively one can set the default on the configuration worksheet.
From the 10th row and from the column AA start transaction data, that can be entered by the user. When the cursor is in this area pressing F4 should call SAP search help window (if in 1st row the technical table-field info is maintained).