Add Master Data Texts
In the example below, Column D is a blank column. Column D contains an Excel formula =glsu_description(xx). The xx in the formula is a reference to another cell in the spreadsheet that contains a GLSU master data element (in this case, the account value in Column D). The formula in Column D will return the Account master description for the account shown in cell D9.
The =glsu_description(xx) formula will work for any master data element that GLSU pre- validates including GL Accounts, Vendors, Cost Centers, Profit Centers, etc. (except Field Status Groups).
Specific steps to include master data texts in your spreadsheets:
- Make sure your GLSU .INI file contains the master data texts by choosing the Text check box for all the appropriate fields in the ZGLSU transaction. This option is valid if you are performing the off-line method of retrieving descriptions. If you are retrieving descriptions in a real-time method, this configuration option has no relevance. From the ZGLSU Transaction in SAP, select Validation Options.
- Make sure you re-download your .INI file after making your text selections.
- Insert a blank column into your spreadsheet where you want the master data text to appear. For an explanation of how to add a blank column, see the section on Ignore Columns.
- Optionally, enter a column description into your blank column header.
- In the blank column, enter the formula
=glsu_description(xx)where xx equals the cell where the master data element is entered. In this example, the E column is being referenced.
Using descriptions with a live setting in GLSU.
If you are using live descriptions for certain fields in GLSU, you may need to perform a Refresh Descriptions after utilizing the GLSU description function.
If this is the case, the text refresh required will appear in each cell. Upon selecting the refresh descriptions options in GLSU, all of descriptions will be updated from SAP.