Knowledge Management

Question:
Dear Friends
We have Maintenance plans which have more than one Maintenance items assigned. Each maintenance item has an object list. The requirement is to view the list of Maintenance plans with the assigned Maintenance items and Object list.
If I use IP03, the problem is that i need to select each Maintenance item to view the object list. To overcome the problem, I tried creating a query with the selection as Maintenance plan. The query did not work as probably I was using the wrong tables (MPOS & MPLA).
In simple terms my requirement is to have a selection on Maintenance plan and the output should show all the Maintenance items & connected object list.
Creating a report is one option, can this be achieved thru a query???Could anyone provide guidance on this
Regards
ASR
Answer:
Hi ASR
I managed it by means of query.
I used logical database WPI. My layout is normal query output - could not switch it to ALV layout.
any specific requirements?
c
Answer:
ASR,
ABAP Query and Quickview (SQVI) are good for simple reports.
The main drawback is that there is no follow-on functions. For example: you cannot double click into the object (plan, item, order etc), you cannot add buttons for additional functionality.
If you need the list to provide additional functions, then you will need to create a custom ABAP program.

Answer:
Hi C
Thanks for the reply on the usage logical database. I was able to extract the required information.
Thanks to PJA for the advise on the advantage of using a ABAP report over a query.
Regards
ASR
Answer:
I have to add that in Query you can double-click and go through it to desired transaction or report but only for key fields...