08-26-2005 8:03 AM
Hi all,
Please let me know when to use ABAP query and is it really used in development.
Thanks in advance.
Sri.
08-26-2005 12:43 PM
Hi,
Mostly ABAP query used by functional consultants. many time is for single use and its very easy to develop.
transactions are used for Abap query is
SQ03 - > Create User Group ( who are having access
rights )
SQ02 - > Create InfoSet and Assign the User group to
Infoset
In the Infoset, we can frame infoset by Table join, Logical database and Data Retrieval by program. Here we can write our coding also.
SQ01 - > Design the query with help of infoset
( we can include select option also )
Cheers,
Sasi
08-26-2005 8:07 AM
Hope u can go thru the online doc
http://help.sap.com/saphelp_nw04/helpdata/en/b7/26ddebb1f311d295f40000e82de14a/frameset.htm
regds
gv
08-26-2005 8:07 AM
Hi,
ABAP/4 Query is a powerful report to generate simple reports. Mainly, there are four different ways to define data source in ABAP/4 query.
The four methods are
1. Table join using basis table.
2. Direct read of table.
3. Logical database
4. Data retrieval by program (Internal Program / External Program).
Check this link for more information.
http://www.sappoint.com/abap/ab4query.pdf
Kindly reward points by clciking the star on the left of reply,if it is useful.
08-26-2005 8:20 AM
<b>Why ABAP/4 Queries?</b>
Many times a need arises for SAP Users and Functional Consultants to generate quick reports without getting any ABAP coding done time taken to complete the coding in development, transport and test it in QA system and then transport to production is sometimes too long. In such cases, ABAP/4 query is a tool provided by SAP for generating these kind of reports.
This document aims at explaining the concept of ABAP/4 query in a simple and straight forward manner. The reader of this document should have a moderate knowledge of ABAP concepts and authorizations for understanding the concept of ABAP query.
<b>Type of Report Desired</b>
Before starting to write an ABAP query, its advisable to decide the type of report that the user wants. ABAP query provides the following type of reports:
Basic List Simple report
Statistics Report containing statistical functions like Average &Percentage
Ranked List Report written for analytical purpose
Refer this link too
http://www.thespot4sap.com/Articles/SAP_ABAP_Queries_Introduction.asp
Hope this helps.
Kindly reward points for the useful answers.
08-26-2005 8:23 AM
Hi Sriram,
ABAP/4 Queries:
Many times a need arises for SAP Users and Functional Consultants to generate quick reports without getting any ABAP coding done,time taken to complete the coding in development, transport and test it in QA system and then transport to production,is sometimes too long. In such cases, ABAP/4 query is a tool provided by SAP for generating these kind of reports.
This document aims at explaining the concept of ABAP/4 query in a simple and straight forward manner. The reader of this document should have a moderate knowledge of ABAP concepts and authorizations for understanding the concept of ABAP query.
Type of Report Desired
Before starting to write an ABAP query, its advisable to decide the type of report that the user wants. ABAP query provides the following type of reports:
Basic List Simple report
Statistics Report containing statistical functions like Average &Percentage
Ranked List Report written for analytical purpose
Also Check this Link.
http://www.thespot4sap.com/Articles/SAP_ABAP_Queries_Introduction.asp
Kindly Reward Point if u find it useful.
Thanks&Regards,
Ruthra.R
08-26-2005 12:43 PM
Hi,
Mostly ABAP query used by functional consultants. many time is for single use and its very easy to develop.
transactions are used for Abap query is
SQ03 - > Create User Group ( who are having access
rights )
SQ02 - > Create InfoSet and Assign the User group to
Infoset
In the Infoset, we can frame infoset by Table join, Logical database and Data Retrieval by program. Here we can write our coding also.
SQ01 - > Design the query with help of infoset
( we can include select option also )
Cheers,
Sasi