Application Development and Automation Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Showing results for 
Search instead for 
Did you mean: 
Read only

SAP Query & ABAP Query

Former Member
0 Likes
1,392

Hi,

I just want to know the difference between SAP Query & ABAP Query.

How to procede with these two methods,Which method is used for which purpsoe.

In which cases SAP Query is prfered or in which cases ABAP Query is prefered.

Thanks in Advance,

Irfan Hussain

1 ACCEPTED SOLUTION
Read only

jayanthi_jayaraman
Active Contributor
0 Likes
1,299

Hi,

Check out these links.

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.

Kindly reward points by clicking the star on the left of reply,if it helps.Kindly close your previous threads if your problem is solved and reward points for helpful answers.

Hi,

I just want to know the difference between SAP Query & ABAP Query.

How to procede with these two methods,Which method is used for which purpsoe.

In which cases SAP Query is prfered or in which cases ABAP Query is prefered.

Thanks in Advance,

Irfan Hussain

8 REPLIES 8
Read only

athavanraja
Active Contributor
0 Likes
1,299

check out the following link

http://www.sap-basis-abap.com/sapquery.htm

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

they both are the same, earlier it used to be called as ABAP query and now they are called as SAP query.

"<b>SAP Query is the same as an ABAP Query or ABAP/4 query, dependent on the source system release.</b> " taken from

http://help.sap.com/saphelp_nw04/helpdata/en/25/8f4dd72b0f9f4fa6712fcf2f65f505/frameset.htm

Regards

Raja

Read only

Former Member
0 Likes
1,299

Hi Irfan,

This is what sap help says,

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.

Regards,

Ravi

Read only

0 Likes
1,299

Hi,

The transaction related with SAP Query are SQ01,

SQ02,SQ03 and the Transaction assocoated with ABAP query is PBAO.

ABAP and SAP Query are not the same.

Regards,

Irfan Hussain

Read only

0 Likes
1,299

did you try running both the transactions (SQ01 and PBAO)

they will take you to the same screen/program. (check the system->status to see that both uses program SAPMS38R and the screen is also same).

i guess they are same.

correct me if i am wrong.

Regards

Raja

Read only

jayanthi_jayaraman
Active Contributor
0 Likes
1,300

Hi,

Check out these links.

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.

Kindly reward points by clicking the star on the left of reply,if it helps.Kindly close your previous threads if your problem is solved and reward points for helpful answers.

Read only

0 Likes
1,299

Hi,

Could you let me the procedure to close the thread.

Regards,

Irfan

Read only

0 Likes
1,299

in the replies, under the name of the person replied you should see three radiobuttons.

Click on the appropriate radiobutton. clicking on answered radiobutton would mark the thread as asnwered.

Regards

Raja

Read only

0 Likes
1,299

Hi,

If you click the yellow star adjacent to a reply,it will award 2 points for them.

If green star,it will be 6 points.

If blue star,then that will give 10 points to the reply.That will be procedure for closing the thread.

If you solved it on your own,just click solved on my own against your question.

Hope you will close all your threads,if your problem is solved.