ABAP Order status table and sql

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