Need to know in ISU - Devices in AVLB status / Stock

[Former Member]

Hi All,

I need to find the Devices which are all in Available status / Stock ....Can anyone please help to Identify the Table name where to see the Devices / MSN in ISU .

Thanks ,

Hari.

[Former Member]

Hi,

Table name to get all devices is EGERS.

In this table there is field called KZSTICH (status of device) from this you can find out status of devide.

I hope it helps you.

Regards,

Pranaya

[Former Member]

Hi,

Use the below FM to get the user and system status of device.

CALL FUNCTION 'BAPI_EQUI_GETSTATUS'

EXPORTING

equipment = gs_equi-equnr

language = sy-langu

TABLES

system_status = gt_sys_status

user_status = gt_user_status.

Regards,

Balu

[murtuza_chhatariya]

Even you can use STATUS_READ function module, pass OBJNR of the equipment, you can get it from EQUI table passing equipment number or material number and serial number combination.

[chaiphon]

Try this logic

  data: it_equnr type STANDARD TABLE OF equi-equnr.

  select equnr
         from equi inner join jest
           on equi~objnr = jest~objnr
         into table it_equnr
         where stat  = 'I0099'  " Check table TJ02T for the exact AVLB in your system
           and INACT = space.

Chaiphon