Create references in data worksheet columns

Button Create references in data sheet columns

After creating the script itself on the EI_Script_XX worksheet, the references to data sheet (usually EI_Data) should be created for each row where column “L” has a value.  This is an automatic task, that performs three actions:

• To the data sheet row the technical information about data fields is copied (row 1-3 of the data sheet). This allows later use of F4 search help on data sheet and pre-check of data correctness.
• In the row 7 of the data sheet, description of the column is copied .
• Optional: For the data sheet columns, for which the user has given the possible value list in the 4th row of the data worksheet or for the data sheet columns that are referenced in the script with a field that has fixed domain values (e.g fixed  H/S values for Debit/Credit) standard Excel value help can be created. It facilitates data input.
  The selection field determines the task performed regarding Excel value field generation:
• U – creates Excel value help only for user data lists (from row 4th of the data sheet)
• C – creates Excel value help for user data lists and for fixed ABAP domains
• D – deletes all Excel value help

To create references one shoud click the „Create references in data sheet columns” button on the ribbon.

Usually one does not want to change values on the pop-up window with parameters of references creation.

If separate Result Sheet is used for data return, instead of Data Sheet, then descriptions are put in first row of the Result Sheet.