Studio Features - Automate_Studio - 24.0

Excel Add-In Enhancements (20.0)

• Open menu in the Add-in includes a separate folder for templates and documents
• Support for opening and submission of Reference Data Excel files

Studio Log-on Enhancements (20.0)

• Support for SAML authentication to connect to Evolve/Studio Manager
• Support for assigning an app to default app for login during Studio launch
• SAP Shuttle Logon displays the connection name, system ID, client and server type for SAP systems configured on Studio Manager/Evolve
• Auto Logon credentials saved display the SAP Server connection name

Mapper Enhancements

A. Transaction

• Support for Auto Sync added while mapping with Preserve, Replace and Insert Before operations
• Support for downloading multiple fields using drag and drop in the mapper
• Excel mapping and operations improved with real-time Excel experience
• Shift Up and Shift Down added for mapper items
• Paste After functionality added for mapper fields
• Blank Row addition feature added to the context menu
• Support for switching between script properties and field row properties using a script button on the properties panel
• Usability improvement: additional options in the context menu
• Support of padding for different data types
• Availability of a Write Header option in the mapper tab
• Availability of an Auto Map option in both Basic and Expert View
• Support for commenting within multiple selected rows via the properties panel
• Availability of a Field Length option to visualize the length of a field in SAP
• Support for changing the recording mode via the properties panel
• Support for enabling and disabling the Extended Log property via the mapper tab rather than via advanced run options
• Support to apply and validate Excel formulas on selected fields
• Support for converting If Else condition block to If condition
• Support for using Transform formulas in all languages supported by Microsoft Excel
• Support for editing the condition of empty If blocks and Loop blocks
• Support for adding Else Blocks to If conditions defined inside a loop
• The Background Mode setting is retained after you close a script

Introduced in Studio 20.0:

• Solution Developers can attach supporting document tags in data templates, and Runners can upload the supporting documents to SAP
• Separate file attachment log​
• Ability to attach supporting docs ​
• Support for attachments during server execution​
  • Long text formatting is retained ​
  • Change logs are maintained
• Support for scheduling the solution with an extended log field; availability of extended logs in the data file after running

B. Query

• Shift Up and Shift Down functionality added for mapper items using the context menu or the ribbon
• Support for restoring mapping to the original recording state; actions bifurcated to tabs to improve usability
• Support for commenting within multiple selected rows via the properties panel
• Paste After functionality added for mapper fields
• Usability improvement: additional options in the context menu

Introduced in Studio 20.0:

• Support for Reference Data
• More than 2000 values with In criteria
• Support for joins between STXH and STXL
• Run before Submission is checked by default

C. Direct

• Addition of the Loop Deletion and Update features
• Availability of the Search option in workspace
• Availability of the Synchronize option
• Feature to apply a List of Values (LOV)
• BAPI creation simplified with single script creation in Direct
• Single script creation and the availability of options within tabs simplifies the introduction of changes
• Paste After option added to mapper fields
• Usability improvement: additional options in the context menu

Execution Enhancements

A. Transaction

• Skip screen in loop
• Editing t-codes
• Time stamp addition for logs generated
• Validate only Unprocessed Rows
• Validate only Error Rows
• Simulate only Unprocessed Rows
• Simulate only Error Rows
• Check Data
• Support of Simulate and Validate in Console mode and Macros
• Support for adding Look up values from the run tab
• Support for adding Auto Logon Credentials from the run tab
• Support for chain-linked scripts with All From Individual, All From First and Custom settings
• For linked scripts, ability to view individual settings and select execution order
• Add, Rename, and Delete Sheet added to Excel preview on the run tab
• Addition of padlocks to the Start Row, End Row, Sheet, Backup Data, Start SAP GUI, and Skip field indicator
• Support for the following SAP Authentication types: SAP SSO, CyberSafe  
• Support for a relative path for chain scripts
• Support for placing ALC files on network and shared locations
• Improved Document Attachment and Long Text handling
• Support for adding Service Port for SAP Connection in Studio
• Support for providing an SAP Router string for SAP Log-on
• RFC and NetWeaver libraries incorporated into installers
• Support for cross-linking scripts run via Client, Add-in, Console mode, or Macros
• Support for Validate in sequential nested loops
• Support for F4 Help for BAPI and Transaction (BP t-code)
• Support for simultaneous run of Unprocessed and Error Rows
• Support for SAP GUI 760
• Support for Microsoft Excel 2019

