topic Re: Regarding sap query report in Application Development and Automation Discussions

Regarding sap query report

Former Member — Wed, 04 Dec 2013 13:14:26 GMT

Hi experts,

I have a requirement as below.

It needs to create a report for Goods movement in sap query report through sq00 t-code, as per the sources i came to know it needs to select user group and from that group we need to select suitable info set while creating query report. after that we need to follow Select Field Group, Select Field, Selection, Query Layout Design steps. my question in those steps where we can pick input, output filed's in Select Field Group, Select Field steps . if they are coming from the info set, how we can maintain data in info set..? and in my requirement for quantity there are lot of validations are there, so how i convey those calculations in info set..? is there any other way to fetch them in to query out put..?

in my case i have user group, but don't have info set.

Please help me to resolve.

Regards,

Saida Reddy.

Re: Regarding sap query report

leelamohan_kavali — Wed, 04 Dec 2013 13:52:56 GMT

Hi,

You can write any query by First SQ03, Second SQ02, Third SQ01.

Best Regards

Mohan

Re: Regarding sap query report

Former Member — Thu, 05 Dec 2013 06:13:25 GMT

hi mohan,

Thx for reply, i know the procedure of query report, but to fetch fileds form select field group and selection steps we need to have info set. may i know how to create info set with my reuired fields ? and can you please tell me how to do arthemetic operations in a query report ?

Regards,

Saida Reddy.

Re: Regarding sap query report

leelamohan_kavali — Thu, 05 Dec 2013 13:16:43 GMT

Hi Saida,

Please Follow below link i have maintained Step by Step,

Step 1 :

SQ03 - 1,SQ03 - 2 SQ03 -3,

Step 2 :

SQ02 -1, SQ02 -2, SQ02 -3, SQ03 -5 like sequence follow,

Step 3:

SQ01 - 1 Like sequence follow,

These are below link screens numbers, If still your getting any problem let me know

Below link copy and Paste in google URL

http://postimg.org/gallery/11mingtc/38c21846/

Best Regards

Mohan

Re: Regarding sap query report

Former Member — Fri, 06 Dec 2013 10:15:01 GMT

Hi Mohan,

Thanks for ur reply. this document was so helpful in my requirement.

Regards,

Saida Reddy.

Re: Regarding sap query report

leelamohan_kavali — Fri, 06 Dec 2013 12:39:44 GMT

Hi,

It is my pleasure

Yours

Mohan