on 02-07-2011 9:03 PM
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
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
have you tried iw29 with selection variants?
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi,
You can use table VIQMFE, this information is available on this table
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
hi!
Use t code IW65.
Vaibhav Mishra
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
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
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
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
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
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
Check transaction IW65
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
85 | |
7 | |
6 | |
4 | |
3 | |
3 | |
3 | |
3 | |
3 | |
2 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.