Download SAP Query Reporting PDF

TitleSAP Query Reporting
File Size30.8 MB
Total Pages485
Table of Contents
                            SAP Query Reporting
Table of Contents
Copyright
About the Author
Acknowledgments
We Want to Hear from You!
Reader Services
Chapter 1.  Getting Started with the SAP R/3 Query Reporting Tools
	The SAP R/3 Query Reporting Tools
	How the SAP R/3 Query Tools Work
	Comparing the Query Tools to Decide Which to Use
	Things to Remember
Chapter 2.  One-Time Configuration for Query Tool Use
	Steps in Configuring the Query Tools
	Performing Maintenance on InfoSets
	Things to Remember
Chapter 3.  Creating Basic Reports with the SAP Query Tool
	The SAP Query Tool
	Creating a Basic List Query by Using the SAP Query Tool
	Reviewing the Options on Each of the Five Basic Screens
	Modifying an SAP Query
	Saving a Query
	Maintaining Queries
	Things to Remember
Chapter 4.  The Fundamentals of Reporting with the SAP Query Tool
	SAP Query Reporting in the Real World
	SAP Query Maintenance Functions
	Working on Your Existing SAP Queries
	Things to Remember
Chapter 5.  Basics of Using Reporting Selection Screens
	The Reporting Selection Screens
	Maximizing the Use of Selection Screens in SAP Query
	Understanding Output Options on the Selection Screen
	Things to Remember
Chapter 6.  Using Reporting Selection Screens: Advanced Skills
	Using Multiple Selection Buttons
	Using Variants
	Things to Remember
Chapter 7.  Creating Advanced Reports with the SAP Query Tool
	An Overview of the SAP Query Tool's Advanced Screens
	Using the Advanced Screens of the SAP Query Tool
	Things to Remember
Chapter 8.  Creating Extract Files and Interfaces with the SAP Query Tool
	Overview of Interface/Extract Files
	Creating a Fixed Positional Extract File by Using the SAP Query Tool
	Things to Remember
Chapter 9.  Creating Basic Calculated Fields with the SAP Query Tool
	Creating a Basic SAP Query for This Chapter
	Using a Simple Mathematical Formula to Create a Basic Calculated Field
	Using a Simple Condition to Create a Basic Calculated Field
	Using an Input Value to Create a Basic Calculated Field
	Things to Remember
Chapter 10.  Creating Advanced Calculated Fields with the SAP Query Tool
	Creating a Basic SAP Query for This Chapter
	Using Multiple Conditions to Create an Advanced Calculated Field
	Using Multiple Fields to Perform a Calculation in an Advanced Calculated Field
	Using a Calculated Field to Update a Variant in a Scheduled SAP Query
	Things to Remember
Chapter 11.  Inserting Pictures and Graphics in SAP Queries
	Using Symbols and Icons in an SAP Query
	Inserting Black-and-White Symbols in an SAP Query
	Inserting Black-and-White Symbols in an SAP Query by Using a Simple Condition
	Inserting a Color Icon in an SAP Query by Using a Simple Condition
	Inserting a Color Icon in an SAP Query Using Multiple Conditions with Two Operators
	Things to Remember
Chapter 12.  Creating Simple Statistics Lists with the SAP Query Tool
	Statistics Lists in the SAP Query Tool
	Creating a Statistics List with the SAP Query Tool
	Creating a Subtotaled Statistics List with the SAP Query Tool
	Things to Remember
Chapter 13.  Creating Advanced Statistics Lists with the SAP Query Tool
	Creating a Basic List for Reference by Using the SAP Query Tool
	Creating an Advanced Statistics List by Using the SAP Query Tool
	Things to Remember
Chapter 14.  Creating Ranked Lists with the SAP Query Tool
	What Are Ranked Lists?
	Creating a Ranked List by Using the SAP Query Tool
	Sample Uses of Ranked Lists in SAP R/3
	Things to Remember
Chapter 15.  HR and Payroll Reporting Options in the HCM Module
	The Reporting Tools in the HCM Module
	Reporting Options in SAP R/3 for the HCM Module
	Things to Remember
Chapter 16.  Special Considerations for Configuring HR and Payroll Reporting in the HCM Module
	Configuring InfoSets for the HCM Module
	Special HCM Configuration Maintenance Considerations
	Things to Remember
Chapter 17.  Special Considerations for HR and Payroll Reporting in the HCM Module
	Payroll Result Reporting with the SAP Query Tool
	Eliminating Duplicate-Line Reporting in the HCM Module
	Understanding Selection Period Fields on the Selection Screens of HCM Reports
	Auditing Query Execution
	Configuring HR Actions/Events to Improve Reporting Capabilities
	Things to Remember
