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'.