Contact Us
Index
Version 23.2
Version 5.1 Version 5.0 Version 5.2 Version 5.3 Version 5.4 Version 5.5 Version 5.6 Version 20.1 Version 20.2 Version 20.3 Version 20.4 Version 21.2 Version 21.3 Version 21.4 Version 22.1 Version 22.2 Version 22.3 Version 22.4 Version 23.1 Version 23.3 Version 23.4 Version 24.1 Version 24.2 Version 24.4 Version 25.2
Contact Us
Wands for SAP 23.2 – Home
Wands
Logging On
Launch Configuration
Company Code Selection
Excel Not Ready Error
Add-In Load Error
Toggling from V21.x to V4.x
Toggling from V4.x to V21.x
Multi Language Support
License Key
License Key Errors
License Model
Platform Portal
Insert Wands Function
Combine Text
Last Refreshed By
Last Refreshed Time
Split Text
Tools (Wands)
Snapshot
Shared Templates Drive
Drive Types
Navigator
File Server
Create a File
SAP Database
Delete a File
Edit a File
Open a File
Common Options
Administrator
System Administrator Options
System Administrator License Key
System Administrator User Permissions
System Administrator User Options
System Administrator Delimiter Options
System Administrator Configuration Options
System Administrator Server Information
Errors and Troubleshooting
Help and Shortcuts
Excel Error
Upgrade Workbook
About
Exit
GL Wand
Quick Start
Report Wizard
Add Columns
Design Layout
Add Rows
Report Wizard Output
Company Code and Object Selector
Discover
Discover FICO Object Values
Expand/Explode Level
Expand and Explode
Expand FICO Object Values
Expand FICO Object Value Hierarchy
Explode FICO Object Values
Explode FICO Object Value Hierarchy
List of Values
List of Values – Create
Insert GL Wand Function
Get Balance
Get Classic GL Balance
Get New GL Balance
Get Daily GL Balance
Get CCA Balance
Get PCA Balance
Get COPA (CB) Balance
Get Internal Order Balance
Get Activity Type Balance
Get Project Balance
Get SKF CCA Balance
Get ECCS Balance
Get Universal Consolidation Balance
Get SKF IO Balance
Get Universal Journal Balance
Get Overall Plan Balance
Get Classic Funds Balance
Get Classic Grants Balance
Get Funds Management Balance
Get SKF PCA Balance
Get Budget Control System Balance
Get SPL Balance
Company Code Name
Object Description
FICO Object Description
COPA (CB) Object Description
Next Object
Next COPA (CB) Object
Next FICO Object
Get Exchange Rate
Fiscal Period to Month
Previous Object
Previous FICO Object
Previous COPA (CB) Object
Alternative GL Account
Get Offsetting Account
Calculating
Execute Drilldown
Drill Criteria Sheets
Drill Using a Saved Template
Drill to Line Item
Drill to Document
Drill to Document Attachment
Customize Drilldown
Edit Template Layout
Save Template Layout
Manage Templates
GL Wand Tools
GL Wand User Options
Other Tools
Hide Zeros
Clean Template
Manage Criteria Templates
Configuration Sheet
Reports Wand
Report
Create Report
Execute Report
Insert Function
Insert Run Report Function
Run Report Filter
Modify a Run Report Function
Drill On Function
Drill to Saved Template
Refresh
Refresh Reports Wand Functions
Refresh Mode
Show
Parameter List
Report Editor
Template Manager
Tools
Reports Wand User Options
Connection Manager (User)
Administration
Report Definition
Create
Edit
Import Export
Multi Data Source (MDS)
Angles for SAP
Planning Wand
Insert Planning Wand Function
Load CCA
Load PCA
Load New GL
Load Activity Input
Load Activity Output
Load SKF
Load S4 Financial
Load Option Selector
Loading Plans
Planning Wand User Options
Report Distribution Manager
Create RDM Template
Source Report
Named Ranges
Parameters
Drilldowns
Email
Advanced Options
Execute Report Distribution Manager
Load and Validation
Execution
Edit RDM Template
Scheduler
Create Schedule
Running the Scheduler
RDM User Options
SMTP Email Settings
chat icon - ignore
Live Chat
Chat Offline

Launch Configuration

The Launch Configuration is accessed by running SAP transaction code /EXCEL4AP/WANDS_5_MT and then clicking the Maintain Launch Configuration button.

The following settings are available:

Field Name Value Description
LAUNCHER_WEB_PAGE The default is the insightsoftware getting started with Wands for SAP page The web page to be displayed on the SAP launch transaction. You may change this to any web page or use a blank value by using https://
HOST A hostname or an IP address e.g. myhostname.com or  123.456.7.89 The host value for the SAP application server. The launch transaction will try to automatically determine this value. If the automatically determined value does not work you can set the value with this field name.
PORT e.g. 33xx The port value to be used for the application server. This is automatically determined and is not usually required. The standard port used for an application server connection is 33xx where xx is the SAP system instance number.
MS_HOST A hostname or an IP address e.g. myhostname.com or  123.456.7.89 The host value for the SAP message server
MS_PORT e.g. 36xx The port value to be used for the message server. This is automatically determined and is not usually required. The standard port used for a message server connection is 36xx where xx is the SAP system instance number.
MS_GROUP e.g. PUBLIC The message server group for the Wands users
SAP_ROUTER e.g. /H/sap_rout/H/your_rout/W/pass_to_app/H/yourapp/S/sapsrv The SAP router string
DELETE_PROPS false If you do not want the properties file to be deleted, set this value
SNC_PARTNER_NAME e.g.  p:CN=EC7, O=SAP, C=US, OU=SAP The SNC partner name is determined automatically. If the configuration is not complete you can manually define the SNC partner name with this field
IGNORE_F_BKPF_GSB X If this value is set for this field name the business area authorization object F_BKPF_GSB is ignored
IGNORE_F_BKPF_BLA X  If this value is set for this field name the document type authorization object F_BKPF_BLA is ignored
ENCODING The default value is UTF-8 Allows the communication with the SAP server to use a different encoding algorithm
USE_TAGGED_USERS The default is not to use tagged users Set the value of this field name to X to make use of tagged users. This assists with SAP systems with a large number of user ids. Only users that have the /EXCEL4AP/WANDS5 authorization role are then retrieved in the user permissions panel. Please ensure the user has the S_USER_GRP authorization object to display values.
SERVICE_URL The default is to let the application determine the service URL automatically This setting only applies to the Web Launcher option in the launch transaction code. Set the value of this to a custom URL if you wish to forward the request to the service from another URL. It must be the full URL e.g. https://myhost.com:myport/sap/insightsoftware/wands_sap/launch
IGNORE_SSO The default is to use SSO  Enter an X to use this option if your SAP system is not recognizing its generated re-entrance ticket
IGNORE_SNC The default is to use SNC Enter an X to use this option to ignore the SNC configuration you have in your SAP system and on your PC
LICENSING_MODEL The default is to use Legacy Set to Platform if instructed to do so by an Insightsoftware support agent