SAP Explorer

The SAP Explorer panel allows users to:

• Search either the T-Codes or queries built in SAP (SQ00), then select the desired T-Code to be processed in a GEXD formula.
• Select the desired SAP query to be processed in either a GEXD, GEXS, or GEXI formula.

Prior to using a T-Code in Spreadsheet Server, the T-Code must be assigned to the appropriate SAP host configuration(s) in Application Configurator.

Select a SAP T-Code for Processing

1. From the Formula Builder > GEXD panel, click the SAP Explorer button (). The SAP Explorer panel appears.

2. Click the drop-down list, and select the host configuration to be used for listing SAP T-Codes. The list only displays SAP NetCo 3.0 connection type configurations.
3. Select the desired T-Code by double-clicking the T-Code in the list, or selecting the T-Code in the list, and clicking Next. A list of execution variants available for the selected T-Code appears.

4. Select the desired execution variant:
• To view and/or modify the parameters to be used to process the T-Code: select the desired execution variant by double-clicking the execution variant in the list, or, selecting the execution variant in the list, and clicking Next. The system selects the T-Code and execution variant, and returns to the Build a Template > GEXD panel, listing all parameters for the selected variant.
• To process the T-Code using default parameters for an execution variant: select the Run by Execution Variant option, and, if desired, select an execution variant, then click Next. The system selects the T-Code and execution variant, and returns to the Build a Template > GEXD panel, with Execution Variant being the only parameter.

Select a SAP Query (SQ00) for Processing

1. From the Formula Builder > GEXD, GEXS or GEXI panels, click the SAP Explorer button ().  The SAP Explorer panel appears.
2. If necessary, click the SAP Query (SQ00) tab.
3. Use the following table to enter data in the SAP Explorer > SAP Query (SQ00) panel:

Field	Description
Configuration	Click the drop-down list, and select the host configuration to be used for listing SAP queries. The list only displays SAP configurations that are permitted to execute SAP queries (SQ00).
Area	Specify whether to list SAP queries from the Global or Standard area.
User Group	If desired, specify the user group from which to list SAP queries. The value may be a single value or mask.
Search For	If desired, specify the name of the SAP query to be listed. The value may be a single value or mask.
Query List	Displays a list of SAP queries meeting the search criteria. Data in the grid may be filtered or resorted as necessary.

4. Enter the desired search criteria and click the Search button. The system lists the SAP queries meeting the search criteria.
5. Select a query by double-clicking the query in the list, or, selecting the query in the list, and clicking Select. The system selects the query, and returns to the appropriate Formula Builder panel.