IW68 able to show notifications without damaged code and object part

[former_member979849]

Hi

I have been recently tasked to do some report to to show all notifications that have input damaged code ("DC") and object parts("OP") as well as those notifications without DC/OP.

I have tried using IW68 but it will only show those notifications that is having DC/OP.

Is there any ways or other tcode that can perform the report?

[sveabecker]

Thank you for visiting SAP Community to get answers to your questions. Please add more details to your question, e.g. you can also add a screenshot. With that, you can reach a broader range of experts to get your question answered. I also recommend to do this tutorial https://developers.sap.com/tutorials/community-qa.html

The more details you provide, the more likely it is that members will be able to assist you.

Regards, Svea

SAP Community moderator

[peter_atkin]

Chee Seng Lim,

First of all, you will get a better response if you tag your posts with: PLM Enterprise Asset Management (EAM)/Plant Maintenance (PM)
IW68 only lists notifications that have an Item, and items include the damage code and object part code. So if there is no item on the notification, then it will NOT appear in IW68.There doesnt appear to be a standard report to do what you want, so here are some options:

• Create a SAP Query and link table VIQMEL and QMFE with an "outer-join" (SQ01/2)
• Create an SQVI Query and link table VIQMEL and QMFE with an "outer-join" (SQVI)
• Export IW29/IW68 to ecxel and perform a vlookup
• Create a new ABAP report

.

PeteA