topic Re: sql query in Application Development and Automation Discussions

sql query

Former Member — Wed, 28 Feb 2007 09:59:20 GMT

how to work in sql query? what is the use

Re: sql query

Former Member — Wed, 28 Feb 2007 11:52:48 GMT

Hi,

For time saving...

Normal report without any validations and Interactive...

SQ01,02,02 are Tcodes

Regards,

Kishore.

Re: sql query

Former Member — Wed, 28 Feb 2007 12:17:01 GMT

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...

Re: sql query

Former Member — Wed, 28 Feb 2007 12:34:50 GMT

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.