Get EQUNR from ANLAGE

[ricky_shaw]

Hi, I need to fetch the Equipment# from Installation(Anlage) to find out the equipment type(EQTYP). I see that i need to query 4 or 5 tables like EANLH,EASTL,EGERH & EQUI. Can any one suggest me an FM or a BAPI  to get this ? Thanks Rick

[former_member213018 · Accepted solution]

Please check if this helps:

ISU_DET_DEVICE_FROM_INST

[ricky_shaw]

OOPs, I want the other way round.

I have equipment and I want to find out the Installation or Contracts from EQUNR.

Can some suggest plss...

Thanks

[Former Member]

Hi Ricky,

Pass the equipment no in EGERH table and get Logical device no (LOGIKNR).

Pass this logical device no in the FM "ISU_GET_OBJECTS" device field.

You will get contract and installation

Regards,

Chandandeep.

[ricky_shaw]

Hello Experts,

Using this FM: ISU_DET_DEVICE_FROM_INST I am able to get the active devices. But in case of device removal this FM is NOT show the devices associated to the installation.

Is there any similar FM or what is the other way to get the removed devices?

Pls suggest.

[Former Member]

Hi Ricky,

Not sure about the availability of the FM, but you can achieve this using the tables EASTL and EGERH and EQUI. First select will be on EASTL where you pass the installation no and get the logical device no and ab and bis fields . Pass this data to EGERH to get the removed Equipment no.

then pass this equipment no in EQUI to get the device no.

Regards,

Chandandeep.