Skip to Content
author's profile photo Former Member
Former Member

ABAP Query

Hi all,

Please let me know when to use ABAP query and is it really used in development.

Thanks in advance.

Sri.

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

5 Answers

  • Best Answer
    author's profile photo Former Member
    Former Member
    Posted on Aug 26, 2005 at 11:43 AM

    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

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Aug 26, 2005 at 07: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.

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Aug 26, 2005 at 07: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.

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Aug 26, 2005 at 07: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

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Aug 26, 2005 at 07:07 AM
    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.