Flylib.com
SAP Query Reporting
SAP Query Reporting
ISBN: 0672329026
EAN: 2147483647
Year: 2006
Pages: 161
Authors:
Danielle Larocca
BUY ON AMAZON
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 R3 Query Reporting Tools
The SAP R3 Query Reporting Tools
How the SAP R3 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 InterfaceExtract 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 R3
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 R3 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 ActionsEvents to Improve Reporting Capabilities
Things to Remember
Chapter 18. Security Concepts in SAP R3 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 R3 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
SAP Query Reporting
ISBN: 0672329026
EAN: 2147483647
Year: 2006
Pages: 161
Authors:
Danielle Larocca
BUY ON AMAZON
Qshell for iSeries
Scripting
Parameters and Variables, Defined
Scripts - Debugging, Signals, and Traps
C and C++ Development Tools
Appendix A Summary of Changes by Release
Certified Ethical Hacker Exam Prep
Linux and Automated Security Assessment Tools
Study Strategies
Summary
Software and Documentation
Limited Warranty and Disclaimer
Metrics and Models in Software Quality Engineering (2nd Edition)
Halsteads Software Science
Productivity Metrics
Satisfaction with Company
Conducting In-Process Quality Assessments
Measuring Process Maturity
Secure Programming Cookbook for C and C++: Recipes for Cryptography, Authentication, Input Validation & More
Building a Simple Hello, World Application Using Boost.Build
Counting the Number of Characters, Words, and Lines in a Text File
Determining if One Objects Class Is a Subclass of Another
Creating an Interface with an Abstract Base Class
Formatting Floating-Point Output
Visual C# 2005 How to Program (2nd Edition)
Case Study: Class GradeBook Using an Array to Store Grades
LinkLabel Control
Introduction
Self-Review Exercises
Wrap-Up
Microsoft Visual Basic .NET Programmers Cookbook (Pro-Developer)
Strings and Regular Expressions
Numbers, Dates, and Other Data Types
Network Programming
Remoting and Enterprise Services
Useful COM Interop
flylib.com © 2008-2017.
If you may any questions please contact us: flylib@qtcs.net
Privacy policy
This website uses cookies. Click
here
to find out more.
Accept cookies