- SAP Community
- Groups
- Industry Groups
- SAP for Utilities
- Discussions
- Empty MRU's
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
2011 Oct 20 10:33 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
2011 Oct 21 9:18 PM
- SAP Managed Tags:
- Utilities
Michele,
You can query using se16 and excel or use SAP query (this requires programming).
1) Use se16 and excel:
- download installation timeslice from table EANLH for timeslice ending 12/31/2011 into excel and distinct them.
- download MRU from table TE422 into excel.
- use excel vlookup function to search all MRU whether it exists in table EANLH.
2) Use transaction SQ02 to create new infoset for standard query. First select TE422 data then check against EANLH table.
After that create sap query in transaction SQ01 to display empty MRU.
Regards,
Chaiphon
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
2011 Oct 21 4:19 AM
- SAP Managed Tags:
- Utilities
Can you elaborate more, what is your requirement. I mean MRU is empty doesnot make any sense.Do mean to say Scheduled records for MRU or portion ???
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
2011 Oct 21 2:22 PM
- SAP Managed Tags:
- Utilities
We are currently combining our routes by moving installations from one route to another. If I look at a route using the display transaction I can use the where used icon and see all of the installations aside to the route. I want to be able to do this using a query as we have over 1,000 routes. I want to remove the routes that no longer have installations assigned to them.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
2011 Oct 21 9:18 PM
- SAP Managed Tags:
- Utilities
Michele,
You can query using se16 and excel or use SAP query (this requires programming).
1) Use se16 and excel:
- download installation timeslice from table EANLH for timeslice ending 12/31/2011 into excel and distinct them.
- download MRU from table TE422 into excel.
- use excel vlookup function to search all MRU whether it exists in table EANLH.
2) Use transaction SQ02 to create new infoset for standard query. First select TE422 data then check against EANLH table.
After that create sap query in transaction SQ01 to display empty MRU.
Regards,
Chaiphon
