Add a New Host Configuration for SAP

The following General Ledger application settings apply to all users licensed when using a SAP General Ledger type or when connecting to a SAP Designer GL, whether processing the General Ledger, Query or Query Designer feature. This article describes how to add a Host configuration for SAP.

1. From the Application Configurator panel, select the Application Settings tab. The Application Settings panel appears.
2. Click the SAP tab.

3. To create a new host configuration, from the ribbon, click the New button. The system adds a new host configuration in the navigation pane, and the SAP > Host Configuration panel appears.
4. Use the following table to enter data in the SAP > Host Configuration panel:

Field	Description
Connection Type	Click the drop-down list, and, select the appropriate connection type. The selected connection type determines the fields available in the panel. Note: Legacy SAP GUI only functions in a 32-bit environment.
Connection Name	Specify the connection name.
System	For SAP NetCo 3.0 connection types, click the ellipses button ( ... ), and select the desired system. Otherwise, leave the field blank, to default to <SIGN-ON>, indicating the user will specify the system when they connect to the database. Note: if SAP system names are not consistent in an organization, it is recommended to leave the value set to <SIGN-ON>.
Client	For SAP NetCo 3.0 connection types, specify the SAP client.
User	Specify the user ID to be used to connect to the database.
Password	Specify the user password.
Language	For SAP NetCo 3.0 connection types, specify the language code.
Use Single Sign-On	For SAP NetCo 3.0 connection types, if selected, users are authenticated by their Windows user name, and are not required to enter their credentials when logging into Spreadsheet Server, or processing queries in Query Designer. If selected, additional input fields are enabled for entering processing criteria.
Kerberos/NTLM	If Use Single Sign-On is selected, specify whether Kerberos or NTLM (NT LAN Manager) security protocols are used for authentication.
Security DLL Path	If Use Single Sign-On is selected, type the path, or, use 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 may be overridden at the user level, based on the Security DLL Path defined in the user's Spreadsheet Server Settings.
CO Ledger: Enforce SAP COSP Company Security	If selected, COSP company security is applied, when retrieving data for the SAPCO ledger.
Set as default connection for Spreadsheet Server formulas	If selected, the SAP host configuration is used for processing Spreadsheet Server formulas, if a specific connection is not defined in the formula.
Allow SAP Query (SQ00) execution on this connection	If selected, queries built in SAP may be executed in Excel, using Spreadsheet Server query formulas for the SAP host configuration.
Ignore port number when connecting to host	If selected, the port number is ignored while connecting.
Disable Remember Me on Logon dialog	For SAP NetCo 3.0 connection types, if selected, the Remember Me check box is disabled in the login dialog panel, when users sign into Spreadsheet Server.

Button	Function
Test Configuration	Displays a message in the Results field, indicating whether or not the connection and the call to the files was successful.



5. Use the following table to enter data in the SAP > T-Codes panel:

Note: The T-Codes panel is only available for SAP NetCo 3.0 connection types.

Field	Description
SAP T-Code	Specify the SAP T-Code(s) to be added to the list of available T-Codes. Use a comma ( , ) to separate the values, if entering multiple T-Codes.
T-Code List	Displays a list of existing T-Codes available for the host configuration for query processing in Spreadsheet Server. When a new SAP host configuration is created, the system automatically assigns all default T-Codes to the list. To: Filter data in the grid: enter the desired value in the appropriate column filter field. Fields are filtered character-by-character. Delete T-Codes in the list: select the T-Codes to be removed, right-click and select Delete.

Button	Function
Add	Adds the specified T-Code(s) to the list of available T-Codes.
Repopulate Defaults	Adds current default T-Codes, if missing, to the list.
Clear Defaults	Removes default T-Codes in the list, but retains non-default T-Codes.


6. Use the following table to enter data in the SAP > GL Files panel:

Field	Description
Ledger	Displays the names of the classic SAP ledgers.
Associated Tables	Displays a list of the tables for the associated ledger used in the GXL balance SQL, or in the drill down and/or detail SQL.
Secondary Database Connection	Specify, if desired, the name of the secondary database connection to be used for processing. All files must be present in the secondary database connection.


7. Click Save, then Yes, to push the changes to the network location.