SAP Query
Overview
Creating and Executing a QuickView
Creating and Executing an InfoSet Query
Creating and Executing a Query
InfoSets
Selecting InfoSets for Processing
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
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
Releasing an InfoSet for Analysis with BI Tools
TransientProvider Derived from a Classic InfoSet
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 InfoSet 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 Companys 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
Administration
Managing User Groups
Displaying User Group Directories
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
Authorizations
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
Overview of Query Transports
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