create query in SQ01

[Former Member]

Hello Abap Experts,

What are the steps to create and execute query in SQ01. I have to create a query for a selected fields on top of vbak, vbap, vbrk, vbrp tables.

Any suggestions suggestions / pointers / links are highly appreciated.

Thanks,

BWer

[RichHeilman]

First you need to create the infoset which will tie your tables together. Use SQ02 to do this. Then in SQ01, when you create your query, you specify the infoset that you want to use. Then its just a matter of pulling in the fields that you want in the output list and setting the selection fields. Check out SQ02 to create your infoset, then use SQ03 to assign it to a user group.

Regards,

Rich Heilman

[jayanthi_jayaraman]

Hi,

Check this link.

http://www.sappoint.com/abap/ab4query.pdf

Kindly reward points by clicking the star on the left of reply, if it is useful.

[Former Member]

Hi!

1- If there isn't you have to create an INFOSET with your table; VBRK, VBRP, VBAK and VBAP;

2- Assign INFOSET TO USER GROUP

3- create a query based on your infoset

Max