Multiple SAP Systems

Many SAP users work in an environment where there are multiple productive environments of SAP or development/ testing environments. GLSU gives you the ability to download master data from as many of these environments as required. Each time you download data from a different SAP client, a new and unique file of master data is downloaded to your system. These files must be refreshed individually.

1. Select the Options menu item from the spreadsheet.
2. Choose the appropriate environment from the dropdown box. This listing is automatically updated each time transaction ZGLSU is run on the SAP client in question.

   

3. To have more than one choice available in the spreadsheet's Systems drop-down list, you must run the ZGLSU transaction in more than one SAP client.

   Example: To have both production and testing environment information, you must run the ZGLSU transaction on both the productive and testing boxes. This then downloads two unique files containing master data to your PC.

In order to help distinguish between workbooks for different SAP systems, you may use the SAP system and client formula to display this information on the worksheet. Simply add the formula =glsu_sysid() to any cell. If you change systems in the Options of GLSU the system and client will change automatically.

Note: It may be necessary to add a skip row to avoid a pre-validation error when adding this formula.

Note: The SAP system choice does not take effect until GLSU is logged on to the appropriate SAP system.

Note: GLSU stores each unique SAP system and client’s data in a separate .INI on your system.