Hai,

[Former Member]

Hi all,

How to Extract the Production Order System Status Table

Thanks in advanse,

Malini.

[Former Member]

Hi,

Try this

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

Reward points if found helpfull...

Cheers,

siva.