Preliminary Application Help
Enterprise Controlling Consolidation (EC-CS), Business
Consolidation (SEM-BCS)
Document Version: 1.2 – 2014-01-28
CUSTOMER
SAP Interactive Excel 3.0
Enhancement Package 5 for SAP ERP 6.0 and later
2
CUSTOMER
©
2014 SAP AG. All rights reserved.
SAP Interactive Excel
3.0
Typographic Conventions
Typographic Conventions
Type Style
Description
Example Words or characters quoted from the screen. These include field names, screen titles,
pushbuttons labels, menu names, menu paths, and menu options.
Textual cross-references to other documents.
Example Emphasized words or expressions.
EXAMPLE Technical names of system objects. These include report names, program names,
transaction codes, table names, and key concepts of a programming language when they
are surrounded by body text, for example, SELECT and INCLUDE.
Example Output on the screen. This includes file and directory names and their paths, messages,
names of variables and parameters, source text, and names of installation, upgrade and
database tools.
Example Exact user entry. These are words or characters that you enter in the system exactly as they
appear in the documentation.
<Example> Variable user entry. Angle brackets indicate that you replace these words and characters
with appropriate entries to make entries in the system.
EXAMPLE
Keys on the keyboard, for example,
F2
or
ENTER
.
SAP
Interactive Excel 3.0
Document History
CUSTOMER
© 2014 SAP AG. All rights reserv
ed.
3
Document History
Version
Date
Change
1.0 2013-04-17 Initial version
1.1 2013-07-09 • New chapter: Chapter 2 Quick Guide to Using SAP Interactive Excel
Describes the steps that are necessary for first-time use of
SAP Interactive Excel
• New chapter numbering
1.2 2014-01-28 The following chapters are new:
• 5 Matrix Examples
• 6 Working with Structures
• 7 Pivot Tables
• 8 Security
• 9 SAP Interactive Excel Converter
4
CUSTOMER
©
2014 SAP AG. All rights reserved.
SAP Interactive Excel
3.0
Table of Contents
Table of Contents
1 About SAP Interactive Excel ......................................................................................................................... 6
2 Quick Guide to Using SAP Interactive Excel ............................................................................................... 8
2.1 Logging On to a System .......................................................................................................................................... 9
2.2 Defining Global Parameters (Optional) ................................................................................................................ 11
2.3 Reporting ................................................................................................................................................................ 13
2.4 Posting Data ........................................................................................................................................................... 17
3 Online Data Entry with SAP Interactive Excel ......................................................................................... 20
3.1 Opening a New Workbook with SAP Interactive Excel ....................................................................................... 22
3.2 Interactive Database Connection......................................................................................................................... 23
3.3 Connecting SAP Interactive Excel to a Database ............................................................................................... 24
3.4 SAP Interactive Excel Settings ............................................................................................................................. 25
3.5 Data Matrix ............................................................................................................................................................. 27
Creation of a Data Matrix ..................................................................................................................... 29 3.5.1
Making Global Settings for a New Data Matrix ................................................................................... 34 3.5.2
Definition of Column and Rows of a Matrix Layout ............................................................................ 36 3.5.3
Specifying Single Values ..................................................................................................................... 40 3.5.4
Specifying Sets ..................................................................................................................................... 41 3.5.5
Specifying Hierarchies ......................................................................................................................... 43 3.5.6
Specifying Attributes ............................................................................................................................ 45 3.5.7
Changing Characteristic Values .......................................................................................................... 46 3.5.8
Determination of Values for Characteristics ...................................................................................... 47 3.5.9
Creation of Further Matrices ................................................................................................................ 51 3.5.10
Preparation for Data Entry ................................................................................................................... 52 3.5.11
Entry of Data in a Matrix ....................................................................................................................... 54 3.5.12
Deleting a Matrix ................................................................................................................................... 55 3.5.13
3.6
Saving of Financial Data to the Database ............................................................................................................ 56
3.7 Information about the Origin of Data ................................................................................................................... 57
3.8 Creating a Snapshot of a Worksheet or Workbook ............................................................................................ 59
4 Reporting with SAP Interactive Excel....................................................................................................... 60
4.1 Creation of Reports on the Basis of Interactive Data Matrices ......................................................................... 62
4.2 Reporting for Specific Data Categories ............................................................................................................... 63
4.3 Refreshing of Report Data .................................................................................................................................... 64
5 Matrix Examples ...........................................................................................................................................65
5.1 Data Reporting/Data Entry Matrix ....................................................................................................................... 65
5.2 Building Up a Matrix .............................................................................................................................................. 74
5.3 Changing a Matrix .................................................................................................................................................. 79
SAP
Interactive Excel 3.0
Table of Contents
CUSTOMER
© 2014 SAP AG. All rights reserv
ed.
5
6 Working with Structures ............................................................................................................................ 85
7 Pivot Tables ................................................................................................................................................... 87
7.1 Definition of a Pivot Table .................................................................................................................................... 89
7.2 Defining a Pivot Table ............................................................................................................................................ 91
8 Security ......................................................................................................................................................... 93
9 SAP Interactive Excel Converter ............................................................................................................... 94
10 Glossary ........................................................................................................................................................ 96