PM Tables

[Former Member]

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

[Former Member]

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

[gautam_totekar]

goto t code sqvi

Insert in both the tables.

you will get the relation

[Former Member]

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

[Former Member]

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

[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