Skip to Content
avatar image
Former Member

Notification report

Hello Guys,

I need one single report with following information on it.

1. Functional location

2. Equipment

3. Notification #

4. Notification type

5. Work order

6. Cause codes

7. Code group - causes

8. Cause code text

9. Object code

10. Code group - object parts

11. Code groups - Activities

12. Activity code

13. Activity text

14. Activity long text - Do we need to use any BAPI ? if yes..what it is ?

To me, I don't see any std SAP report fetch all the above details. So I proceed with SQ02/SQ01 to combine multiple tables like QMUR,QMEL,QMEL,QMIH. None of these tables fetch the FL and EQ's and could not link the AUFK to these tables in query as well.

Please advise to proceed.

Mahee

Add comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

5 Answers

  • avatar image
    Former Member
    Feb 08, 2011 at 04:05 AM

    hi!

    Use t code IW65.

    Vaibhav Mishra

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Feb 07, 2011 at 10:10 PM

    Check transaction IW65

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Feb 09, 2011 at 09:33 PM

    Hi,

    You can use table VIQMFE, this information is available on this table

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member

      No..its not in there. I have checked the below tables already

      VIQMEL

      VIAUFKS

      VIQMFE

      VIQMMA

      VIQMEL

      VIQMSM

      VIQMUR

      None of the tables helped me to get the field what I am looking for.

      Mahee

  • avatar image
    Former Member
    Feb 10, 2011 at 10:09 AM

    have you tried iw29 with selection variants?

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Feb 10, 2011 at 07:49 PM

    Thanks for all your responses. Still I could not able to figure out all the fields. It seems like all the text fields are sitting in one field which has the different name on it. Atleast I could find one field in QPCT table but that also did not join with other tables in query.

    Closing the thread!

    Mahee

    Add comment
    10|10000 characters needed characters exceeded