Chapter 18.  Security Concepts in SAP R/3 Query-Based Reporting Tools
	Security for the SAP Query Tool
	Security for the InfoSet (Ad Hoc) Query and QuickViewer Tools
	Things to Remember
Chapter 19.  Creating Basic Reports with the InfoSet (Ad Hoc) Query Tool
	Creating a Basic Query with the Infoset (Ad Hoc) Query Tool
	The Options Available on the InfoSet (Ad Hoc) Query Tool Screen
	Modifying an InfoSet (Ad Hoc) Query
	Saving an InfoSet (Ad Hoc) Query
	Restrictions with the InfoSet (Ad Hoc) Query Tool
	Security Considerations for Using the InfoSet (Ad Hoc) Query Tool
	Things to Remember
Chapter 20.  Creating QuickViews by Using QuickViewer
	Understanding QuickViewer
	Creating a QuickView by Using QuickViewer
	The Options Available on the QuickViewer Screen
	Modifying a QuickView
	Using QuickViewer in Layout Mode
	Converting a QuickView to a SAP Query
	QuickViewer Security Considerations
	Things to Remember
Chapter 21.  SAP Reporting with Microsoft Excel
	Using SAP Reporting with Microsoft Office
	Maximizing SAP Reports by Using Microsoft Excel
	The Fictional SAP Report for a Basic Microsoft Excel Columnar Chart
	The Fictional SAP Report for a Basic Microsoft Excel Pie Chart
	Making Microsoft Excel Pivot Tables Using SAP Report Data
	Things to Remember
Chapter 22.  SAP Query Reporting with Microsoft Word and Outlook
	Maximizing SAP Reports by Using Word
	Maximizing Reporting Options by Using Word and Outlook
	Things to Remember
Chapter 23.  SAP Reporting with Microsoft Access
	Maximizing SAP Reports by Using Access
	Maximizing SAP and Third-Party Solution Reports by Using Access
	Things to Remember
Appendix A.  Quick Reference Guide
	Basics Of Sap R/3 Query-Based Reporting
	Creating A Basic List Query By Using The Sap Query Tool
	Creating A Statistics List With The Sap Query Tool
	Creating A Ranked List By Using The Sap Query Tool
	Creating A Quickview With Quickviewer
	Report Distribution Strategies
Index
	SYMBOL
	A
	B
	C
	D
	E
	F
	G
	H
	I
	L
	M
	N
	O
	P
	Q
	R
	S
	T
	U
	V
	W
                        
Document Text Contents
Page 1

SAP Query Reporting

By Danielle Larocca Signorile

...............................................

Publisher: Sams

Pub Date: July 24, 2006

Print ISBN-10: 0-672-32902-6

Print ISBN-13: 978-0-672-32902-9

Pages: 336



Table of Contents | Index

SAP Query Reporting

is everything an SAP user needs to know to create your own reports in SAP using Query tools, no
programming required! Designed as a hands-on learning aid, you will be able to follow along and
perform each new skill learned on your own SAP system. The book's tutorial style, step-by-step
instruction will teach you everything you need to know to use the SAP Query tools, including its
configuration, advanced usage, and integration to Microsoft. Additionally the book gives best
business practice recommendations for the technology and internal business use of the tools. Learn
to:

Understand query security, table reads, and table joins

Perform basic and advanced calculations

Incorporate pictures and graphics into reports

Configure shortcuts and tran codes, schedule jobs and email PDFs

Utilize SAP Reporting with Microsoft Office applications

SAP Query Reporting

By Danielle Larocca Signorile

...............................................

Publisher: Sams

Pub Date: July 24, 2006

Print ISBN-10: 0-672-32902-6

Print ISBN-13: 978-0-672-32902-9

Pages: 336



Table of Contents | Index

SAP Query Reporting

is everything an SAP user needs to know to create your own reports in SAP using Query tools, no
programming required! Designed as a hands-on learning aid, you will be able to follow along and
perform each new skill learned on your own SAP system. The book's tutorial style, step-by-step
instruction will teach you everything you need to know to use the SAP Query tools, including its
configuration, advanced usage, and integration to Microsoft. Additionally the book gives best
business practice recommendations for the technology and internal business use of the tools. Learn
to:

Understand query security, table reads, and table joins

Perform basic and advanced calculations

Incorporate pictures and graphics into reports

Configure shortcuts and tran codes, schedule jobs and email PDFs

Utilize SAP Reporting with Microsoft Office applications

Page 2

SAP Query Reporting

By Danielle Larocca Signorile

...............................................

Publisher: Sams

Pub Date: July 24, 2006

