SAP Ledger Specifics

Specify the language ID to be used for all descriptions.

Specify the SAP client number. This value is updated during sign in.

Note: This option is only applicable if using a legacy SAP GUI host configuration.

If selected, the number of segment records loaded during a segment value lookup (for example, in the Locate Segment panel, or, when clicking the ellipses (...) button for an account segment in the Build a Template or Control Panel panels) is limited by the number of records specified.

If selected, the SAP Adapter returns results in an array or table with length optimized for the results being returned, in an effort to reduce network traffic going between Excel and SAP.

Displays the default SAP host configuration setting. If selected, users are authenticated by their Windows user name and are not be required to enter user and password data when logging into Spreadsheet Server, or processing queries in Query Designer. If selected, the Security DLL Path field is enabled for entering processing criteria.

Displays the default SAP host configuration setting, indicating whether Kerberos or NTLM (NT Lan Manager) security protocols are used for authentication.

If Use Single Sign-On is selected, type the path, or, click the Browse button to select the location of the SAP Security DLL file. The default path references the DLL file used for Kerberos, and is set to: C:\Windows\System32\gsskrb5.dll (32-bit) or C:\Windows\SysWOW64\gx64krb5.dll (64-bit).

Note: This path overrides the path defined in Application Configurator.

Note: These options are only applicable if using a NetCo 3.0 SAP host configuration.

If selected, indicates to run the SAP RFC trace and create the appropriate trace logs. If selected, additional options become available.

Click the drop-down list, and select the trace level to be run. The higher the level, the more tracing data collected.

Click the drop-down list, and select the trace level to be run. The higher the level, the more detailed the tracing data collected.

Type the path or click the Browse button to specify the location of the trace logs.

Displays a list of companies to which the user is authorized. These values are updated during sign in.

Displays a list of each currency setup within SAP and its applicable currency precision. These values are updated during sign in.

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.

Displays a list of SAP T-Codes for the selected configuration. Data in the grid may be filtered or resorted as necessary. To pin favorite or most often used T-Codes to the Spreadsheet Server Ribbon> Query > SAP T-Codes drop-down list, select the Pinned check box for each desired T-Code.

Note: After making changes to pinned settings, save the changes, then from the Ribbon, select Refresh > SAP T-Codes to repopulate the list of pinned T-Codes displayed in the ribbon (see Execute SAP T-Code without a GEXD Formula for more information).

Specify the button label and tool tip to appear in the Spreadsheet Server Ribbon > Build a Template > General Ledger menu, to identify the FI ledger for building a GXL formula.

Specify the button label and tool tip to appear in the Spreadsheet Server Ribbon > Build a Template > General Ledger menu, to identify the CO ledger for building a GXL formula.

Specify the button label and tool tip to appear in the Spreadsheet Server Ribbon > Build a Template > General Ledger menu, to identify the COOR ledger for building a GXL formula.

Specify the button label and tool tip to appear in the Spreadsheet Server Ribbon > Build a Template > General Ledger menu, to identify the PCA ledger for building a GXL formula.