Posts

SAP Query Tutorial for Beginners

SAP Query is SAP’s tool to define and execute once own reports without knowing ABAP programming language. In this document following key topics to explore SAP Query are covered in detail:

  • What is SAP Query? Purpose and Advantages of SAP Query?
  • Configuration for SAP Query
  • Create transaction for SAP-Query
  • Creating Ad Hoc query (HCM related infoset query)
  • Developing SAP Query for Task List Data Extraction
  • Transport of SAP Query objects
  • Setting the Expiry date in SAP Query
  • SAP Query for getting hourly background job status
  • Building an SAP Query using ABAP Code
  • Development of Basic List Query using SAP Query
  • Working with infosets/User Groups/Query in detail

Read more

Yet Another Step by Step ABAP Query Tutorial

ABAP Query is a functional tool used to develop simple report by writing queries instead of writing ABAP report program i.e. without ABAP coding. All you need is to join the table and drag and drop field that you wish to occur in the report.

This document gives brief introduction on ABAP concepts and stepwise approach to create ABAP Query. Step by step approach of creating ABAP query is covered as following in this tutorial:

  • Create User Group [SQ03]
  • Create Infoset [SQ02]
  • Create Queries [SQ01]

Read more

User Guide for Transporting Queries in SAP

Query is a SAP tool for developing report easily without help of ABAP, and it mainly uses the tables or joins tables to get data by business requirement. There is also a document i shared in my site which will take you to step by step guide for creating SAP Query. You can also take your understanding of SAP Query further with a case study and screenshots provided Document.

The document i will share will show you a step by step guide to transport queries, in other words export/import queries. Why would someone need to transport queries ? The common scenarios are as

  • Transport queries from Production to QA Development System, or Dev to Prod..
  • Transport queries from one system to another system. ie from 4.6C to ECC 6.0 or.

Read more

Creating Basic Reports with the SAP Query Tool

The SAP Query tool, in its standard form, is designed so that an end user with no technical skills can create a report from scratch. This document describes how to create basic list SAP reports by using the SAP Query tool. It introduces everything you need to know to create basic list type reports in any application module of SAP. The step-by-step setup of this guide makes it easy for any user, regardless of technical skill level, to create custom reports by using the SAP Query tool. Read more