Issue with writing a Query

[Former Member]

Hi All,

I need to create a Query to get the following data.

( Sold to, end user, material, qty,revenue).

Could you please help me how to write a Query?

Thanks in advance..

Regards,

SK

[Former Member · Accepted solution]

Hi Shaik,

Firstly, please go to SQ03 to create user group and please do followings:

-create a user group with a specific name

-click asign users and infosets and assign user to this user group.

-create infoset according to your tables needed in query (sold to, material, qty,revenue)(VBAK, VBAP,etc...)

[http://wiki.sdn.sap.com/wiki/pages/viewpage.action?pageId=35815766]

-go to SQ02 to create infoset to make tables joint and join the table

-choose fields from tables you have joint before aand additionally you can create additional fields

-crate coding as data if needed

-Go to SQ01 to create queries,

-firstly choose infoset crated before and give a title for it.

-select field which you want to display by this query by selecting field group. and test it.

Additionally, you should maintain a t-code for this query.

I hope these will be useful for you.

Regards,

[Former Member]

Hi,

Go to SQVI

and use VBAP table

Regards,

Rahul

[Former Member]

Use transaction SQVI. Follow the four quick steps at the left portion of the screen to create a query. For your data, you may need to link the sales to billing tables to pricing tables.