Language

🇺🇸 English

Publisher SAP PRESS

Year / Edition 2011 / 1

Pages 402

Authors Stephan Kaleske

SAP Query Reporting—Practical Guide

There's something to be said for reliable standbys—and SAP Query is a great reason why. Learn all about this classic SAP ERP tool and what it can do. From the basic principles of query reporting to query administration, this is both a comprehensive and a practical guide. And don't forget the bonus content: 100 immediately usable queries available for download.

Provides step-by-step instructions for using SAP Query
Covers relevant content for all SAP ERP components
Includes 100 ready-to-use queries

You'll learn about:

Basic Principles of Query Reporting:
Learn about the relationships between QuickViewer, user groups, the InfoSet, and SAP Query.This book explains how to localize tables and which query utilities support you in your work.
All Major Query Features:
Discover everything you need to know about selection and layout variants, drilldown functions, icons, ABC analyses, and much more.
Designing User-Friendly Reports:
Master challenging reporting requirements, including ABAP coding. Utilize ranked lists and statistics, Microsoft Excel integration, and much more.
Query Administration:
How do you transport queries? How do you improve performance? What do you need to consider with regard to authorizations? Here, you find the answers to these questions and others.

Key Highlights:

SAP tables and table links
QuickViewer
InfoSet
Selection and layout variants
Traffic light icons, drilldown, graphics, and ABC analyses
Statistics and ranked lists
ABAP fundamentals
Integration with Microsoft Excel
Transport system
Data retrieval and function modules
Authorizations and transaction creation

View Full Table of Contents

Preface
Introduction
PART I Introduction to SAP Query
1 Introduction to SAP ERP Reporting
- 1.1 ABAP Report Generators
- 1.2 Query Reporting Tools
- 1.3 Comparing Analysis Tools: SAP Query and SAP NetWeaver BW
- 1.4 Cumulated Analyses with Multilevel Hierarchies
  - 1.4.1 Summarization Hierarchies
  - 1.4.2 Report Painter
  - 1.4.3 Drilldown Reporting
- 1.5 Using Standard Reports
  - 1.5.1 SAP Area Menus
  - 1.5.2 Finding a Report in the SAP Menu
  - 1.5.3 Searching the Menu for Standard Reports
  - 1.5.4 Important Standard Transactions
- 1.6 Summary
2 Overview of SAP Tables and Table Links
- 2.1 Data Browser
- 2.2 Table Determination Options
  - 2.2.1 F1 Help
  - 2.2.2 Table Trace
  - 2.2.3 Archiving Object
  - 2.2.4 Where-Used List
- 2.3 Table Links
  - 2.3.1 Customer Master
  - 2.3.2 Sales Document
- 2.4 Summary
3 QuickViewer
- 3.1 QuickViewer Overview
- 3.2 Sample Data for Table TSTCT
- 3.3 QuickViewer Initial Screen
- 3.4 Steps for Creating a QuickViewer Report
  - 3.4.1 Defining a QuickView Name and Description
  - 3.4.2 Selecting a Data Source
  - 3.4.3 Selecting Selection Fields and Layout Fields
- 3.5 Layout Mode
- 3.6 Summary
4 Overview of SAP Query
- 4.1 Fundamentals
- 4.2 Query Areas
- 4.3 User Group
- 4.4 InfoSet
- 4.5 SAP Query
- 4.6 Summary
5 Query Utilities
- 5.1 Overview of Query Utilities
- 5.2 Overview of Query Objects
- 5.3 Query Objects
  - 5.3.1 Overview of User Groups
  - 5.3.2 Query Overview
  - 5.3.3 Directory Lists
- 5.4 Calling Query Object Descriptions
  - 5.4.1 User Group Description
  - 5.4.2 InfoSet Description
  - 5.4.3 Query Description
- 5.5 Editing Functions for Query Objects
  - 5.5.1 Copy Function
  - 5.5.2 Trash Folder
  - 5.5.3 Query Transport
- 5.6 Summary
PART II SAP Query Functions
6 InfoSet in Detail
- 6.1 Data Sources
- 6.2 Automatic Text Recognition
- 6.3 Table Join
- 6.4 Field Groups
- 6.5 Individual Additional Fields
- 6.6 Selection
- 6.7 Summary
7 SAP Query in Detail
- 7.1 Fundamentals
- 7.2 Initial Screen
  - 7.2.1 Changing User Group
  - 7.2.2 Converting QuickView into a Query
  - 7.2.3 Additional Functions on the Initial Screen
  - 7.2.4 Additional Editing Options
- 7.3 Query Creation Screen
  - 7.3.1 Query Title and Formatting
  - 7.3.2 Output Format
- 7.4 Field Name
  - 7.4.1 Changing the Column Header of Query Fields
  - 7.4.2 Local Fields
  - 7.4.3 Selection Fields
