Table To Link Equipment And Class

Table To Link Equipment And Class

Which table to extract the equipment and class information?

Answer:

This table is extracted from the Logical Database EQI :

Remove the "DI" to get the table name.

Data fields     Technical name
        Log. database EQI
        Equipment       DIEQUI
        Equipment       DIEQUI
        Partner PM/QM   DIIHPA
        Permits DIIHSG
        Equipment Usage Period DIEQUZ
        Equipment Usage Period DIEQUZ
        Functional Location     DIIFLO
        Functional Location     DIIFLO
        PM Notification DIQMEL
        PM Notification DIQMEL
        PM Order        DIAUFK
        PM Order        DIAUFK
        Class   DICLASS (<- structure - table is KSSK and KLAH)
        Class   DICLASS
        Characteristic Valuation        DICLDAT
        Document        DIDRAD
        Document        DIDRAD
        Object Link     DIINET
        Object Link     DIINET
        Measuring Point: Output Structure for ABAP Lists        DIIMPT
        Measuring Point: Output Structure for ABAP Lists        DIIMPT
        Measurement Doc.: Output Structure for ABAP Lists       DIIMRG
        Measurement Doc.: Output Structure for ABAP Lists       DIIMRG

For example as per subject Title, I am trying to find the table to link the equipment master with the class overview.

Table KSSK is the right one to used. Pass the equipment number (with the Padded zeros, if the equipment number is an internal number) in the OBJKEY field of the table KSSK, you should be able to get the class (Internal class number value) along with the class type assigned to this piece of equipment.

e.g.

Equipment (EQUI-EQUNR) : 500544419

Class (KSSK-OBJEK from EQUI-EQUNR with Padded zeros) : 000000000500544419

Class Description (KLAH-CLINT from KSSK-CLINT) : 949

Notes:

Also take a look at this table, it is quite useful:

ITOB - PM technical objects (EQUI, functional location)

Have a SAP PM Problems?
SAP PM Forum - Do you have a SAP PM Question?

SAP Plant Maintenance Books
SAP PM Books - Certification, Interview Questions and Configuration

SAP PM
SAP PM Tips and Plant Maintenance Discussion Forum

Best regards,
SAP Basis, ABAP Programming and Other IMG Stuff
http://www.erpgreat.com

All the site contents are Copyright © www.erpgreat.com and the content authors. All rights reserved.
All product names are trademarks of their respective companies. The site www.erpgreat.com is in no way affiliated with SAP AG.
Every effort is made to ensure the content integrity. Information used on this site is at your own risk.
The content on this site may not be reproduced or redistributed without the express written permission of
www.erpgreat.com or the content authors.