Error in Adhoc Query

[kamesh_g]

Hi Experts

In an info set , I have added two additional fields to IT0001 ,Dotted position and Dotted Position text and I have added field code for both the fields .

When I select these fields independently as output fields I am getting values expected But when I select the combination of both the fields in a Query its giving weird error like below .

As per Message procedure , I have regenerated the info set also .

If any one has faced this kind of error Please help me out and give some pointers to overcome this .

Message :

Error when generating the report (see long text)

Message no. AQ_AD_HOC221

Diagnosis

The report cannot be generated because the internal description is invalid or incomplete, or because the selection screen is too large.

Regenerate the assigned InfoSet, and read the log. If the InfoSet is OK, make sure that at least one field is given as output.

If you used the 'Refresh' icon to start the query, use the 'Output' menu option to execute the query. This gives you a full screen display of the data.

If an output was generated, the query cannot work with actual data in the construction view. In this case, always use the 'Output' function to execute the query.

Procedure

If the selection screen is too large, you need to reduce the number of your selections.

Make sure that the assigned InfoSet is correct. The name of the assigned InfoSet is stored in the menu option 'Extras -> Template Information'.

Output at least one field. Otherwise you will not be able to save or generate reports.

If you do not have this problem, execute the query using the 'Output' function.

Otherwise, there is an error in the InfoSet Query.

Edited by: KAMESH G on Nov 29, 2010 9:19 AM

[Former Member]

hi experts

im having the same problem...

it is perfectly working in SAP Dev but when i transported it to SAP Prod im having this message.

please help

[kamesh_g]

hi

For its solved when i have done coding in one field instead of every additional field.

thanks