Skip to Content
author's profile photo Former Member
Former Member

PM Tables

Is there is any relationship between the tables IMRG & ITOB ?

I would like to pick the model no(TYPBZ) and plant details(SWERK) from ITOB table with the corresponding MeasReading from IMRG table (Field Name: RECDV)...

Also pls let me know if any other tabes are with the above relations?

Thanks in advance

Rajha

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

3 Answers

  • author's profile photo Former Member
    Former Member
    Posted on May 25, 2009 at 03:14 PM

    goto t code sqvi

    Insert in both the tables.

    you will get the relation

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on May 26, 2009 at 04:27 AM

    Hi,

    From ITOB get the IMRC_POINT then

    using the IMRC_POINT get the RECDV from the VIEW /ISDFPS/MEPMIMRG .

    Hope this will help you.

    Regards,

    Smart Varghese

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on May 26, 2009 at 07:25 AM

    Hi

    Thanks for your response guys...

    actually my problem is, I want to pick model no from ITPO or EQUI with respect to Maintenance plant from ITPO..

    using this both values i should pick the corresponding MeasReading from IMRG....

    Regs

    Rajha

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member

      Hi Rajha,

      I got 24 join conditions on the first IMRG & ITOB when i drop this two tables in SQVI T-CODE,,,

      So you can try from SQVI for any tables join conditions,,,

      and remaining related tables from SE11,,

      (example you know only AFKO try to search AF* you get the remaining tables,,, Items, history, status,,,,,

      Also if you know only AFKO, then from its P-Key,AUFNR try where used list,,, now see the combination,, AF + Primary Key,,, Those all tables can be related very easily.)

      The Above mentioned are the tips & techniques which I know & use when I needed.. It may be usefull for you also...

      Thanks & regards,

      Dileep .C

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.