2006 Jul 18 6:19 AM
2006 Jul 18 6:42 AM
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?
2006 Jul 18 6:23 AM
2006 Jul 18 6:26 AM
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.
2006 Jul 18 6:28 AM
Hi,
Have a look at these good links-
Native SQL
http://help.sap.com/saphelp_47x200/helpdata/en/fc/eb3b8b358411d1829f0000e829fbfe/frameset.htm
-
Oracle queries
-
To format SQL
Mark useful answers.
Regards,
Tanuja.
2006 Jul 18 6:28 AM
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
2006 Jul 18 6:42 AM
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
2006 Jul 18 6:47 AM
Hi,
check the below link,
http://help.sap.com/saphelp_47x200/helpdata/en/a2/ba96c414b111d6999900508b6b8b11/frameset.htm
Regards,
Azaz Ali.
2006 Jul 18 7:12 AM
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
http://help.sap.com/saphelp_erp2005/helpdata/en/d2/cb476b455611d189710000e8322d00/frameset.htm
Please reward for the same
2006 Jul 25 8:16 AM
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.
2007 Oct 16 12:07 PM
Hi Mohammed,
Is your thread resolved, if not, reply me i will guide you better.
Rohit G
| User | Count |
|---|---|
| 3 | |
| 1 | |
| 1 | |
| 1 | |
| 1 | |
| 1 | |
| 1 | |
| 1 | |
| 1 | |
| 1 |