SAP Query Reporting—Practical Guide

Book Information

• Publisher: SAP PRESS
• Authors: Stephan Kaleske
• Year: 2011
• Edition: 1
• Pages: 402
• Languages: English

Description

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

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

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.

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

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.