Contact Us
Index
Version 5.4
Version 5.1 Version 5.0 Version 5.2 Version 5.3 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.2 Version 23.3 Version 23.4 Version 24.1 Version 24.2 Version 24.4 Version 25.2
Contact Us
Wands for SAP 5.4 – Home
Wands
Logging On
Troubleshooting
New Release Notification
User Profile
Company Code Selection
Excel Not Ready Error
Add-In Load Error
Toggling from V5.x to V4.x
Toggling from V4.x to V5.x
Maintenance Transaction
Maintain Versions
Maintain CDS Search Help
Maintain CDS View Parent/Child
Select SPL Table Group/Fields
Maintain Launch Configuration
License Key
License Key Errors
Insert Wands Function
Combine Text
Last Refreshed By
Last Refreshed Time
Split Text
Tools (Wands)
Snapshot
Shared Templates Drive
Drive Types
Navigator
Dropbox
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
Help and Shortcuts
Excel Error
Upgrade Workbook
About
Exit
Errors and Troubleshooting
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 Daily GL Balance
Get Daily Customer Balance
Get Daily Vendor Balance
Get New 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 SPL Balance
Get SKF IO Balance
Get SKF PCA Balance
Company Code Name
Object Description
FICO Object Description
COPA (CB) Object Description
Next Object
Next FICO Object
Next COPA (CB) Object
Get Exchange Rate
Previous Object
Previous FICO Object
Previous COPA (CB) Object
Alternative GL Account
Get Offsetting Account
Execute Drilldown
Drill Criteria Sheets
Drill Using a Saved Template
Drill to Line Item
Drill to Document
Drill to Document Attachment
Calculating
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
Planning Wand
Insert Planning Wand Function
Load CCA
Load PCA
Load New GL
Load Activity Input
Load Activity Output
Load SKF
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

Get COPA (CB) Balance

In order to extract a COPA (costing-based) balance, the Get COPA (CB) Balance function is used.  The usage of COPA firstly requires a change within the User Options.

Within User Options in the GL Wand ribbon, tick the “Use COPA” box and select the relevant Operating Concern from the dropdown.  Then Save and click the Change Company Code button from the GL Wand ribbon to re-initiate the logon process.

Parameter Description
Year A value, e.g. “2017”
Period Period number e.g. “1”
Balance Type YTD – summarizes the full year balance up to the period parameter input

PTD – summarizes the movement for the period parameter input

QTD – summarizes the movement for the quarter based on the period parameter input

CTD – summarizes the custom period criteria based on the period parameter input e.g. “2:4”

Actual Flag A = Actual; B = Budget
Version If you have selected Budget values, enter the applicable Version. The wizard will automatically insert the correct version for Actuals.
Currency Type The Currency Type as configured in SAP e.g. “10” = Company Code Currency; “B0” = Operating Concern Currency
Record Type The Record Type as configured in SAP e.g. “A” = Incoming Sales Order; “F” = Billing Data
Operating Concern The Operating Concern. This value will default in based on the User Option setting above.
Value Field The Value Field as configured in SAP e.g. “VV010” = Revenue; “VV040” = Cost of goods sold
Customer Optional
Product Optional
Billing Type Optional
Sales Order Optional
Order Optional
Company Code The Company Code.
Controlling Area The Controlling Area.
Plant Optional
Business Area Optional
Sales Organization Optional
Distribution Channel Optional
Division Optional
Profit Center Optional
Partner Profit Center Optional
Cost Object Optional
WBS Element Optional
Material Group Optional
Material Group 1 Optional
Prod.hier. 1 bef. 4.5 Optional
Prod.hier. 2 bef. 4.5 Optional
Prod.hier. 3 bef. 4.5 Optional
Product category Optional
Prod.group for SOP Optional
Strategic Bus.Unit Optional
Customer group Optional
Customer classific. Optional
Sales district Optional

Authorization Objects

Authorization Object Description
K_KEB_TC Profitability Reports
K_KEA_ERG Profitability Analysis: Set Operating Concern