- 7.5 Basic List
- 7.6 Additional Functions
- 7.7 Summary
8 Selection and Layout Variants
- 8.1 Selection Screen
- 8.2 Selection Variants
- 8.3 Layout Variant
- 8.4 Summary
9 Traffic Light Icons, Drilldown, Graphics, and ABC Analyses
- 9.1 Symbols
- 9.2 Icons
- 9.3 Drilldown Options
- 9.4 Using Graphics and the ABC Analysis
- 9.5 Summary
PART III Designing User-Friendly Reports
10 Summarized Data Output with Statistics and Ranked Lists
- 10.1 Example: Open Item List
- 10.2 Basic List Without a Graphical Query Painter
- 10.3 Statistics
- 10.4 Ranked List
- 10.5 Summary
11 ABAP Fundamentals in the InfoSet
- 11.1 ABAP Dictionary
- 11.2 Individual Data Objects in the InfoSet
  - 11.2.1 Data Fields
  - 11.2.2 System Fields
- 11.3 Helpful ABAP Code
  - 11.3.1 Sample Code on the Editor Screen
  - 11.3.2 IF Statement
  - 11.3.3 SELECT Loop
  - 11.3.4 SELECT SINGLE Statement
  - 11.3.5 Other Helpful ABAP Commands
- 11.4 Using Your Own Code in the InfoSet
- 11.5 Summary
12 Integration with Microsoft Excel
- 12.1 Data Browser
- 12.2 Excel Inplace in SAP List Viewer
- 12.3 Microsoft Excel Integration for Other Query Output Formats
- 12.4 Summary
PART IV Query Management
13 Transport System
- 13.1 Transport Dataset
- 13.2 Transport Tool
  - 13.2.1 Transport Tool in the Standard Area
  - 13.2.2 Transport Tool in the Global Query Area
- 13.3 Transport Options
- 13.4 Additional SAP Notes
- 13.5 Summary
14 Data Retrieval and Function Modules
- 14.1 Secondary Index
- 14.2 Table View
- 14.3 Function Module
  - 14.3.1 Function Module for Converting the Time Dimension in the InfoSet
  - 14.3.2 Function Module for Displaying Texts
- 14.4 Summary
15 Authorizations and Transaction Creation
- 15.1 Transactions in the Query Environment
- 15.2 User Groups
- 15.3 Authorization Objects
  - 15.3.1 Authorization Groups
  - 15.3.2 Authorization Object S_QUERY
- 15.4 Integrating Query Transactions into a User Role
- 15.5 Notes on Authorization Assignment
  - 15.5.1 SAP Notes
  - 15.5.2 Authorization Objects for Administrators and Developers
- 15.6 Summary
PART V Real-Life Examples
16 Real-Life Examples
- 16.1 Procedure When Creating Reports
  - 16.1.1 Brainstorming Workshop
  - 16.1.2 Specifying Reports
- 16.2 Sales Evaluation
- 16.3 Financial Accounting Analysis — Open Items
- 16.4 Production Planning — Measuring Productivity
- 16.5 Summary
Appendices
- A Important SAP Tables
  - A.1 General
  - A.2 Sales and Distribution
  - A.3 Production
  - A.4 Materials Management
  - A.5 Financial Accounting and Controlling
- B The Author
Index

ℹ️ How to purchase this book?

This product has a special price upon request. You can start your order or clarify any doubts using the Contact for Price button on the page.

We have also prepared a step-by-step guide to explain how to easily request your quote.

Read the guide here →

Disclaimer

SAP, other SAP products and services mentioned herein as well as their respective logos are trademarks or registered trademarks of SAP SE (or an SAP affiliate company) in Germany and other countries. Our Company is not affiliated to SAP SE or any of its affiliated companies including but not limited to: Sybase, Business Objects, Hybris, Ariba and SuccessFactors. All other names, brands, logos, etc. are registered trade or service marks of their respective owners.

Home > SAP Books > English Books > SAP Query Reporting—Practical Guide

SAP Query Reporting—Practical Guide

Name: SAP Query Reporting—Practical Guide
Brand: SAP
SKU: BOOK-SAPPRESS-EBOOK-2011-9781592297276
Availability: InStock

Warranty

Receive the product you were expecting or we will refund your money

Would you like to see a sample of the course or book?

If you need a sample of the course or book, request it in the chat below and we will be happy to provide it to you.

1 installment of $0.00 USD without interest		Total $0.00 USD
2 installments of $0.00 USD without interest		Total $0.00 USD
3 installments of $0.00 USD without interest		Total $0.00 USD
4 installments of $0.00 USD without interest		Total $0.00 USD
5 installments of $0.00 USD without interest		Total $0.00 USD
6 installments of $0.00 USD without interest		Total $0.00 USD

SAP Query Reporting—Practical Guide

You'll learn about:

Key Highlights:

ℹ️ How to purchase this book?

Disclaimer

SAP Query Reporting—Practical Guide

Related products