• Welcome to Winshuttle Studio
• Studio 11 Release Notes
• Studio 11 System Requirements
• Studio 11 Help
  • Getting started
    • Getting started with Studio v11
    • Step 1. Download
    • Step 2. Install
    • Step 3. Licensing
    • Step 4. Open
    • Finding your way around
    • Where is it in Studio v11?
  • Best Practices
  • Setting up
    • Setting up Studio 11
    • System requirements
    • Connecting to SAP
    • Authorization check
    • Required SAP Authorizations
    • What types of data files can I use?
    • GUI scripting and Windows scripting
    • Studio 11 options
    • Change the language
    • Error management and trace files
    • Single Sign-on (SSO) with 64-bit Studio 11
    • EP logon
    • Add an SAP system
    • Winshuttle Function Module
    • Admin info
      • Installing and uninstalling
        • Installing and uninstalling Studio 11
        • Single .exe: Fresh installation and upgrade
        • MSI: Fresh installation and upgrade
        • Network installation using Microsoft SCCM
        • Network installation using SysInternals PsExec tool
        • Uninstalling
        • How to create a response file
        • Coexistence of Winshuttle 10.x products with Studio 11
        • Access DB office 2007 (32-bit) installation behavior
      • Custom Winshuttle roles for the SAP server
      • Configure Studio 11 before first use
      • Winshuttle utility kit
  • Transaction
    • Create a script for a transaction
    • Recording
      • Record the script
      • Step-by-step guides
      • Recording modes
      • Using Transaction with Virsa Firefighter
    • Mapping
      • Map the fields
      • Map the fields in Excel
      • Map fields to an Access database file
    • Looping
      • Add a loop
      • Add a loop in Excel
      • Add a loop in Access
      • Advanced looping
    • Running
      • Run a transaction script
      • Use macros to run a script
      • Run a Transaction script from the command line
      • Run settings for Transaction
    • Schedule a Transaction run
    • View run logs and details
    • More Transaction commands and features
      • Record long text
      • Map and upload long text
      • Change the data file type
      • Open an existing data file
      • Add If conditions
      • Add transforms
      • Limit input values
      • Change the padding
      • Skip screens that are not present in the SAP system
      • Require data for a field
      • Attach documents
      • Filter Mapper settings
      • Restore an original recording in Studio
      • Download data from SAP
      • Chain scripts
      • Write headers
      • Change the transaction code
      • Change the core recording time
      • Publish a script with an Excel data file
  • Query
    • Create a script to query SAP
    • Choose fields
      • Choose query tables and fields
      • Choose query fields in an InfoSet or an SAP Query
      • Choose logical databases
      • Choose query fields from a recording
    • Define criteria for a query
    • Mapping
      • Map the query fields
      • Map query fields to Excel
      • Map query fields to Access
      • Map query fields to a text file
    • Running
      • Run a Query script
      • Run a script from Excel
      • Use macros to run a script
      • Run a Query script from the command line
      • Run settings for Query
    • Schedule a Query run
    • View run logs and details
    • More Query commands and features
      • Create joins between tables
      • Use the In operator
      • The Like operator and wildcard characters
      • Use dates as criteria
      • Change the data file type
      • Chain scripts
      • Add transforms
      • Write headers
      • Publish a script with an Excel data file
      • Authorizations
  • Direct
    • Create a script from a BAPI
    • GL document with multiple currencies
  • Runner
  • Working with LMS

Advanced Query commands and features

Find more information at the Winshuttle Support portal.