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
Mapping Source
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 Field
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 Selections
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 the InfoSet Query
Reporting Type
Modules for Calling InfoSet Query
Including the InfoSet Query in a Role
Starting the 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
Executing 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
Displaying User Group Directory
Displaying Query Directory
Display InfoSet Directory
Managing Queries
Displaying Query Information
Copying Queries
Renaming Queries
Deleting Queries
Comparing Queries
Executing Queries
Executing Queries Online
Displaying the 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 a List
Redisplaying Lists
Deleting Lists
Calling Other Reports
Calling Reports
Calling Report Histories
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
Hiding Columns
Showing Columns
Transferring All Characteristics
Convert
Print
Running a New Analysis
Exporting Data for EIS
Private File
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
List Line Output Options
Display Options for Fields
Headers and Footers
Graphics
Determining Sort Sequences
Output Options for Control Levels
Examples for 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 Sum Lists
Determining Output Options for Fields
Statistics
Generating Statistics
Calculating Sum Totals 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 Sequencer
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
Color
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
Query Reports
Enhancement SQUE0001: Private Storage of Data
Function Module EXIT_RSAQEXCE_001
Parameter PROGRAM
Parameter LIST_ID
Parameter LISTTEXT
Parameter DATATAB
Parameter LISTDESC
Example: Table LISTDESC
Example: Implementing EXIT_RSAQEXCE_001
Optimizing Access to Queries
Switching Access Optimization On/Off
Avoiding Problem Cases
Structural Changes in a Logical DB Background
Logical Databases with Different Node Types
Interactive Multiple-Line Basic Lists
Logical Database F1S