Community
Application Development and Automation Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Read only

Values for various work order status

Former Member

‎2007 Feb 13 7:24 AM

0 Likes
2,223

Hi Guys,

In AUFK table(which is the order master data table), there is a field ASTNR, which indicates the order status.

But I couldn't get any values for each status of the orders.

If anyone knows the status and the value for the corresponding status of the order, please let me know.

</b> I specifically want the value of ASTNR, for which the status is Closed </b>.

Points will be awarded for helpful answers...

Thanks and regards,

SP.

Hi Guys,

In AUFK table(which is the order master data table), there is a field ASTNR, which indicates the order status.

But I couldn't get any values for each status of the orders.

If anyone knows the status and the value for the corresponding status of the order, please let me know.

</b> I specifically want the value of ASTNR, for which the status is Closed </b>.

Points will be awarded for helpful answers...

Thanks and regards,

SP.

Reply
4 REPLIES 4
Read only

Former Member

‎2007 Feb 13 7:28 AM

0 Likes
1,455

Check table TKO03. It contains the order status values by order type. Might help...

~Kiran

Read only

Former Member
In response to Former Member

‎2007 Feb 13 8:30 AM

0 Likes
1,455

Hi Kiran,

I couldn't find out any values in table TKO03.

My actual requirement is to get all closed work orders from AUFK table.

So what is the value of ASTNR , if the status = closed.

If it is possible to find out the values for other status like 'Created', 'Released','Technically completed', then it will be great.

Expecting helpful replies from you all...

Regards,

SP.

Read only

Former Member
In response to Former Member

‎2007 Feb 13 8:43 AM

0 Likes
1,455

Hey,

ASTNR is not the field you should be evaluating for your requirement. You should look into the system/user status tables of the work order.

The system status master table is TJ02T and the user status master table is TJ30T. To derive the user statuses assigned to work order you need to know the status profile assigned to the work order type.

The various statuses assigned to a work order in its entire life cycle can be found in the table JEST.

In your case first get the user status code from the TJ30T table and then get all records from JEST for the derived user status code. JEST-OBJNR contains the work order number.

~Kiran

Read only

Former Member
In response to Former Member

‎2007 May 15 7:29 AM

0 Likes
1,455

Hi Kiran,

Thanks a lot for your help.

JEST table contains all the work order status throughout its lifecycle.

Regards,

SP.