abap querry

[Former Member]

can u give detail about abap querry detail my mail id is n.swamy_r@india.com

thank u

[Former Member]

hi

SQ Codes

SQ00 - ABAP/4 Query - Query Initial screen

SQ02 - ABAP/4 Query - Functional areas initial screen

SQ03 - ABAP/4 Query - Maintain User Groups initial screen

SQ07 - ABAP/4 Query: Language Comparison for query objects

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

http://www.ies.state.pa.us/hr/lib/hr/BJ0033_Travel_SQ00_Transfer_Travel_Expense_Reporting_.pdf

Executing Query

http://help.sap.com/erp2005_ehp_02/helpdata/en/d2/cb4056455611d189710000e8322d00/frameset.htm

Queries

http://help.sap.com/erp2005_ehp_02/helpdata/en/d2/cb476b455611d189710000e8322d00/frameset.htm

Sap Queries

http://help.sap.com/erp2005_ehp_02/helpdata/en/4f/71e252448011d189f00000e81ddfac/frameset.htm

Sap Query Components

http://help.sap.com/erp2005_ehp_02/helpdata/en/d2/cb3f2e455611d189710000e8322d00/frameset.htm

Sample Screen Shots

http://www.olemiss.edu/projects/sap/SQ01_10_03.pdf

Reward if USeful

Thanx & Regrads.

Naren..

[Former Member]

Hi

plrase check the link

http://www.sap-img.com/abap/what-is-sap-queries.htm

[Former Member]

Hi refer below

The purpose of the SAP Query are for users with no programming knowledge. It is also used by abapers to create simple reports for the users.

You can easily create three types of query reports :

1. Basic lists (details list)

2. Statistics (counting etc.)

3. Ranked lists

When you start using version 4.6x, you can see a Quick Viewer button in the Query Main screen. It is suppose to be much simplier that the original Query but it is up to you to decide whether is it true.

To create a report with the QuickViewer, all you need to to do is enter texts such as titles, and select the fields and options that define the structure of the report. You can assign a specific sequence to the fields by numbering them.

If necessary, you can edit the lists either through drag and drop in WYSIWYG mode, or by using the functions in the available toolbars. Data can also be send to external programs such as MS Excel or MS Word for further processing.

The only problem with QuickViewer is that it cannot read cluster table.

<a href="http://www.thespot4sap.com/Articles/SAP_ABAP_Queries_Create_The_Query.asp">SAP ABAP Queries</a>

[Former Member]

Dear swamy narshimha,

Many times a need arises for SAP Users and Functional Consultants to generate quick reports without getting any ABAP coding done – time taken to complete the coding in development, transport and test it in QA system and then transport to production – is sometimes too long. In such cases, ABAP/4 query is a tool provided by SAP for generating these kind of reports.

Type of Report Desired:

Before starting to write an ABAP query, its advisable to decide the type of report that the user wants. ABAP query provides the following type of reports:

Basic List Simple report

Statistics Report containing statistical functions like Average &Percentage

Ranked List Report written for analytical purpose

The output is always seen in the order of Basic List, then Statistics and then Ranked List if any. One ABAP query can have one basic list, maximum of 9 statistics and maximum of 9 ranked lists.

In a nutshell, an ABAP/4 query can be designed in four steps

- Creation of a user group

- Creation of functional area

- Assignment of user group to functional area

- Creation of the query based on functional area

The various objects that form an ABAP query can be created in the following 2 ways:

- Tools => ABAP/4 Workbench => Utilities => ABAP/4 Query

OR

- 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

Though the general concept of an ABAP query is moderately difficult, the results and the long term use of the ABAP query is worth the effort.

A small search on SDN SD forum will help you to answer your query.

I will suggest you to visit http://sap-img.com/sap-sd.htm. It will give you the overview of SAP SD module.

Moreover there is a separate section of FAQs with answers which will help you in great deal.

Hope this helps you.

Do award points if you found them useful.

Regards,

Rakesh

P.S. you can send me a mail at my mail id rakeshsinghchauhan@gmail.com for any specific details