Print ISBN-10: 0-672-32902-6

Print ISBN-13: 978-0-672-32902-9

Pages: 336



Table of Contents | Index

Copyright

About the Author

Acknowledgments

We Want to Hear from You!

Reader Services

Chapter 1. Getting Started with the SAP R/3 Query Reporting Tools

The SAP R/3 Query Reporting Tools

How the SAP R/3 Query Tools Work

Comparing the Query Tools to Decide Which to Use

Things to Remember

Chapter 2. One-Time Configuration for Query Tool Use

Steps in Configuring the Query Tools

Performing Maintenance on InfoSets

Things to Remember

Chapter 3. Creating Basic Reports with the SAP Query Tool

The SAP Query Tool

Creating a Basic List Query by Using the SAP Query Tool

Reviewing the Options on Each of the Five Basic Screens

Modifying an SAP Query

Saving a Query

Maintaining Queries

Things to Remember

Chapter 4. The Fundamentals of Reporting with the SAP Query Tool

SAP Query Reporting in the Real World

SAP Query Maintenance Functions

Working on Your Existing SAP Queries

Things to Remember

Chapter 5. Basics of Using Reporting Selection Screens

The Reporting Selection Screens

Maximizing the Use of Selection Screens in SAP Query

Understanding Output Options on the Selection Screen

Things to Remember

Page 242

If you select this field, the percentage of the field of the sum total is output.

Len (Length)

When you select this check box, the field is output in the list with its standard output length. You can
alter the field width (length) in this field to improve the layout of a list.

Rnd (Rounding Factor)

You use this field to specify the number of decimal places to be used when rounding. For example, if
you specify 3, the resulting amounts have three places before the decimal point (that is, round to the

nearest thousand).

Init (Unit of Measurement)

This field appears for any field tied to a unit of measurement (for example, currency, weight).

Text

If you select this field, the values of the field specified on the left are used to generate the text for
SAP Business Graphics. If you select several fields, their values are used in the sequence in which
they occur. SAP Business Graphics processes up to 30 characters of text per value.

Page 243

Creating a Subtotaled Statistics List with the SAP Query
Tool

To create a subtotaled statistics list report with the SAP Query tool, follow these steps:

1. Navigate to the Maintain Queries Initial screen by using transaction code /nSQ01.

2. In the Query field, enter a name for the query you are creating (for example, DLS_Exercise_12B,

where DLS is your initials) and then click the Create button.

3. When the InfoSets of User Group ZTEST window appears, listing all the available InfoSets (that
is, data sources) for your query group, select the ZTEST InfoSet and then press Enter. The
Create Query Title Format screen appears. Enter a title and then click the Save button on the
toolbar.

4. To navigate to the next screen in the SAP query creation process, click the Next Screen (white
navigational arrow) button on the Application toolbar. The Select Field Groups screen appears,
listing all the field groups available within the InfoSet. Place a check mark next to each field
group from which you want to include fields in your report (I selected them all). Click the Next
Screen button on the Application toolbar.

5. When the Select Fields screen appears, listing all the available fields within the selected field
groups, place a check mark next to each field that you want to include in your report. You can
use the Page Up and Page Down arrows to navigate between all the fields. For this example,
include the following fields:

Airline Carrier ID

Arrival City

Airfare

Text: Flight Class

6. Click the Next Screen button on the application toolbar to continue.

7. When the Selections screen appears, listing all the fields you selected on the Select Fields
screen, add any of the fields to the selection screen that will be presented when you execute
your report. You can add any fields you want to the selection screen by placing a check mark
next to each field. For this example I have not added any.

Page 484

Index

[SYMBOL] [A] [B] [C] [D] [E] [F] [G] [H] [I] [L] [M] [N] [O] [P] [Q] [R] [S] [T] [U] [V] [W]

Variant Attributes screen

variants

advanced functions for

creating for SAP queries 2nd

editing for SAP queries 2nd

executing reports with 2nd

SAP reports

saving SAP queries with 2nd

using calculated fields to update variants in schedule SAP queries

viewing

file data in Notepad

InfoSet fields

Page 485

Index

[SYMBOL] [A] [B] [C] [D] [E] [F] [G] [H] [I] [L] [M] [N] [O] [P] [Q] [R] [S] [T] [U] [V] [W]

wizards

Chart Wizard

Import Spreadsheet Wizard

Report Wizard 2nd

Word (Microsoft)

form letters, creating from SAP data 2nd

mail merge Outlook emails, creating from SAP data

mailing envelopes, creating from SAP data

mailing labels, creating from SAP data

Word Processing option

reporting selection screens

SAP Query tool

Similer Documents