topic Given QUERY --> to report development in Application Development and Automation Discussions

Given QUERY --> to report development

Former Member — Wed, 23 Dec 2009 22:34:42 GMT

I have given a query.

i need to convert that to report.

However the business requirement is not given.

I need to dig the given query and

based on the table used, select queries written in that generated quiery program, I need to develop the REPORT.

Ane smart guidelines on how to write reprot based on given query

how to proceed ?

Your guide lines to complete this report quickly and smartly would be highly appreciated.

Thanks in advance!

Re: Given QUERY --> to report development

SureshRa — Wed, 23 Dec 2009 23:30:03 GMT

Hi,

You don't have to dig into the SAP Query. Just write an executable program and call the Function Module SAP_QUERY_AD_HOC and pass your Infoset Query Name and other parameters. Your SAP Query selection screen would appear to user. You can claim that this is a report program written by you. Pleae refer to SAP help [Calling the Infoset Query|http://help.sap.com/saphelp_47x200/helpdata/en/9c/6b7538c9a8ee45e10000009b38f8cf/content.htm]

Cheers,

Suresh

Re: Given QUERY --> to report development

Former Member — Thu, 24 Dec 2009 04:45:05 GMT

As per my understanding , you need to convert a query to report.

So proceed as below :

1. GO in infoset and find the batadase tables used in query with their join condition.

You need to write select statements on these tables with given join condition in your report.

2. Now, check the extra fields added and calculations. This you have to use in your report to get derived fields.

3. Check the output layout and selection parameters in SQ01. This you need to use for selection screen and output dilpsay. Use ALV to display output.

Hope this helps you.