‎2007 Jun 06 6:47 AM
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.
‎2007 Jun 06 6:49 AM
hi
pl be more specific, qm or pm notification...tables are qmel/qmfe
if helpful, reward
Sathish. R
‎2007 Jun 06 6:49 AM
hi
pl be more specific, qm or pm notification...tables are qmel/qmfe
if helpful, reward
Sathish. R
‎2007 Jun 06 6:50 AM
‎2007 Jun 06 7:10 AM
hi
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
‎2007 Jun 06 6:51 AM
Hi,
QMEL is the table for Quality Notifications and QMFE for PM Notifications
Reward points if helpful.
Regards,
Ram
‎2007 Jun 06 6:53 AM
‎2007 Jun 06 6:54 AM
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.
‎2007 Jun 06 6:55 AM