Execute SAP T-Code without a GEXD Formula

Similar to the GEXD formula, the SAP T-Code function is used to return the detail results of a SAP T-Code, and execution variant. The SAP T-Code function differs from a GEXD formula, as no actual formula resides in the spreadsheet, and the results are displayed in a separate panel, instead of on the spreadsheet.

Setup

1. Ensure T-Codes are assigned to the appropriate SAP host configuration(s) in Application Configurator.
2. In the Spreadsheet Server Settings > Ledger Specifics > SAP panel, select the T-Codes to be pinned to the ribbon.
3. Prior to using a new or modified pinned T-Code, in Excel, from the Spreadsheet Server Ribbon, select Refresh. The system refreshes pinned T-Codes.

Process

1. In Excel, from the Spreadsheet Server Ribbon, select Query, then, to:
• Select a T-Code: select SAP T-Codes. The SAP T-Codes > Select T-Code pane appears. Continue to step 2.
• Select a pinned T-Code: navigate to, and, select the desired T-Code. The SAP T-Codes > Select Execution Variant pane appears. Continue to step 4.

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. The SAP T-Codes > Execution Variant pane appears, listing execution variants available for the selected T-Code.

4. Select the desired execution variant in the list, and:
• To process the T-Code using the default parameters: click Execute. The Drill Down panel appears, displaying the detail records.
• To view and/or modify the parameters to be used to process the T-Code: click Next. The SAP T-Codes > Parameters pane appears. Continue to step 5.

Note: If the <None> variant is selected, the Execute button is disabled. Click Next and continue to step 5.



5. In the SAP T-Codes > Parameters pane, type the appropriate parameters and click Execute. The Drill Down panel appears, displaying the detail records.