Tools
Calculating and Updating the Effective Interest Rate
SAP Query
Overview
SAP Query Components
Queries Component
InfoSets Component
User Groups Component
SAP Query User Groups
Translation/Query Component
Query Areas
Transport
Authorizations
Release Notes
Tools for Queries
InfoSet Query
Calling the InfoSet Query
Rights to Access InfoSet Query
Reporting Type
Modules for Calling the InfoSet Query
Including the InfoSet Query in Roles
Starting InfoSet Query
Maintaining Queries
Query Area for InfoSet Query
Display Variants when Starting the InfoSet Query
Displaying InfoSets
Editing the InfoSet Display
Selection Display
Output List Display
Formatting the Output
Editing Queries
Creating New Queries
Loading Queries
Deleting Queries
Saving Queries
Saving a Query
Change InfoSet
Reusing Queries
Settings
Logging
Activating Logging
Analyzing Log Data
Deleting Log Data
HR in InfoSet Query
Overview of Functions
Switch Object Selection On/Off
Selection
Make Selection
Edit Selected Set of Objects
Restricting the Reporting Set
Set Operations
Execute Set Operations
Output
Output Data for Selected Objects
Process Selection Result in General Reporting
HR InfoSets for InfoSet Query
Queries
Functions for Managing Queries
Selecting Queries for Processing
Displaying Directories
Display User Group Directory
Displaying the Query Directory
Display InfoSet Directory
Managing Queries
Displaying Query Information
Copying Queries
Rename Queries
Deleting Queries
Adjusting Queries
Executing queries
Executing Queries Online
Display List of Results
Printing List of Results
Variants
Structure of Generated Programs
Executing Queries in the Background
Improving Response Times
Interactive Functions for ABAP Lists
List Overview
Selections
Drilldown Functionality for Multiple-Line Basic Lists
Displaying Totals in Basic Lists
Compressing Statistics
Displaying Results as a Table
Displaying Results in the SAP List Viewer
Saving and Redisplaying Lists
Saving Lists
Redisplaying Lists
Deleting Lists
Calling Other Reports
Call report
Calling the Report History
Interactive Functions for Further List Processing
Common Principles when Passing Lists for Further Processing
Storing Data as a Local File
Table Calculations
Displaying Data as a Graphic
Processing Text
ABC Analysis
Calling the ABC Analysis
Hide columns
Show columns
Transferring All Characteristics
Convert
Print
Running a New Analysis
Exporting Data for EIS
Private Folder
Additional Function Pool
Direct Interaction
Creating and Changing Queries
Creating Queries
Field Selection
Assigning Title, Format, and Notes
Selecting Fields for Processing
Assigning Short Names
Defining Local Fields
Field Definitions
Calculation Formulas
Example: Local Fields
Extending the Selection Criteria
Basic Lists
Creating Basic Lists with the Query Painter
Using the Layout Designer to Create Basic Lists
Defining a Single-Line Basic List
Determining the Structure of Lines
Options for Line Layout: Totals and Counting
Defining Output-Options for Rows
Display-Options for Fields
Headers and Footers
Graphics
Setting the Sort Sequence
Output Options for Control Levels
Examples on How to Arrange the Display: Example 1
Examples for How to Arrange the Display: Example 2
Defining Multiple-Line Basic Lists
Setting Sorting and Subtotals
Changing Control Level Texts
Defining Totals Lists
Setting Output Positions of Fields
Statistics
Generating Statistics
Totaling and Converting
Sorting Statistics
Sorting: Example 1
Sorting: Example 2
Defining Headers in Statistics
Analyzing Conversion Errors
Ranked Lists
Creating Ranked Lists
Changing Queries
Maintaining Queries in Human Resources Application (HR)
Line Groups
Evaluations According to a Company’s Organizational Structure
QuickViewer
Functions for Managing QuickViews
Creating QuickViews
Selecting a Data Source
Executing QuickViews
Output Options
Converting QuickViews to Queries
Basis Mode
Selecting List Fields
Determining the Sort Sequence
Selecting Selection Fields
Example
Layout Mode/The Graphical Query Painter
Selecting List Fields
Selecting Selection Fields
List Display Options
Headers and Footers
List Width (Ruler)
List Line Output Options
Colors
Column Headers
Separators
Further Options
Field Display Options
Positioning and Sizing
Colors
Totaling and Counting
Screen Templates
Currency Fields and Quantity Fields
Further Options
Output Options for Control Levels
Sorting
Control Level Text
Subtotals
Counting Fields
Further Options
Toolbars
InfoSets
Selecting InfoSets for Processing
Displaying the InfoSet Directory
Directory of Queries for an InfoSet
Query Directory Functions
Saved Lists Directory
Managing InfoSets
Displaying InfoSets
Copying InfoSets
Renaming InfoSets
Deleting InfoSets
Saving InfoSets
Generating InfoSets
Checking InfoSets
Adjusting InfoSets
Assigning InfoSets to Roles / User Groups
Creating and Changing InfoSets
Creating InfoSets
Assigning Data Sources
Defining Table Joins with the Help of Graphics
Defining Table Joins without the Help of Graphics
Reading tables directly
Using Programs to Retrieve Data
Sequential datasets
Special Features
Code for Record Processing
Displaying InfoSets
Text Fields
Defining Field Groups
Assigning Fields to a Field Group
Deleting Field Groups/Fields from Field Groups
Displaying a List of Assigned Fields
Obtaining Additional Information
Assigning Additional Tables
Assigning Table Fields to a Field Group
Displaying a List of Assigned Additional Tables
Deleting the Assignment of Additional Tables
Creating Additional Fields
Assigning Additional Fields to a Field Group
Displaying a List of Existing Additional Fields
Deleting Additional Fields
Creating Additional Structures
Assigning Structure Fields to Field Groups
Deleting the Assignment of Additional Structures
Creating Extra Selection Fields
Creating Parameters
Creating Selection Criteria
Displaying a List of Existing Parameters
Further Code
DATA Code
START Code
END Code
GET/GET LATE Code
TOP-OF-PAGE Code
Application-Specific Enhancements
InfoSets in the HR Application
HR Logical Databases
Administration
Functions for Managing User Groups
Displaying User Group Directories
Managing User Groups
Displaying User Groups
Creating User Groups
Assigning Users and InfoSets
Assigning Users to User Groups
Assigning InfoSets
Copying User Groups
Renaming User Groups
Deleting User Groups
Changing User Groups
Query Areas
Language Comparison
General Language Comparison Procedure
Language Comparison of an InfoSet
Language Comparison of a Query
Language Comparison for User Groups
Transporting Query Objects
Transporting Global Area Objects
Transporting Standard Area Objects
General Transport Description
Generating Transport Datasets
Transport Type
Transporting a User Group
Transporting InfoSets
Transporting a Query
Reading Transport Datasets
Managing Transport Datasets
Transporting Objects Between Query Areas
Maintaining the Additional Function Pool
Appendix
Overview of SAP Query Functions
Queries
Enhancement SQUE0001: Private Folder
Function Module EXIT_RSAQEXCE_001
PROGRAM Parameter
LIST_ID Parameter
LISTTEXT Parameter
DATATAB parameter
LISTDESC Parameter
Example: Table LISTDESC
Example: Implementing EXIT_RSAQEXCE_001
Optimizing Access to Queries
Switch Access Optimization On/Off
Avoiding Problem Cases
Structural Changes in a Logical DB
Logical Databases with Different Node Types
Interactive Multiple-Line Basic Lists
Logical Database F1S
Using SAP Query for the Transaction Manager
InfoSets for the Transaction Manager
Standard Queries for the Transaction Manager
CA - Drilldown Reporting
Introduction to Drilldown Reporting
Functional Overview
Architecture of Drilldown Reporting
Basic Concepts of Drilldown Reporting
Basic Reports and Form Reports
Basic Report
Report using a Form
Report
Creating/Changing a Report
Functions for Defining Reports
Choosing Key Figures
Choosing Characteristics
Characteristic Values
Choose Hierarchy
Hierarchy Node
Replacing Variables
Output Type
Setting the Output Type
Defining HTML Templates
Creating an HTML Template
Creating an HTML Template: Special Information
Report Assignment
Selecting Data Step by Step
Settings
Number Format
Variables
Variables for Characteristic Values
Variables for Hierarchies and Hierarchy Nodes
Variables for Texts
Variables for Formulas
Defining Global Variables
User Exits: Global Variables
Example: Use of Variables
Replacing Variables
Maintaining Variables
Characteristic Hierarchies
Entering and Using a Hierarchy Node
Hierarchy Display
Functions for Editing Hierarchies
Currencies and Units of Measure
Example: Inverse Rates
Overview: Report/Report Interface
How to Use the Report/Report Interface
Example: Report/Report Interface
Report/Report Interface: Transformation of Selection Data
Forms
Overview: Forms
Creating/Changing a Form
Example: Creating a Form (CO-PA)
Example: Creating a Form (EC-EIS/CO-PC)
Example: Creating a Form (FI)
Defining Elements
General Data Selection
Drilldown List and Defining Percentage Shares
Form Settings
Executing a Report
Executing Reports with "Selection Options"
Creating Variants and Variant Groups
Report Information
Report and Cell Parameters
Key Figure Information
Report Texts
Writing Comments
Highlight Comment
Display Document
Maintain Header
Maintain Footer
Layout Display
Function Levels for Different Users
How to Process Report Lists
Functions for Report Lists
Navigation
Report List
Drilldown List
Choose next level
Other characteristic
-> Next level
<- Go to previous level
Period screen
Detail List
Initial list (Report List)
Scrolling Functions for Report Lists
First Column
Previous Column
Next Column
Last Column
Previous Page
Next Page
Other Characteristic Value
Hierarchy
Expand
Expand to level
Expand all
Collapse
Set focus
Undo focus
Choose Hierarchy
Hierarchy Display
Report/Report Interface
Hide Characteristic
Sort Characteristics
Attributes
Line Items
Display Master Data
Find string
Hotspots on the Report List
Example: Navigating Using Hotspots
Navigation in Graphical Reports
Defining Display Conditions
Function Levels for Different Users
Creating a Ranking List
Create Condition
Processing Conditions
Overview: Exception Reporting
Using Exceptions
Create Exception
Editing Exceptions
Analysis Functions
Functions Available on Report Lists
Number Format
Currency
Characteristic Display
Totals row
Undo totals row
Totals rows...
Format Display On/Off
Cumulative Display On/Off
Zero Display On/Off
Column(s) On/Off
Sort Columns
Percentage/Absolute
Maintain Footer
Maintain Header
Sort Ascending
Sort Descending
Undo All Settings
Form Settings
Saving, Printing, Exporting, Sending, Graphics
Save
Freeze data
Save structure
Freezing Report Data in the Background Using Varia
Printing Reports
Printing from the SAP System
Example: Mass Print Drilldown List
Printing from Word for Windows
Printing Graphics
Print Setup
Printing Reports with Characteristic Hierarchies
Printing in the Background Using Variants
Setting the Print Parameters
Sample Printout
Print Settings
Print row by row
Print Preview
Format Display On/Off
Maintain Footer
Maintain Header
Page break
Mass print settings
Optimal / set
Other settings...
Column(s) On/Off
Sort Columns
Set to default
Set column width
SAP Title Page On/Off
Maintain Title Page
Underscore
Number format
Exporting Reports
Transferring Reports to XXL
Transfer Page to XXL
Save as File
Transfer to MS Word
Graphic to Word On/Off
Copy to Report Portfolio
Send
Graphics
Optimizing Performance
Summarization Levels
Example: Optimizing Performance
Reorganization and Conversion
Drilldown Reporting: Link to the Transaction Manager
Characteristics and Key Figures
Performance Functions for Reporting
Setting Parameters for Buffer Tables
Reorganizing Business Partner Texts
Reorganizing Risk Key Figures
Reorganizing Risk Key Figures in Evaluation Currency