Skip to Content

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

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...

zpm138-report.png (11.4 kB)
aufm.png (33.6 kB)
Add a comment
10|10000 characters needed characters exceeded

Related questions

1 Answer

  • Best Answer
    Posted on Oct 29, 2019 at 06:36 AM

    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..

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.