Abap query transaction

The transaction codes associated with ABAP Query are

SQ01

- ABAP Query

SQ02

- Infoset

SQ03

- User group

Step to Create SAP Query

—1. Create User Group (SQ03)

Specify the users who should be authorized 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. —Report type and the Graphical Query Painter:

•Basic List – Simple Reports

•Statistics – Reports with statistical functions such Avg, %.

•Ranked List – Analytical Reports

Components of SAP query

The SAP Query comprises five components:

—Ø Queries

—Ø InfoSet Query

—Ø InfoSets

—Ø User Groups

—Ø Translation/Query

· InfoSets - InfoSets determine to which tables, or field within a table, a query can refer. InfoSets are usually based on table joins or logical databases.These should be created with sharability in mind.

· User Groups -The user group allows you to to specify the users who are authorized to run and/or create/change queries under that user group.

· Queries - Formatting the data identified in the InfoSet to

create the desired report.

—

SAP/ABAP Query

1. What is SAP Query?
2. Purpose and features of SAP Query?
3. Components of SAP query
4. Step to Create SAP Query
5. Abap query transaction