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

ABAP Queries

Former Member
0 Likes
1,140

How to run queries in abap programs?

1 ACCEPTED SOLUTION
Read only

dani_mn
Active Contributor
0 Likes
1,110

Hi shaik,

check this PDF file for complete detail on SAP query concept.

http://help.sap.com/printdocu/core/Print46c/en/data/pdf/BCSRVQUE/BCSRVQUE.pdf

Regards,

Wasim Ahmed

How to run queries in abap programs?

9 REPLIES 9
Read only

Former Member
0 Likes
1,110

Go to transaction SQ01.Enter your query name and execute.

Read only

Former Member
0 Likes
1,110

Hi,

If you want to learn how work with creating queries without coding , then you have to use the transactions SQ03,SQ02 and SQ01.

Just go through this document.

http://esnips.com/doc/65fe6362-4b1d-412d-87e0-b55b31134118/SAPABAPQuery.doc

Regards,

SP.

Read only

Former Member
0 Likes
1,110

Hi,

Have a look at these good links-

Native SQL

http://help.sap.com/saphelp_47x200/helpdata/en/fc/eb3b8b358411d1829f0000e829fbfe/frameset.htm

-


Oracle queries

http://sqlzoo.net/

-


To format SQL

http://www.sqlinform.com/

Mark useful answers.

Regards,

Tanuja.

Read only

dani_mn
Active Contributor
0 Likes
1,110

Hi,

SQ03, SQ02 and SQ01 are used to create and execute queries.

here is the detail about them.

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.

Regards,

Wasim Ahmed

Read only

dani_mn
Active Contributor
0 Likes
1,111

Hi shaik,

check this PDF file for complete detail on SAP query concept.

http://help.sap.com/printdocu/core/Print46c/en/data/pdf/BCSRVQUE/BCSRVQUE.pdf

Regards,

Wasim Ahmed

Read only

Former Member
0 Likes
1,110
Read only

Former Member
0 Likes
1,110

Hi,

Enter the Query, then go to Systems-->Status, you will get the system generated program name for that query. Now go to se38/sa38 and execute the same program.

Read only

Former Member
0 Likes
1,110

Hi Mohammed,

Is your thread resolved, if not, reply me i will guide you better.

Rohit G