SAP Library - SAP Query (BC-SRV-QUE)

SAP Query (BC-SRV-QUE)

Maintaining Queries

Starting InfoSet Query

InfoSet Display

Editing the InfoSet Display

Selection Display

Output List Display

Formatting the Output

Reusing Queries

Creating New Queries

Loading Queries

Deleting Queries

Saving Queries

Saving a Query

Change InfoSet

Settings

Logging

Activating Logging

Analyzing Log Data

Deleting Log Data

Calling the InfoSet Query

Rights to Access InfoSet Query

Type of Reporting

Modules for Calling the InfoSet Query

Including InfoSet Query in Roles

HR in InfoSet Query

Switch Object Selection On/Off

Overview of Functions

Selection

Make Selection

Edit Selected Set of Objects

Restrict 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

List of Components

Groups of Query Users

Maintaining Queries

Maintaining User Groups

Maintaining InfoSets

Query Areas

Transports

Language Comparison

SAP Query Authorizations

Release Notes: Changes to SAP Query

Application

Functions for Managing Queries

Choosing a Query for Execution or Maintenance

Displaying Directories

User Group Directory

Directory of Queries

InfoSet Directory

Managing Queries

Displaying Queries

Copying Queries

Renaming Queries

Deleting Queries

Comparing Queries

Executing Queries

Executing Queries Online

Executing Queries in the Background

Improving Response Times

Interactive List Display Functions

Saving and Redisplaying Lists

Calling Other Reports

Interactive Functions for Further List Processing

Common Principles when Passing Lists for Further Processing

Download to File

Table Calculation

Graphics

Word Processing

ABC Analysis

EIS

Private File

Additional Function Pool

Direct Interaction

Creating and Changing Queries

Creating Basic Lists with the Query Painter

Creating Queries

Selecting Fields

Assigning Title, Format, and Notes

Selecting Fields for Processing

Assigning Short Names

Defining Local Fields

Extending the Selection Criteria

Defining Basic Lists

Defining a Single-Line Basic List

Defining the Line Structure

Defining Output Options for Each Line

Defining Output Options for Each Field

Changing Headers

Graphics

Sorting

Output Options for Control Levels

Defining Multiple Line Basic Lists

Sorting and Subtotals

Changing Control Level Texts

Totals Lists

Output Positions of Fields

Defining Statistics

Generating Statistics

Sorting Statistics

Defining Headers in Statistics

Error Analysis with Conversion Errors

Defining Ranked Lists

What are Ranked Lists?

Creating Ranked Lists

Changing Queries

Maintaining Queries in the Human Resources Application (HR)

Line Groups

Evaluations According to a Company’s Organizational Structure

System Administration

Managing InfoSets

Selecting InfoSets for Processing

Displaying the InfoSet Directory

Directory of Queries for an InfoSet

Query Directory Functions

Saved Lists Directory

Maintaining InfoSets

Displaying InfoSets

Copying InfoSets

Renaming InfoSets

Deleting InfoSets

Saving InfoSets

Generating InfoSets

Assigning InfoSets to User Groups

Checking InfoSets

Adjusting InfoSets

Creating and Changing InfoSets

Creating InfoSets

Assigning Data Sources

InfoSet Display

Text Fields

Definition of 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

Creating InfoSets without an Underlying Logical Database

Graphical Table Join Definition

Definition of a Table-Join without Graphics

Direct Read

Sequential Datasets

Retrieving Data with Programs

Special Features

Code for Record Processing

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

Maintaining the Additional Function Pool

Transporting Query Objects

Transporting Global Area Objects

Transporting Standard Area Objects

General Transport Description

Generating Transport Datasets

Transport Types

Transporting a User Group

Transporting InfoSets

Transporting a Query

Reading Transport Datasets

Managing Transport Datasets

Transporting Objects Between Query Areas

Language Comparison

General Language Comparison Procedure

Language Comparison of an InfoSet

Language Comparison of a Query

Language Comparison for User Groups

Appendix

Overview of SAP Query Functions

Queries

Enhancement SQUE0001: Private File

Example

Access Optimization in Queries

InfoSets and Structural Changes in a Logical Database

Logical Databases with Different Node Types

Interactive Multiple-Line Basic Lists

Logical Database F1S

Functions for Managing QuickViews

Creating QuickViews

Selecting a Data Source

Executing QuickViews

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