Search help for QMEL

[Former Member]

Hi Friends

I am creating search help for Quality Notification(QN) and Service Notification(SN), which will be used in our ECM integration.

There is a restriction that i can use only one table name in Selection method in search help. It won't allow other selection methods.

I know that Quality Notifications and Service Notifications get stored in QMEL table.

I can use that table for both search helps one for Quality Notification and another for Service Notification.

As we are using same table for both, when i use QN search hep it should show only QNs to me and when SN search help is used only SNs should be displayed.

We have a field ARTPR in QMEL table which is priority type. I have used 'QM' for Quality Notifications and 'SM' for Service Notifications. My doubt is what if we maintain any custom Priorities in that ARTPR, we have Z1, Z2 and Z3 maintained. Will there be any chance that they can be related to any QN or SN?

In general ARTPR is only the field to differentiate a notification that it is a SN or QN?

so how to differentiate between a notification between SN and QN ?

[jogeswararao_kavala]

• You can make use of field HERKZ (Notification origin) and also QMART (Notification type).
• In fact you need the value of QMTYP which is a field in table TQ80 where above 2 fields are there.
• When QMTYP is '01' it is Maint Notification and when it is '03' it is Service Notification.

[Ashg1402]

Hi,

   You can differentiate between two by checking notification category, there is a table TQ80 which contains this data. Just pass the notification type and you will get the category value.

Regards

Ashish