10-18-2007 1:05 PM
Hi Guys,
I am having some ABAP Queries, How we can find the tables in particular abap query and what is the relation between the table.
After creation can we able to see the same flow of the ABAP Query.
Please give good advice.
Thanks,
Gourisankar.
10-18-2007 1:07 PM
Execute transaction SQ02
Enter the Infoset of the Query
Click on DISPLAY
Click JOIN
It will display the link between tables used for that query.
10-18-2007 1:13 PM
10-18-2007 1:18 PM
Hi,
1. You can only add a new field in the field group in a infoset query. But if you want to make it a select option that is only possible in SQ01 transaction.
2. check out the Qurey name for that infoset, the field that you have added in infoset will appear in that query.
3. Choose tick mark for Selection column, it will appear as select option in the query.
10-18-2007 1:09 PM
Hi
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.
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
use either SQ02 ans SQ01
or SQVI tr code
for more information please go thru this url:
http://www.thespot4sap.com/Articles/SAP_ABAP_Queries_Create_The_Query.asp
http://goldenink.com/abap/sap_query.html
Please check this PDF document (starting page 352) perhaps it will help u.
http://help.sap.com/printdocu/core/Print46c/en/data/pdf/BCSRVQUE/BCSRVQUE.pdf
check the below link will be helpful for u
once you create query system generates a report starting with AQZZ/SAPQUERY/ABAGENCY2======= assing this report to tr code for the same
Regards
Anji
10-18-2007 1:10 PM
SE30 - will give run time process and it will have abap memory,sap memory and data base execution graph..
St05 - SQL Trace - it will trace each query in a transaction,suppose transaction is running more than one hour and you want to tune the program.
just goto ST05 Transaction and click on trace on.now enter ur transaction and run ur transaction.once you done then comeback and trace off,list trace.
now it will show time - corresponding query,then we can use performance tuning to each query
10-18-2007 1:11 PM
follow dis link :-
http://www.saptechnical.com/Tutorials/SAPQuery/SQMain.htm
http://www.saptechnical.com/Tutorials/SAPQuery/SimpleQuery/SQ1.htm
if find useful den do rewards tooo