Hai,

Former Member — Thu, 17 Jan 2008 05:37:40 GMT

Hi all,

How to Extract the Production Order System Status Table

Thanks in advanse,

Malini.

Re: Hai,

Former Member — Thu, 17 Jan 2008 07:05:05 GMT

Hi,

Try this

tables: aufk "Order master data

jest, "Object status

tj02t. "Status Description

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.