MIRACLE WISDOM - SAP QUERY REPORTING
SAP Query Reporting Forum

 
TUTORIALS
ERP
SAP
SAP BW
SAP Query Reporting
Oracle Applications
Oracle Database
Oracle Application Server
Microsoft Dynamics CRM
Project Management
Windows Vista
Java
Microsoft Excel
Windows PowerShell
Microsoft Visio
JBoss Seam
Ajax
Microsoft Office Project
Eclipse Web Tools Platform
Adobe Dreamweaver
Microsoft Access
Microsoft SharePoint
JavaServe Faces (JSF)
Microsoft Expression
JavaScript
Microsoft SQL Server
Cascading Style Sheets (CSS)
Active Directory
SQL
Oracle PL/SQL
Subversion
Unified Modeling Language (UML)
XML
Unix
Red Hat Linux Administration
Apache Web Server

Google Custom Search
 
SAP QUERY REPORTING TRAINING
This tutorial is everything an SAP user needs to go through 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 tutorial provides an step-by-step instruction. This tutorial 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 tutorial 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



LESSONS
SAP R/3 Query Reporting Tools Overview  
 SAP R/3 Query Reporting Tools Overview
 The SAP Query Tool
 The InfoSet Query Tool
 The QuickViewer Tool
 How the SAP R/3 Query Tools Work
 Comparing the Query Tools
Configuration for Query Tool  
 Steps in Configuring the Query Tools
 Performing Maintenance on InfoSets
Creating Basic Reports  
 The SAP Query Tool
 Creating a Basic List Query
 Five Basic Screens
 Modifying an SAP Query
 Saving a Query
 Maintaining Queries
The Fundamentals of Reporting  
 Real World Examples
 Maintenance Functions
 Working on Existing SAP Queries
Reporting Selection Screens  
 The Reporting Selection Screens
 Maximizing the Use of Selection Screens
 Understanding Output Options
 Using Multiple Selection Buttons
 Using Variants
Creating Advanced Reports  
 SAP Query Tool's Advanced Screens
 Using Advanced Screens
Creating Extract Files and Interfaces  
 Overview of Interface/Extract Files
 Creating a Fixed Positional Extract File
Creating Basic Calculated Fields  
 Creating a Basic SAP Query
 Using a Simple Mathematical Formula
 Using a Simple Condition
 Using an Input Value
Creating Advanced Calculated Fields  
 Basic SAP Query
 Using Multiple Conditions
 Using Multiple Fields
 Using a Calculated Field
Inserting Pictures and Graphics  
 Using Symbols and Icons
 Inserting Black-and-White Symbols
 Inserting Black-and-White Symbols by Using a Simple Condition
 Inserting a Color Icon Using a Simple Condition
 Inserting a Color Icon Using Multiple Conditions with Two Operators
Creating Simple Statistics Lists  
 Statistics Lists
 Creating a Statistics List
 Creating a Subtotaled Statistics List
Creating Advanced Statistics Lists  
 Creating a Basic List for Reference
 Creating an Advanced Statistics List
Creating Ranked Lists  
 Ranked Lists Overview
 Creating a Ranked List
 Sample Uses of Ranked Lists in SAP R/3
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
Special Considerations for Configuring HR and Payroll Reporting in the HCM Module  
 Configuring InfoSets for the HCM Module
 Special HCM Configuration Maintenance Considerations
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
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
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
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
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
SAP Query Reporting with Microsoft Word and Outlook  
 Maximizing SAP Reports by Using Word
 Maximizing Reporting Options by Using Word and Outlook
SAP Reporting with Microsoft Access  
 Maximizing SAP Reports by Using Access
 Maximizing SAP and Third-Party Solution Reports by Using Access
 
 

Online Software Training
Resources
SAP Query Reporting Training Courses