Skip to Content

IQ09 - problem in selection with Sales Order

Dear Experts,

In the beginning -

Not sure whether I am posting this discussion in a correct group or not!

This problem is related to serial number and I think, along with PM, SD etc. - PP uses serial numbers the most.

That is why, I am posting this in PP group.

If you think that I should post this problem in a more appropriate group, then please advise. I will do it accordingly.

The problem -

The problem is in IQ09 transaction. In IQ09 transaction's selection screen, 'Sales order' and 'Sales order item' are one of the selection parameters. But when I am using Sales Order & Item as the selection in IQ09, it is not actually working. It seems that IQ09 does not even considers these two fields (SO & SO item) as the selection parameter. This is the problem.

More about the Problem -

When I input only SO number & item as selection parameters in IQ09 and execute, I am getting a run time dump.

It is more like a memory dump.

This is because, IQ09 actually fetches all the serial number data in the database and thus it is resulting into dump. Thus it means, that IQ09 does not even consider the SO number & item as the selection parameter and hence fetching all the data from database resulting into dump.

When I execute IQ09 with more precise selection parameters such as - Material Number, Sales Order, Sales Order Item - it is displaying all the serial numbers against the Material. With this combination, it is displaying serial numbers of other SOs as well and also serial numbers without SO. Whereas, it should have been displayed only the serial number of that SO/Item.

Thus it means - it is not considering the SO & SO Item as the selection parameter.

This is the problem and I need your kind advice, help to solve the same.

Related Serial Number Profile has been properly maintained, I guess. Serializing Procedures like - SDAU (Serial numbers in SD order), SDLS (Maintain delivery) etc. are already been assigned to the Serial Number Profile.

Related SAP Note -

I found the below SAP Note most probably for a similar issue but for 'class' as the selection parameter.

  • 871622 - Equipment: Problem with selection using classes

I need your kind help to solve the problem of this IQ09 selection with SO + SO Item as selection criteria.

Thanks in advance.

Supriyo

Add a comment
10|10000 characters needed characters exceeded

Related questions

2 Answers

  • Posted on Sep 07, 2015 at 01:48 PM

    Hi Suprioyo,

    The serial numbers we will not maintain against sales orders and Item numbers i.e. we will maintain the serial numbers only in production orders / Purchase orders / Delivery with reference to SO

    So IQ09 may not work for showing the serial numbers which belongs to sales orders

    if you want to see means built a small SQVI query by linking the Delivery number to sales order number then get the serial numbers against that delivery number

    Regards,

    Venkatesh.

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Sep 11, 2015 at 06:24 AM


    Hi,

    In IQ09 report sales order and Item working perfectly fine as per STd.You need to maintain technical object in SO.Path-Extras->technical object.This will record in History Tab in material SR combination for that equipment and same displayed in report.

    For Dump Error Take help from Basis Team,This issue related to Table update.

    Regards

    Vivek


    iq09.png (9.6 kB)
    Add a comment
    10|10000 characters needed characters exceeded

    • Hi Vivek,

      Thanks for your reply.

      I think, I saw this SAP Note earlier as well. 2025976.

      It is about a memory dump which is causing while executing IQ09 with not enough selection criteria. As a solution, it says to increase the memory and/or use more selection criteria.

      But the point is, why it is going to such a memory dump situation while executing IQ09 with only SO+SO Item ? It means, it is not at all considering SO as selection criteria in IQ09 and hence it is trying to read all the data from EQUI table causing this memory dump.

      Just for your information, while I execute IQ09 in PROD and/or Quality system with only SO+Item as selection - it gives a dump.

      While I do the same in Dev environment, it shows all the serial numbers as a result.

      It is because, in Dev environment, there is less number of data in EQUI table and thus it displays all those data. Whereas, in PROD or Quality system, there are huge number of EQUI data and thus it results into dump.

      The reason is = it does not at all consider SO + SO Item as selection criteria. Thus it tries to read all the data.

      This is the problem.

      Regards,

      Supriyo

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.