Work orders with meter reading for a group equipment?

[former_member555449]

I am trying to get a report in PM module for Last work order with Measurement reading for a group of equipment. Can any one help me to get this detail configured? Currently I am using IW 49 to get the work order details, and in IK17 i have to take the reading details then a lot of data matching and get the details

Is there any simple way to acheive this report?

We are updating reading with every work order during confirmation

[TammyPowlas]

We created a SAP query with these tables:

With these joins:

Output these fields:

Hope this helps

[former_member555449]

I am not authorised for Report type Z_PM_MEAS_2

I can request this to our IT team

What T Code shall use to get to this screen?

Hope I can get the details of meter reading for equipment with corresponding Work Order Number.

Seeking your kind help

[NTeunckens]

See if you can use the Logical Database "EQI", which holds the Equipment / Order / Measurements data ...

The Logical DB can be Accessed either through SAPQuery (Trx."SQVI", see Screenshot) or Trx."SE36" :

Hope this helps

Nic T.

[former_member596716]

Can you not just use IK17 alone for this info? The field "Order" can be added to the report layout. That will give you the order and corresponding measurement reading for a given list of equipment.

Paul

[former_member555449]

IK17 or IK 18 both does not have the field for orders to select.

If they are available I could just select the order numbers and get the corresponding readings for the order.

[former_member555449]

I am not authorised for Report type Z_PM_MEAS_2

I can request this to our IT team

What T Code shall use to get to this screen?

Hope I can get the details of meter reading for equipment with corresponding Work Order Number.

Seeking your kind help

[TammyPowlas]

It is a custom query in our box; you will need to ask someone to build it in your system or build it yourself.