03-16-2010 5:31 PM
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.
03-17-2010 11:22 AM
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
03-18-2010 8:42 AM
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
03-19-2010 2:55 PM
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.
03-19-2010 4:13 PM
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