DB table to get system status and text for PO.

[Former Member]

Hi All,

I need the table to get system status for a production order and system status text .Please help.

[Former Member]

Hi Prem,

JEST table is for system status for a production order and TJ02T table is for system status text.

Try with these fields in the above tables.

u2022 OBJNR like JEST-OBJNR object number

u2022 STAT like JEST-STAT Object status

u2022 INACT like JEST-INACT indicator status inactive

u2022 TXT04 like TJ02T-TXT04 individual status of an object

u2022 TXT30 likeTJ02T-TXT30 object status.

Hope it helps you.

Regards,

Anusha V.

Edited by: Anusha on May 26, 2009 10:22 AM

[GauthamV]

From AUFK-AUFNR get the OBJNR value and pass that value in Table JEST-OBJNR

and from STAT field you will get status of the Production Order.

Also use these tables.

TJ02

TJ02T

[Former Member]

Dear premkumar,

try this table JEST-OBJNR(Individual Object Status-Object number)and from STAT(Object status) field you will get status of the Production Order.

Cheers

fareed