IQ09 - problem in selection with Sales Order

[former_member194158]

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

[Former Member]

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

[former_member194158]

Hi Vivek,

Thanks for your reply and sorry for a long silence from my side.

You actually mentioned a good point about actually assigning serial numbers against sales order in the form of 'technical objects'. Also this assignment should show in the history of the serial number.

I tried this process also.

You can refer the below screen shots. Assigned serial number as technical objects in VA02 and then this was also displayed in the serial number history.

But even though, I still faced the dump in IQ09 while executing with this SO + SO Item only as selection criteria.

Thus I still think, only SO + SO Item as selection criteria in IQ09 does not work.

Isn't it?

Thanks in advance for your kind advice.

Regards,

Supriyo

[Former Member]

Hi,

Please check Note 2025976 and Thread TSV_TNEW_PAGE_ALLOC_FAILED in IQ09 (program RIEQUI21) | How To Notes | ERP Champs

Also Take help from your Abap Team.

Regards

Vivek

[former_member194158]

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

[former_member185450]

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.

[former_member194158]

Hello Venkatesh,

Thanks very much for your reply.

Initially, I also thought that serial numbers are not maintained against SO.

But actually, I think it happens.

For my case, the serial number, when displayed in IQ03, in SerData, it is showing assigned against the SO / item.

Also when I searched EQBS table against the SO / item, it shows the serial number.

If we refer SAP document, it says that it is possible to assign serial number in sales orders. Please refer the below link for details -

http://help.sap.com/saphelp_erp60_sp/helpdata/en/dd/f8c81db3f911d1896e0000e8284931/content.htm

So my problem / query remains in the same place that is - why IQ09 is not working when executed only against SO , SO Item !

Supriyo

[MTerence]

Hi,

Can you please post the screenshot of the Dump ?

First screen and error analysis

Regards

Terence

[former_member194158]

Hi Terence,

Thanks for your reply.

Please refer the below screen for the dump.

It includes 'error analysis' as well.

Regards,

Supriyo

Error analysis of Runtime Error - TSV_TNEW_PAGE_ALLOC_FAILED -

[MTerence]

Hi,

What is the selection criteria, you have used to execute this IQ09 ?

On checking, this looks like IDOC issue, refer below note, some storage space etc etc.

1520560 - Dump TSV_TNEW_PAGE_ALLOC_FAILED when running report RBDMIDOC - ALE

I suggest you to ask your abaper to debug, on the other side try to execute with a different SO which has serial number materials. I do not have a SO, so i cannot test in my system.

Regards

Terence

[former_member194158]

Hi Maria,

Thanks for your reply.

The selection criteria I used in IQ09 was = only SO number & SO Item number. That is all.

Yes, I executed IQ09 with an another SO + SO Item (SO with serial number). Result is same. Dump.

I am not sure how this 'IDOC' comes into picture while searching a serial number against a SO in IQ09 !

This has already been analyzed by ABAP. Intermediate conclusion was like - memory issue.

I also think is that - it is memory issue.

Why so?

Because, it does not even consider SO + SO item as selection criteria of IQ09 and thus it checks all the entries of EQUI table. EQUI is a huge table leading to a probably memory issue.

That's why my question is - why IQ09 is not considering SO + SO Item as selection criteria?

Regards,

Supriyo

[MTerence]

Hi,

Best option is you can raise the issue to SAP.

Regards

Terence

[former_member194158]

Hi Maria,

Thanks for your reply.

Yes, I am also planning in the same line. That is contacting SAP.

Regards,

Supriyo