cancel
Showing results for 
Search instead for 
Did you mean: 

Notification report

Former Member
0 Kudos

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

Accepted Solutions (0)

Answers (5)

Answers (5)

Former Member
0 Kudos

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

former_member223813
Contributor
0 Kudos

have you tried iw29 with selection variants?

former_member661330
Contributor
0 Kudos

Hi,

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

Former Member
0 Kudos

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

Former Member
0 Kudos

hi!

Use t code IW65.

Vaibhav Mishra

peter_atkin
Active Contributor
0 Kudos

IW65 won't help, it doesn't have the Object/Cause data.

Try using VIQMEL and QMMA in your query

PeteA

Former Member
0 Kudos

IW65 won't help as it does not have cause codes and objects. I did tried with QMMA as well but none of the table gives the functional location and equipment. If I try to connect with AUFK, query does not have any relationship.

Pls help

Mahee

peter_atkin
Active Contributor
0 Kudos

Mahee,

But did you try VIQMEL (notification)

Also have a look at VIAUFKS (order)

PeteA

Former Member
0 Kudos

I could not able to get the functional location field and activity long text in any of the PM notification tables. I tried with IFLOT but it does not have any relationship to be linked in SQ01.

All other fields were retrieved from QMEL,QMFE,QMUR,QMMA.

I think long text for activity is not possible in std and have to go with any BAPI ? But I really need FL field but no luck

Mahee

peter_atkin
Active Contributor
0 Kudos

HAVE YOU TRIED VIQMEL or VIAUFKS AS MENTIONED ABOVE

Former Member
0 Kudos

Pete,

I tried that too and it does not work.

Mahee

peter_atkin
Active Contributor
0 Kudos

Mahee

Why doesn't these tables work?

PeteA

Former Member
0 Kudos

Pete,

Because I could not see the below fields

Short text for activity code

Short text for causes code

Short text for Object codes

These are coming from RIW000 structure and could not get the tables corresponsing to this.

Also I could not able to get the "Activity long text " as well

Note : Functional location was retreived from VIAUFKS--thanks for the same.

Mahee

Former Member
0 Kudos

You should be able to get all the code text from table QPCT.

Regards

Narasimhan

Former Member
0 Kudos

Narishman,

I don't see the fields in QPCT for all the short text.

Here is the fields

Short text for Objects - TXTCDOT

Short text for causes - TXTCDUR

Short text for Activities - TXTCDMA

Also for Activity long text, I need the full text in the report.

Mahee

Former Member
0 Kudos

Mahee,

QPCT would contain the short text for all catalogue codes.

.If you are looking for short text associated to Notification Item, activities, Objects and causes look at table QMFE,QMMA,QMSM,QMUR.

You will have to use the "read_text" FM to get any long text.You should be able to get the key for the FM from the header information.

Regards

Narasimhan

Former Member
0 Kudos

Narishman,

I have already looked at all the tables that you have mentioned and do not see any of the fields which I listed below. I need short text for objects,causes and activities.

I could see activity text and cause text in QMUR and QMMA but those are different than what I need. I am looking for "Short text " and not just the Text. Please see the field names for references.

Mahee

Former Member
0 Kudos

Mahee,

These are the following additional short text fields available in standard

Notification item short text: QMFE-FETXT

Cause text: QMUR-URTXT

Task text: QMSM-MATXT

Activity Text: QMMA-MATXT.

The text associated to the catalogue codes for Object, Damage, cause,task and activity are all found in table QPCT.

There is no other short text available in standard.

Regards

Narasimhan

Former Member
0 Kudos

Narishman,

I got all the fields that you have mentioned in my report already. What I am looking for is..lets say if you click the activities tab in PM notification, you will have fields like code group, code ,activity CODE text and activity text. Here, I could able to get the fields for code group, code, activity text but not the Activity CODE text. Similar to this, if you see in objects and causes, there will be a short text in there. This short text is automatically populated as soon as I select the code group in activties or causes. When i press F1, I find the field TXTCDOT,TXTCDUR,TXTCDMA. I wanted to know where these are coming from ?

Mahee

Former Member
0 Kudos

Mahee,

You are referring to either the Code group text which is found in table QPGT or Code text which is found in table QPCT.

Thanks

Narasimhan

peter_atkin
Active Contributor
0 Kudos

[Useful info|;

PeteA

Former Member
0 Kudos

Check transaction IW65