topic PM Tables in Application Development and Automation Discussions

PM Tables

Former Member — Mon, 25 May 2009 14:00:23 GMT

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

Re: PM Tables

gautam_totekar — Mon, 25 May 2009 15:14:49 GMT

goto t code sqvi

Insert in both the tables.

you will get the relation

Re: PM Tables

Former Member — Tue, 26 May 2009 04:27:39 GMT

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

Re: PM Tables

Former Member — Tue, 26 May 2009 07:25:25 GMT

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

Re: PM Tables

Former Member — Tue, 26 May 2009 08:07:52 GMT

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