Extract the Producton Order System Status Table

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

More Function Module
Functions / SAP Script / ALV

Tables
Database Table

ABAP Books List
ABAP/4 Certification, Programming, Smartforms, Sapscripts and Object Oriented Programming Books

Smart Forms
SAP Smartforms

ABAP Menu:
ABAP Example Hints and Tips

Return to Index:-
SAP ABAP/4 Programming, Basis Administration, Configuration Hints and Tips

(c) www.gotothings.com All material on this site is Copyright.
Every effort is made to ensure the content integrity.  Information used on this site is at your own risk.
All product names are trademarks of their respective companies.  The site www.gotothings.com is in no way affiliated with SAP AG.
Any unauthorised copying or mirroring is prohibited.