‎2006 Mar 21 12:37 PM
Hi All,
What is meant by ABAP Query!
When exactly it is needed.
Please tell me the process.
Thanks in advance.
Thanks & Regards,
Rayeez.
‎2006 Mar 21 12:45 PM
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.
‎2006 Mar 21 12:45 PM
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.
‎2006 Mar 21 12:46 PM
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.
‎2006 Mar 21 1:09 PM
Hi Shaik,
Pls go through the below link.
<b>http://www.sappoint.com/abap/ab4query.pdf</b>
Thanks
eswar