code for Production order system status

Extract the Producton Order System Status

tables: aufk "Order master data
jest, "Object status
tj02t. "Status Description

* Order Status - To Retrieve & Filter
select stat from jest
where objnr = aufk-objnr " objnr means object no
and stat in ('I0012', 'I0045', 'I0074', 'I0076')
and inact ne 'X' "Flag: Status inactive
order by stat.

select single * from tj02t
where istat = jest-stat
and spras = 'E'.