how to link planned services with services actuals item wise for Maintenance Order

[former_member185116]

Hello all,

our requirement is to generate a report containing PM order(Maintenance Order) with Plan qty, plan cost and actual qty , actual cost as shown below,

for a given PM Order i could get the plan qty , plan cost (material components) from RESB table ,

service components from AFVC , ESLH and ESLL table..

for getting actual s i am using table AUFM,

if i pass Order number to AUFNR field iam able to get corresponding actuals of that particular PM Order.

In order to show plan and actual's side by side i need to link by some reference,

for material components i used RSNUM , RSPOS fields to link plan and actual's(i.e qty and cost),

where as for linking services i.e for linking services in Plan with services in actual's i could not find a unique matching field

like RSNUM field for material components..

Now my question is how do i link planned services which are obtained from (AFVC, ESLH and ESLL) with actual

services which are obtained from (AUFM, passed ebeln field of AUFM to ESLH and got services from ESLL)...

how do i link services item wise..

please can any one suggest a solution for this..

thanks in advance...

[former_member185116 · Accepted solution]

I found a solution myself and i shared the solution through blog post

Displaying Plant Maintenance Order Plan/Actual Line Item Wise

I am closing the thread..

Thank you all..