topic Re: Regarding ABAP Query in Application Development and Automation Discussions

Regarding ABAP Query

Former Member — Tue, 21 Mar 2006 12:37:31 GMT

Hi All,

What is meant by ABAP Query!

When exactly it is needed.

Please tell me the process.

Thanks in advance.

Thanks & Regards,

Rayeez.

Re: Regarding ABAP Query

Former Member — Tue, 21 Mar 2006 12:45:45 GMT

Hello Shaik,

ABAP Query is another process of geting report without much use of ABAP language. This can be used by functional people also to generate simple reports.

Primary trx are

1.SQ01- For creating query

2.SQ02-For creating infoset

3.SQ03- For creating user group.

Steps.

1. Create User group

2. Create Info set attach to the user group created. Here u def the table joins etc and the fields u want in the query.

3. Create query where u select the fields to appear in the selection screen. sort, and output.

Re: Regarding ABAP Query

Former Member — Tue, 21 Mar 2006 12:46:36 GMT

Hi shaik,

1. just as we write SELECT statements,

in abap code,

to fetch fields/data from table(s)

2. in similary fashion,

ABAP query

(tcode is SQVI)

is a tool, (graphical tool)

where we can use the tables

and join them (using mouse drag * drop)

so that

automatically SELECT query

is generated behind the scenes,

and it provides facility for

getting the data !

regards,

amit m.

Re: Regarding ABAP Query

Former Member — Tue, 21 Mar 2006 13:09:33 GMT

Hi Shaik,

Pls go through the below link.

<b>http://www.sappoint.com/abap/ab4query.pdf</b>

Thanks

eswar