Skip to Content
author's profile photo Former Member
Former Member

Error when generating the report (see long text), Message no. AQ_AD_HOC221

Hi experts,

While executing an infoset query i am getting the error"Error when generating the report (see long text), Message no. AQ_AD_HOC221" This info set query used particularly to fetch data from IT 0008.I have 2 customized fields in infotype 0008.

When I execute query including one of the customized fields as output , i getting this error.If i run the report excluding the one custom field the report is generating without any error.I felt the problem is with the one customized field.The coding for the customized field was done long back & done by someone worked earlier.

I check all the below procedures mentioned in performance assistant.

Procedure

If the selection screen is too large, you need to reduce the number of your selections -Selected only pernr as selection filed & custom field and pernr as output.

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

Output at least one field.-Selected more than one field as output

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.- Tried. still getting the same error.

Otherwise, there is an error in the InfoSet Query. At last i created a new info set query,but again i am getting the same error if i include the particular custom field.

Could you please suggest a solution for this error?.

Add a comment
10|10000 characters needed characters exceeded

Related questions

3 Answers

  • Posted on Nov 10, 2014 at 04:12 PM

    When you click on execute you get your selection screen. Go to system->status and get your program name. Then go to SE38, enter your program name and click on ‘syntax check’.

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member Former Member

      Hi Jobish,

      With the screenshot you provided, I do not see any issue.

      The field that you are making use of is IT0008-Custom Field which has been called in the Infoset. This being a currency field, making a reference to Currency field is alright..

      From the screenshot again, the custom field that is being used makes reference to HRP9009 Infotype..seems to be a Custom OM Infotype....and the Infotype 0008 screen will already have the code to put data in this custom field, i assume.....therefore, this is also ok.

      So, overall the Infoset seems to be ok.

      Coming to the Adhoc Query, technically I dont see any problem, meaning..

      You have PERNR as selection field and PERNR + Custom Fields as output field..

      Can you do one test and let us know the result...

      The PERNR field that you selected as output field, choose that as Infotype 0008-PERNR and also choose Begda and Custom fields from IT0008.

      I assume this should work..

      Kumarpal

  • author's profile photo Former Member
    Former Member
    Posted on Nov 25, 2014 at 05:47 AM

    Hi Experts,

    Could you please guide me to resolve the issue?

    Thanks,

    Jobish A

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Nov 27, 2014 at 11:59 AM

    Hi Experts,

    Could you please guide me to resolve the issue?.Do we need to write codes for custom fields to display the result.?

    Thanks,

    Jobish A

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.