Table details for equipment replaced at functional location

[former_member407594]

Dear Team,

I have a requirement to get details at table level. There are 2 equipment's (i.e. Equipment 1 & Equipment 2) assigned to a functional location. After some time, because of some reason Equipment 1 is replaced with Equipment 3.

I want to know in which table I can get this details, that Equipment 1 is replaced by Equipment 3 and it's timestamp.

Regards,

Akshay

[NTeunckens]

I believe you would have some possibilities, depending on what you want to achieve :

• Link Equipment Time-Segment (table "EQUZ") and Maint.Object Table related to Functional Location (table "ILOA") via "ILOAN" data-field ;
• Check if there are any DataBase-Views such as "V_EQUI_EQBS" or "V_EQUI_IFLOS" that might have this data in one Table. In our System, that was not the case ...
• There is a Logical DataBase "EQI" that links a lot of Equipment-related data ... This can be accessed through SAP-Query (Trx."SQVI") or Trx."SE36".

Some info on the use of "EQI"-LogicalDB : link

See the SAP-Help websites on Logical DataBases on ways to access this DB-table trough Custom Programming if needed ...

Hope this helps

Nic T.