| | 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 |