Graphical Query Tools

5-ABAP.1

This is PricewaterhouseCoopers PROPRIETARY MATERIAL (hereafter, the Material) intended for internal use only.

You may not rent, lease or distribute the Material to clients or other third parties, but you may transfer the Material to

other employees of PricewaterhouseCoopers.

Graphical Query Tools

5-ABAP.2

This is PricewaterhouseCoopers PROPRIETARY MATERIAL (hereafter, the Material) intended for internal use only.

You may not rent, lease or distribute the Material to clients or other third parties, but you may transfer the Material to

other employees of PricewaterhouseCoopers.

List of Topics

• QuickViewer

• Query Painter

Graphical Query Tools

5-ABAP.3

This is PricewaterhouseCoopers PROPRIETARY MATERIAL (hereafter, the Material) intended for internal use only.

You may not rent, lease or distribute the Material to clients or other third parties, but you may transfer the Material to

other employees of PricewaterhouseCoopers.

Module Map

•

Objectives

• QuickViewer

• Query Painter

Graphical Query Tools

5-ABAP.4

This is PricewaterhouseCoopers PROPRIETARY MATERIAL (hereafter, the Material) intended for internal use only.

You may not rent, lease or distribute the Material to clients or other third parties, but you may transfer the Material to

other employees of PricewaterhouseCoopers.

Learning Objectives

• Use the QuickViewer tool to create a Query

• Create a Query using Query Painter

Graphical Query Tools

5-ABAP.5

This is PricewaterhouseCoopers PROPRIETARY MATERIAL (hereafter, the Material) intended for internal use only.

You may not rent, lease or distribute the Material to clients or other third parties, but you may transfer the Material to

other employees of PricewaterhouseCoopers.

Module Map

• Objectives

•

QuickViewer

• Query Painter

Graphical Query Tools

5-ABAP.6

This is PricewaterhouseCoopers PROPRIETARY MATERIAL (hereafter, the Material) intended for internal use only.

You may not rent, lease or distribute the Material to clients or other third parties, but you may transfer the Material to

other employees of PricewaterhouseCoopers.

Data source

Table
Database view
Table join
Functional area
Logical database

Structure list

Basis or
layout mode



Field sequence



Sort



Selections



...

Execute

Save list
Interface to Word, ABC analysis
representation in the ALV Control
and so on

QuickViewer: Principle

Graphical Query Tools

5-ABAP.7

This is PricewaterhouseCoopers PROPRIETARY MATERIAL (hereafter, the Material) intended for internal use only.

You may not rent, lease or distribute the Material to clients or other third parties, but you may transfer the Material to

other employees of PricewaterhouseCoopers.

Welcome to the

QuickViewer

1. Please enter your name
and select Create
2. Choose a title and
comments.
3. Name a

data source

. It

can be a table, a logical
database, a join, or a
functional area of the SAP
query.
4. Choose layout mode to
design the QuickView
graphics Choose basic
mode to directly export the
selected fields in the report

QuickViewer: Initial Access

• Start the QuickViewer with transaction SQVI

Graphical Query Tools

5-ABAP.8

This is PricewaterhouseCoopers PROPRIETARY MATERIAL (hereafter, the Material) intended for internal use only.

You may not rent, lease or distribute the Material to clients or other third parties, but you may transfer the Material to

other employees of PricewaterhouseCoopers.

Create QuickView DEMO: Determine Data Source

Example in BC405

DEMO

QuickView

Title

Comments

1. Data source:

Join via tables SCARR and SPFLI

Basis...

Layout m...

Table join

Creating a QuickView

Graphical Query Tools

5-ABAP.9

This is PricewaterhouseCoopers PROPRIETARY MATERIAL (hereafter, the Material) intended for internal use only.

You may not rent, lease or distribute the Material to clients or other third parties, but you may transfer the Material to

other employees of PricewaterhouseCoopers.

Short ID...
Code...
Country code
Departure city
Departure airport
Country code
Arrival city
...

SCARR

Short ID...
Name of a ...
Local
currency ...
URL ...

SPFLI

INNER or LEFT OUTER link

Join Definition

Graphical Query Tools

5-ABAP.10

This is PricewaterhouseCoopers PROPRIETARY MATERIAL (hereafter, the Material) intended for internal use only.

You may not rent, lease or distribute the Material to clients or other third parties, but you may transfer the Material to

other employees of PricewaterhouseCoopers.

Data source

QuickView

Setup

Online Documentation

Information

Basis Mode: Principle

Structure

Graphical Query Tools

5-ABAP.11

This is PricewaterhouseCoopers PROPRIETARY MATERIAL (hereafter, the Material) intended for internal use only.

You may not rent, lease or distribute the Material to clients or other third parties, but you may transfer the Material to

other employees of PricewaterhouseCoopers.

List field selectionSort sequence

Selection fields

Data source

List fields

Example in BC405

DEMO

QuickView

Title

Comments

Join via tables SCARR and SPFLI

Structuring a QuickView in the

Basis Mode

Graphical Query Tools

5-ABAP.12

This is PricewaterhouseCoopers PROPRIETARY MATERIAL (hereafter, the Material) intended for internal use only.

You may not rent, lease or distribute the Material to clients or other third parties, but you may transfer the Material to

other employees of PricewaterhouseCoopers.

Using the QuickView

• User ad hoc reports

• Each user defines their own QuickViews which only

they can display

• Uses existing data

• No administrative effort (user group, functional area)

• QuickView can be converted to a SAP query

• Interface to internal (EIS, ABC, ALV) and external

applications

• Less functionality than SAP Query

• No transports

Graphical Query Tools

5-ABAP.13

This is PricewaterhouseCoopers PROPRIETARY MATERIAL (hereafter, the Material) intended for internal use only.