Introduced in Studio 20.0:

• Support for server scheduling for Studio Manager
• Submission of script and data template as one complete solution
• From Submit Wizard, submission of solution is to a default destination in Evolve/Studio Manager
• The solution file workflow is moved to the Submit Wizard; data required task is moved from the My Workflow Tasks tab to the Submit Wizard
• Support for Loop Back tasks for standard workflows
• Support for zipping supporting documents in the Submit Wizard
• Support for cross-linked, multi-script submission

B. Query

• 65K-character limit removed
• Support for applying criteria on Outer Joins Right Table
• View Records feature in Access, SP List and SQL destination data sources on the run tab
• EAQT option on the run tab
• Support for updating chain run settings – EAQT, Data Chunks, Write Records
• Rename feature addition for Access, SQL and SPList data sources
• Support to add Look Up values from the run tab
• Support to add Auto Logon Credentials from the run tab
• Support for the following SAP authentication types: SAP SSO, CyberSafe
• Support for chain-linked scripts with All From Individual, All From First and Custom settings
• For linked scripts, ability to view individual settings and select execution order
• Add, Rename, and Delete Sheet added to Excel preview on the run tab
• Addition of padlocks to the Start Row, End Row, and Sheet
• Support for relative paths for chain scripts
• Support for placing ALC files on network and shared locations
• Support for adding Service Port for SAP Connection in Studio
• Support for providing an SAP Router string for SAP Log-on
• RFC and NetWeaver libraries incorporated into installers
• Support for cross-linking scripts run via the Client, Add In, Console mode, or Macros
• Support for the SAP Conversion Exit feature for fields
• Save After n records functioning
• Support of SAP GUI 760
• Support of Microsoft Excel 2019

Introduced in Studio 20.0:

• Support for Query output to Reference Data
• Support for server scheduling for Studio Manager
• Submission of the script and the data template as one complete solution
• From the Submit Wizard, solutions are submitted to a default destination in Evolve/Studio Manager
• Solution workflow tab is introduced in the Submit Wizard (the Data required task is moved from My Workflow Tasks tab to the Submit Wizard)
• Support for zipping the added supporting documents in the Submit Wizard
• Support for cross-linking scripts run via the Client, Add-in, Console mode, or Macros

UI Enhancements to Studio Backstage

A. Log Viewer

• Visibility of Transaction, Query and Direct consolidated logs
• Filters available for: Data Source Types, Run Date, Product Types, T-codes, Tables, and BAPI Names
• Script Path, Data File Path, Data Type, Run By details added
• Addition of individual log row for linked scripts; log rows include script, data file and SAP server details for individual scripts
• Color scheme adopted for success and error rows in log
• Addition of Total Number of Records Processed by user individually for Transaction, Query and Direct

Introduced in Studio 20.0: Filter for Reference Data source

B. Scheduled Tasks

• Consolidation of Transaction, Query and Direct scheduled tasks list
• Addition of the following fields: T-code, Scheduled Status, Disable Production Server Warning, Reason for Run Failure, Save to Evolve or Foundation

C. User Account

• Display of username and email
• Visibility of license status assigned to logged-in user
• Visibility of list of components (Transaction, Query, Direct) enabled for assigned license
• Visibility of Connect URL information
• User authorization option available in app options with key ForceUserCreds
• Support for TLS 1.2

Introduced in Studio 20.0: Support for changing the default app assignment and for switching the app

D. Options Added

• AutoMap on Recording to automatically map fields with successful recording from SAP
• Skip Indicators Collection to specify a list of skip indicators
• Enable RFC Trace
• Set Evolve/Studio Manager or Foundation per-page download limit (in Evolve/Studio Manager or Foundation mode)
• Document attachment limit
• Enforce Non-Function Module for run operations
• Set Do not write log header
• Override regional settings
• Set the Query timeout value
• Set Preserve Header to true
• Configure the number of scripts you want to view under Recent Scripts and the number of records you want to view under Show Preview Records

Introduced in Studio 20.0: Selection of default libraries for Query and Transaction solutions

E. Open

• Separate library for Excel solutions
• Update to the solution library dialogue box