Sap- programacion abap

ABAP QUERY – AN EXAMPLE
Applies To : ECC 5.0 Created On : 18.12.2007 Author : Sylvia Chandra Company : Telco Company Summary : This article will introduce you about ABAP Query and explain how tocreate an ABAP Query based on a case scenario.

Table Of Contents
What Is ABAP Query ? …………………………………………………………………………. 1 A Case Scenario ………...………………………………………………………………………… 2 Creating ABAP Query...………………………………………………………………………… 3 Result OF ABAP Query ..………………………………………………………………………. 4 Tips And Tricks …………………………………………………………………………………….. 5

What Is ABAP Query
A tool to generate report without ABAP coding. Allyou need is to join the table and drag and drop field that you wish to occur in the report. Type of reports provided by ABAP Query : 1. Basic List Simple Report. 2. Statistics Report containingstatistical functions like Average & Percentage. 3. Ranked List Report written for analytical purpose.

A Case Scenario
There is a request to generate a report display who should release a PO and messagestatus of the PO. The selections are based on : Date on which the record was created Purchasing Organization Purchasing Group Release Code Vendor’s Account Number Purchasing Document Type For example: We would like to display all PO which was created on a certain date. With information about who should release the PO or who is the latest releaser (for PO that has been full release) and themessage type of the PO (has been print, mail, fax).

Creating ABAP Query
Now, we come to step in creating ABAP Query. There are 3 steps : 1. Create User Group (SQ03) Specify the users who should beauthorized to run the query. 2. Create Infoset (SQ02) Indicates from which part of the SAP database the data is going to be retrieved and how the data is to be retrieved by the query. 3. Create Queries(SQ01) Create the query and arrange the layout.

Here are the detail explanation of each step : Create User Group (SQ03) Go to SQ03 to create User Group

Clik Assign users and Infosets...