SAP query

[Former Member]

Hi

Can anyone tell me how to create SAP-Query in SQ01/02/03.

Thanks in advance

BJ

[Former Member]

hi

goto SQ03 and create an User Group If U want to create Ur Own.

Goto SQ02 to create Ur Infoset by Giving Logical database name or Simple Database table

Then Choose What ever data U need to be included in The Qurey in field Groups.

Then Generate the Infoset

Now Assign the infoset to user group

Now goto SQ01 and Click on Other user group Button and choose Ur user Group.

Then in the USer group select Ur Infoset and then create Ur own Query and save this.

Now select the infoset query and goto More functions under Query menu and Generate report name.

Now Create a transaction code for the report name generated.

. Goto sqvi tcode.

2. Press create button then next screen will be apear.

3. Data Souce will be table join

4. Chose basis mode.execute it.

5 There is one insert icon at application tool bar use it.

6. Define your table there.

7. Then press f3 means back from that screen

8. Chose your list field in List field selection tab and chose your selection screen fields in selection screeen fields tab.

9. save it and execute it.

[Former Member]

hi,

in sq02 first create the infoset. here you define the tables that u want to use and also the join relaion btween them. then in sq03 create user grps, assign users to user grps and infosets to user grps. in sq01 then define the query from the infoset. u can derife the layout the selection fields and the o/p fields.

saurabh