topic Re: notification status in Application Development and Automation Discussions

notification status

Former Member — Wed, 06 Jun 2007 05:47:12 GMT

Hi Guys,

i need to select all notification nos. that are completed. How can i do that??????

there is no table defined for that. When i press F1 on the status field it gives the name of a structure.

This structure, field and data element is neither used in any tables nor view.

please help me out its urgent.

all answers are welcome and points will be awarded generously.

Former Member — Wed, 06 Jun 2007 05:49:02 GMT

pl be more specific, qm or pm notification...tables are qmel/qmfe

if helpful, reward

Sathish. R

Former Member — Wed, 06 Jun 2007 05:50:40 GMT

hi satish,

its for PM notification transaction iw22.

former_member214288 — Wed, 06 Jun 2007 05:51:59 GMT

Hi,

QMEL is the table for Quality Notifications and QMFE for PM Notifications

Reward points if helpful.

Regards,

Ram

Former Member — Wed, 06 Jun 2007 05:53:50 GMT

hi ram,

what is the field name for status

Former Member — Wed, 06 Jun 2007 05:54:17 GMT

Better use ST05(Sql Trace), which will give you what were the tables accessed by your transactions.

Steps

1.Goto ST05 activate trace

2. Create or Enter Notification and save or Display document

3. Deactivate trace and display trace.

With these steps, you will get all the tables used for notifications.

Former Member — Wed, 06 Jun 2007 05:55:24 GMT

Jest and Jsto for status information i hope

Former Member — Wed, 06 Jun 2007 06:10:51 GMT

table is qmel ->

artpr will be PM for pm notifications

qmart will be M1, M2, etc..

here for a particular notification no., get the objnr field

pass the objnr to STATUS_TEXT_EDIT fm will language sy-langu, the output will be your status as you see in IW23

if helpful, reward

Sathish. R