Master Data Value Lookups

GLSU allows you to look up certain master data elements inside the spreadsheet. This functionality works similarly to the way search-helps work inside SAP. To see the lists of master data values.

1. Put your Excel cursor on a field.
2. Press F4 (or your pick list hotkey as set up in the Options > General tab.)
3. Select the appropriate master data value.

   

Any of the columns in the Choose a value dialog box may be sorted by clicking on the column header. Subsequent clicks on the header row will sort the fields in ascending or descending order.

Note: If you choose a field that you do not have configured for pick values, then the Choose a value dialog will not appear.

For all date fields, a calendar will be displayed to choose an appropriate date. GLSU handles date formatting differences between Excel and SAP, as long as Excel recognizes the cell as a date.

Pick values are available for many CO-PA fields (these are fields which start with "RKE"); however, descriptions and validations are not available for these fields.

Another way to look up the SAP master data values is by using the F4 key on your keyboard. Since many of our customers already use the F4 key for other functionality, the Options menu allows end- users to change the default F4 key to some other unused function key. See below.

1. Select the Options menu item from the spreadsheet.
2. Select the General tab.

   

3. Find the Select a Hotkey for GLSU Pick List Activation section.
4. Select a new pick list function key from the pull-down list.
5. Check the ALT box if you want to enable, for example, ALT-F4 as your pick list hotkey.

Note: The right-click Pick from drop-down list… functionality has been replaced by the enhanced pick-list Hotkey option.