SAP Query

[Former Member]

Can anyone explain step by step procedure to create SAP Query ( SQ 03 ... SQ 01 )

What is its use ?

[Former Member]

Hi,

CHeck http://www.sappoint.com

and also check : http://www.onestopsap.com/SAP-Tips/

It has very good document for SAPQuery.

Regards

Subramanian

Message was edited by:

Subramanian PL

[p291102]

Hi,

f yes folowing is the process.

1) Goto transaction SQ02 and maintain your infoset .Inside the infoset click on JOIN BASIS table and write the name of the first table from which you want to extract data.For e.g. your first table is VBAK and press enter ,then you join another table VBAP.You can join only those tables which have some link (common values) amongst themselves.

2) After Creating infoset you have to assign this infoset to user group.In SD case user group would be SD.You also need to assign your user name to this user grp.This can be done in SQ03.

3) Now goto transaction SQ01 and create your query.Here you will decide your selection screen and the display screen of your query.

You can send me your mail id .I will send you a complete documentation on queries.

Thanks,

Shankar

[Former Member]

Hi Sankar M,

Cold you please send me the Documentation on queries and display screen of your Query to my email : [email protected]

As I am very much in need of them

[Former Member]

What is the flow ?

SQ01 -> SQ02 -> SQO3 .Right ?

What we create in SQ01 ?

What is User Group ?

What we create in SQ03 ?

[Former Member]

HI,

Its different for sap query.

SQ03 -> SQ02 -> SQ01.

SQ03 to create the user group and assign the users who can use this query.

SQ02 - to create the infoset and assign the user group to it.

Here you can join tables, or LDB or other options to link one or more tables.

SQ01 - To create the query and select the fields for selection screen and output.

Regards

Subramanian

[Former Member]

Hi ,

Can you explain about User Group ? Who will create that , Is it like giving authorization to specific users ?

Can you explain what is Infoset ?

So if we are going to design query in SQ03 , Then what will be in Infoset ?

[Former Member]

Hi,

Generally, the functional people create the queries, we technical people very rarely go for sap queries.

Info group is created by the user only. The concept is similar to the function group, wherein you group all the related function modules into a single group. Similarly , you create a group and assign this group of users to access the queries designed by you.

Infoset is where you join tables and select the fields that needs to be used for the selection screen and display.

Regards

Subramanian

[Former Member]

use SQVI Transaction to create SQL Query..

[Former Member]

Hi Kumar,

SAP Query is a 3 step procedure for Reporting when u have to directly cull out the details either on the basis of joins or through some LDB.As there is no coding involved in this so preferably used by functional guys.

So whenever u want to have report in the fastest way in which no coding or calculation is involved for any fields then you can go for ABAP Queries.

Three Steps are:

1) SQ03

2) SQ02

3) SQ01

1) SQ03 : Here u define a User Grp which is a set of all users who will be

authorized to execute the report.So assign ur user ID to this USER

GRP.

2) SQ02 : Here u define the infoset i.e. information set means u will provide

information here that from which tables you need to select the fields

or

if tables and joins are not used then from which LDB u want to cull out

the reports.So u specify it here.

So watever u choose here will be selected as an information to display

in the report. And generate it.

Once above two steps are done then before going to SQ01 you have to again go to the SQ01 and assign the infoset created in SQ02 to USER GRP created in SQ01. Then go to step 3.

3) SQ01 : Here you execute the report on the basis of selection given in SQ02.

Now u have options here in order to make the report more interactive

more lively by coloring or by making them bold and u can select the

columns in a drag and drop fashion among all the fields u have given as

a selection criterion while creating Infosets. As u might not want to

include some details in the report which are necessary for culling out

data in SQ02 while creating Infosets.Like Key fields are inevitable for

joins bt u dont want them in report then u can easily remove them here.

Please reward if find useful.

Regards,

Sudhanshu

[Former Member]

Hi,

These r the steps for creating SAP-query.

First:

1. Goto sq03.

2. Write user group name with prefix z.

3. Click on create and give srt description.

4. Click on save and click on local object.

5. Goto sq02.

6. Write Info set name with prefix z.Click on create.

7. Give any name.

Then in Data Source we have.

> Table join using basic tables.

> Direct read of table.

> Logical Database.

We will select Direct Read of table.

the steps under it are.

1. Select direct read of table as Mara and click on continue.

2. Click on empty fields and continue.

3. Then click on database table Mara, u get all the fields of mara table.then select what ever fields u want by dragging n dropping them in the EF fields.

4. Then save , check n activate.

5. Click on Generate.

6. Go back.

This is same for all the data sources to get the output.

1. goto /nsq03.

2. Click on change , click on SA users and info sets.

3. Click on Assign Info sets.

4. Goto or click on last page.select on info set name and save .go back.

5. Goto /nsq01.

6. Then write query name with prefix z.Then click on create .Your info set name will be shown on left side.double click on it.

7. Then give a title, give lines as 00.

8. Then select Abap list. Then click on Basic list.

9. Then select the fields on left side and click on header and footer and give what ever heading u require.

10. Click on save and check.

11. Click on test (f8) and continue.

12. Then we will get the output.

the procedure what we follow here is first goto sq03 then sq02 then again sq03n then sq01.

just check this out n if its useful don't forget to reward with points,

with regards,

madhuri.