regarding SQL QUERY

[Former Member]

Hi,

i need information regarding TCODE SQ01,SQ02,SQ03

How to create user group,infoset and create query.

[Former Member]

Hi,

http://help.sap.com/saphelp_46c/helpdata/en/35/26b413afab52b9e10000009b38f974/content.htm

http://www.thespot4sap.com/Articles/SAP_ABAP_Queries_Introduction.asp

Step-by-step guide for creating ABAP query

http://www.sappoint.com/abap/ab4query.pdf

ABAP query is mostly used by functional consultants.

SAP Query

Purpose

The SAP Query application is used to create lists not already contained in the SAP standard system. It has been designed for users with little or no knowledge of the SAP programming language ABAP. SAP Query offers users a broad range of ways to define reporting programs and create different types of reports such as basic lists, statistics, and ranked lists.

Features

SAP Query's range of functions corresponds to the classical reporting functions available in the system. Requirements in this area such as list, statistic, or ranked list creation can be met using queries.

All the data required by users for their lists can be selected from any SAP table created by the customer.

To define a report, you first have to enter individual texts, such as titles, and select the fields and options which determine the report layout. Then you can edit list display in WYSIWYG mode whenever you want using drag and drop and the other toolbox functions available.

ABAP Query, as far as I Believe, is the use of select statements in the ABAP Programming. This needs a knowledge of Open SQL commands like Select,UPdtae, Modify etc. This has to be done only by someone who has a little bit of ABAP experience.

To sum up, SAP queries are readymade programs given by SAP, which the user can use making slight modification like the slection texts, the tables from which the data is to be retrieved and the format in which the data is to be displayed.ABAP queries become imperative when there is no such SAP query existing and also when there is a lot of customizing involved to use a SAP Query directly

use either SQ02 ans SQ01

or SQVI tr code

for more information please go thru this url:

http://www.thespot4sap.com/Articles/SAP_ABAP_Queries_Create_The_Query.asp

http://goldenink.com/abap/sap_query.html

once you create query system generates a report starting with AQZZ/SAPQUERY/ABAGENCY2======= assing this report to tr code for the same

reward points for useful answers

regards,

ANJI

[Former Member]

Hi,

ABAP Query is mainly used in HR perspective. In this you have three types are there.

1. Inforset Query - Main Query part

2. User Group - Infosets are assigned to user groups

3. Query Area - We have two query ares Global Area (Cross-Client) and

Standard Area (Client Specific)

Main advantage of this is you can develop your own queries in an infoset and you can assign to a Query.

Use the following T-codes.

SQ01 - To run the query

SQ02 - To create and maintain Infoset

SQ03 - To create a user group and assign it to Infoset.

You can create one infoset and assign it to Multiple queries.

If you want detailed information about ABAP Query go thru this link

http://help.sap.com/search/highlightContent.jsp

Kishore.

[Former Member]

Hi Kumar,

The following details might help u.

By executing the transaction codes mentioned below:

SQ01 ABAP/4 Query

SQ02 Functional Area

SQ03 User group

Step I - Create Functional Area

In the functional area section, the user 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. One functional area can be assigned to many user groups. A functional area can be created with or without a logical database. To create a functional area with a logical database, one has to mention the name of the database and then select the fields from the tables that form the logical database.

ABAP Query Authorizations: To use an ABAP query, the user must have appropriate authorizations. Two ways of providing authorizations to the users are as follows:

- User groups

The user should be a part of at least one user group to run the corresponding ABAP query. This automatically restricts the access of the user to specific functional areas, and thus the corresponding underlying logical databases.

- Authorizations

The authorization object S_QUERY should be used to give proper authorizations to the user for a query. This authorization object has a field named ACTVT which can take values 02 for Change, 23 for Maintain and 67 for Translate.

This value determines whether the user can create and modify the query. The possible authorizations in the object are as follows:

S_QUERY_ALL Change, maintain and translate query

S_QUERY_UPD Change and Translate

Regards,

Thasneem

[Former Member]

hi

1) Enter T.Code SQ02 and maintain your infoset .Inside the infoset click on JOIN BASIS table and write the name of the first table from which you want to extract data. Say, your first table is VBAK and press enter, then you join another table VBAP. You can join only those tables which have some link (common values) amongst themselves.

2) Assign this infoset to user group.In our case, user group would be SD.You also need to assign your user name to this user grp.This is accomplished in SQ03.

3) Then enter T Code SQ01 and create your query.Here you will decide your selection screen and the display screen of your query.

With this procedure you would be able to get the desired reports.

<b>Please award points, if found suitable.</b>

regards

ravish

[Former Member]

Kumar,

go through this link...

http://help.sap.com/saphelp_47x200/helpdata/en/bf/1d4645bf3211d296000000e82de14a/frameset.htm

www.sappoint.com/abap/ab4query.pdf

check out this link...

http://www.experts-exchange.com/Applications/SAP/Q_21316169.html

in case that requires a login, try the other one..

http://searchsap.techtarget.com/tip/1,289483,sid21_gci1073812,00.html?FromTaxonomy=%2Fpr%2F283958

SQ03 : is used to create user groups for queries because every user have to be in atleast one user group for creating infoset and queries. you have to create a user group and assign your user to that usergroup.

SQ02 : is used to create infoset you need to tell the data source for your infoset like table join, direct read or data reterival using program, you can also put extras fields, structures and tables using extras button. and can code your own select query for that field or structure.

After generating the infoset you have to assign this to your usergroup you already created.

SQ01 : is used to create Query form infoset you have created here you can select fields for selection screen and for list generation using check boxes.

you can generated different types of report using basic list, ranked list, statistics to output in graphical form.

Don't forget to reward if useful...

[Former Member]

Hi Kumar,

SQ01 - Query from user group

SQ02 - SAP query maintain Infoset

SQ03 -

U can create Infoset in SQ02.

U can create a usergroup in SQ03.

For more info..here is a step by step procedure.

http://www.sappoint.com/abap/ab4query.pdf

Cheers,

Sam

Message was edited by:

Samuel Zakster