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

sql query

how to work in sql query? what is the use

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

3 Answers

  • author's profile photo Former Member
    Former Member
    Posted on Feb 28, 2007 at 11:52 AM

    Hi,

    For time saving...

    Normal report without any validations and Interactive...

    SQ01,02,02 are Tcodes

    Regards,

    Kishore.

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Feb 28, 2007 at 12:17 PM

    Hi,

    ABAP Query is mainly used in HR perspective. In this you have three types are there.

    1. Inforset Query - Main Query part

    2. User Group - Infosets are assigned to user groups

    3. Query Area - We have two query ares Global Area (Cross-Client) and

    Standard Area (Client Specific)

    Main advantage of this is you can develop your own queries in an infoset and you can assign to a Query.

    Use the following T-codes.

    SQ01 - To run the query

    SQ02 - To create and maintain Infoset

    SQ03 - To create a user group and assign it to Infoset.

    You can create one infoset and assign it to Multiple queries.

    If you want detailed information about ABAP Query go thru this link

    http://help.sap.com/search/highlightContent.jsp

    Regards,

    Jayaram...

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Feb 28, 2007 at 12:34 PM

    Hi,

    Basically SQL query is used to get a simple report output which does not require too much of programing logic but requires only database fetches.

    SQL query can be made using the transactions sq01 , sq02 ,sq03.

    In transaction sq03 one creates a user group

    You create a user group and assign your info source to this user group.

    In SQ02 you create a infosource or functional area or you create graphical representations of the tables and the joins you want between them , when you generate the program of this query thee logic of the joins and the tables is automatically built in the program proposed to you by the system.

    Now the only thing left is takin input from the user which you normally do using the selection screen and the layout of the report this is done in SQ01.

    If you want further information i will send you documentation , send me your email-id.

    Regards,

    Sunmit.

    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.