QUERY > Setting preferences > SAP defaults

Back to

Setting preferences

SAP defaults

To set the default SAP logon

  1. On the Tools tab, click Options.
  2. Click SAP logon default.
  3. Specify default SAP logon languages.
  4. If you want, select the Remember last logon password check box.
  5. Specify a customized path for the SAP logon .ini folder. Click the folder icon to browse to the folder.

    Important: If you are using SAP GUI 740, browse to the folder in File Explorer, click the file type box in the lower right corner, and then click Sap LandScape File.

  6. For 64-bit operating systems, SAP logon defaults display an option to select the Single Sign On (64 bit) configuration file.

User data formats

In QUERY, you can specify whether data is displayed as raw data or as formatted data.

Use regional settings. Select this check box to ensure that dates and numbers are downloaded and displayed in accordance with the regional settings on your computer. Regional settings apply to Excel, text, and XML files. Regional settings also apply to data that is displayed in QUERY, such as previewed text and values displayed through F4.

Access and SQL Server databases use their own data formats and do not display data in the regional setting format.

You specify regional settings on the Regional and Language Options dialog box that is available through Control Panel on your computer.

Clear the Use regional settings check box. Clear this check box to download raw data in Excel, text, and XML files. Raw data is displayed in QUERY, such as in previewed text and values displayed through F4. Access and SQL Server databases use their own data formats.

Dates. You can specify the download format for dates in the Date Format box. The date format selected is used to display dates in Excel, text, and XML files, in Access and SQL Server databases, and in preview and F4 values that are displayed in QUERY.

Also in this section

Automating your logon

Client connection settings

Specifying query script properties

The Winshuttle Function Module for QUERY

Version compatibility among Winshuttle products