You may not rent, lease or distribute the Material to clients or other third parties, but you may transfer the Material to

other employees of PricewaterhouseCoopers.

Module Map

• Objectives

• QuickViewer

•

Query Painter

Graphical Query Tools

5-ABAP.14

This is PricewaterhouseCoopers PROPRIETARY MATERIAL (hereafter, the Material) intended for internal use only.

You may not rent, lease or distribute the Material to clients or other third parties, but you may transfer the Material to

other employees of PricewaterhouseCoopers.

Describe list

. . .

Output

options

Line 3

Output

options

Field

Title

Format

Classic

Classic

Query Painter

Query Painter

Programs and Query

Graphical Query Tools

5-ABAP.15

This is PricewaterhouseCoopers PROPRIETARY MATERIAL (hereafter, the Material) intended for internal use only.

You may not rent, lease or distribute the Material to clients or other third parties, but you may transfer the Material to

other employees of PricewaterhouseCoopers.

Layout of list:
Arrangement of fields

Sorting, summation
Output options (formats, masks, output lengths ...)
Texts (headings)

Layout of list:
Arrangement of fields

Sorting, summation
Output options (formats, masks, output lengths ...)
Texts (headings)

Type of list

Local fields

Field Selection

Basic list
(optional)
(sorting, summation)

Statistics
(optional, poss. multiple)

Functional
groups

Ranked list
(optional, poss. multiple)

Functiona
l area

Defining a Query

Graphical Query Tools

5-ABAP.16

This is PricewaterhouseCoopers PROPRIETARY MATERIAL (hereafter, the Material) intended for internal use only.

You may not rent, lease or distribute the Material to clients or other third parties, but you may transfer the Material to

other employees of PricewaterhouseCoopers.

Selecting the Work Area and

Functional Area

• Queries are created either in the standard area

or the global area. A query area covers a set of
query objects that are internally complete and
consistent - this means objects with the same
name but with a different meaning can exist in
the various query areas. The global and
standard areas have separate namespaces.

Graphical Query Tools

5-ABAP.17

This is PricewaterhouseCoopers PROPRIETARY MATERIAL (hereafter, the Material) intended for internal use only.

You may not rent, lease or distribute the Material to clients or other third parties, but you may transfer the Material to

other employees of PricewaterhouseCoopers.

Help topics

Structuring

an SAP Query

Data source

Application

information

Basic List: Layout Mode

Graphical Query Tools

5-ABAP.18

This is PricewaterhouseCoopers PROPRIETARY MATERIAL (hereafter, the Material) intended for internal use only.

You may not rent, lease or distribute the Material to clients or other third parties, but you may transfer the Material to

other employees of PricewaterhouseCoopers.

Designing a Basic List

• Steps for designing the basic list

Graphical Query Tools

5-ABAP.19

This is PricewaterhouseCoopers PROPRIETARY MATERIAL (hereafter, the Material) intended for internal use only.

You may not rent, lease or distribute the Material to clients or other third parties, but you may transfer the Material to

other employees of PricewaterhouseCoopers.

Data
fields

Timetable

SPFLI

List field

5
5

Control level

Flight number

Sort direction

Help subjects: Selection fields; Output

options in list: Width of list .....

Arrival time

Short description

Departure city

Arrival city

Flight conn. code

ID

No

Departure cityArrival city

SUM...

Grand total ...

Ascending
Descending

Control level header

Distance

AA

001
7

NEW
YORK

SAN FRANCISCO

Flight number 0017

Flight conn. code

Basic List: Control Level

Processing

Graphical Query Tools

5-ABAP.20

This is PricewaterhouseCoopers PROPRIETARY MATERIAL (hereafter, the Material) intended for internal use only.

You may not rent, lease or distribute the Material to clients or other third parties, but you may transfer the Material to

other employees of PricewaterhouseCoopers.

ALV Grid Control

Tota

l

Drilldown function

File storage, private storage

Graphics

Spreadsheets

Report/report interface

List overview

Table display

Selections

ABC analysis, EIS

Word processing

Table Control

Interactive Functions

Graphical Query Tools

5-ABAP.21

This is PricewaterhouseCoopers PROPRIETARY MATERIAL (hereafter, the Material) intended for internal use only.

You may not rent, lease or distribute the Material to clients or other third parties, but you may transfer the Material to

other employees of PricewaterhouseCoopers.

Display flight data

Change flight data

+

Programs

Queries

DEMO: Read ...

DEMO: Variant ...

One-line basic list ...

Programs for flight data model

Area menu

Query list

List

Save

Saving Lists

Graphical Query Tools

5-ABAP.22

This is PricewaterhouseCoopers PROPRIETARY MATERIAL (hereafter, the Material) intended for internal use only.

You may not rent, lease or distribute the Material to clients or other third parties, but you may transfer the Material to

other employees of PricewaterhouseCoopers.

Functional areas must exist

Local fields can be added

Programs can be linked (BBS)

Administration of query required
(user groups, functional areas)

The dataset is limited to the
data source

Only basic list

BBS not available

No administrative effort, since
each user can only access their
own QuickViews

Simple, fast evaluations
possible

SAP Query

QuickView

Transport possible

Transport not possible

Several partial lists
possible
(statistics, ranked lists)

Comparison: SAP Query -

QuickView

Graphical Query Tools

5-ABAP.23

This is PricewaterhouseCoopers PROPRIETARY MATERIAL (hereafter, the Material) intended for internal use only.

You may not rent, lease or distribute the Material to clients or other third parties, but you may transfer the Material to

other employees of PricewaterhouseCoopers.

Module Review

• Objectives

• QuickViewer

• Query Painter