topic Re: ABAP Queries in Application Development and Automation Discussions

ABAP Queries

Former Member — Tue, 18 Jul 2006 05:19:24 GMT

How to run queries in abap programs?

Re: ABAP Queries

Former Member — Tue, 18 Jul 2006 05:23:41 GMT

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

Re: ABAP Queries

Former Member — Tue, 18 Jul 2006 05:26:29 GMT

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.

Re: ABAP Queries

Former Member — Tue, 18 Jul 2006 05:28:01 GMT

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.

Re: ABAP Queries

dani_mn — Tue, 18 Jul 2006 05:28:27 GMT

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

Re: ABAP Queries

dani_mn — Tue, 18 Jul 2006 05:42:31 GMT

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

Re: ABAP Queries

Former Member — Tue, 18 Jul 2006 05:47:37 GMT

Hi,

check the below link,

http://help.sap.com/saphelp_47x200/helpdata/en/a2/ba96c414b111d6999900508b6b8b11/frameset.htm

Regards,

Azaz Ali.

Re: ABAP Queries

Former Member — Tue, 18 Jul 2006 06:12:24 GMT

Hi ,

Check the following links.

http://www.thespot4sap.com/articles/SAP_ABAP_Queries_Create_User_Group.asp

The link below shows how to execute queries.

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

Please reward for the same

Re: ABAP Queries

Former Member — Tue, 25 Jul 2006 07:16:26 GMT

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.

Re: ABAP Queries

Former Member — Tue, 16 Oct 2007 11:07:10 GMT

Hi Mohammed,

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

Rohit G