topic Re: Released Process Order in Application Development and Automation Discussions

Released Process Order

Former Member — Sun, 20 May 2007 16:18:19 GMT

Hi All,

From Which table we can fetch the RELEASED Process Orders.

Regards

Deekshitha.

Re: Released Process Order

Former Member — Sun, 20 May 2007 16:24:16 GMT

Hi Deekshitha,

Just by joining the tables AUFK and JEST you will get all released process orders.

select a_{AUFNR b}status into table ITAB from AUFK as a join JEST as b

on a_{objnr = b}objnr

where a~aufnr in s_aufnr and

b~status = 'REL'.

Check the field name in JEST table (status).

~from forum.

Reward points if useful.

Thanks

Aneesh.

Re: Released Process Order

Former Member — Sun, 20 May 2007 18:06:54 GMT

Just Use function module :

Status_read by passing your aufnr value and you will get list of status from JEST Table..

main tables are : AUFK,JEST.

Reward Points if it is helpful

Thanks

Seshu

Re: Released Process Order

Former Member — Mon, 21 May 2007 00:01:08 GMT

Hi Deekshitha

There are 2 scenarios that i can see here :

1. I assume that you have a list of orders with you say in s_aufnr and you want to

check which one of those have a system status of REL i.e. Released.

a. Goto table AUFK to get the list of object numbers(OBJNR) for all the orders

b. Use FM 'STATUS_READ_MULTI' for getting all the statuses for the orders.

CALL FUNCTION 'STATUS_READ_MULTI'

EXPORTING

CLIENT = SY-MANDT

ONLY_ACTIVE = 'X'

ALL_IN_BUFFER = ' '

GET_CHANGE_DOCUMENTS = ' '

NO_BUFFER_FILL = ' '

TABLES

OBJNR_TAB = gt_objnr

status = gt_status

JSTO_TAB =

JCDO_TAB =

JCDS_TAB =

This is an unrealeased FM from SAP but can always be used to read data.

c. Once you get the list of object numbers with statuses , for each object

number read table gt_status to see if it has a STAT = 'I0002'. If yes then this

order is a released process order . We take I0002 value to compare

because if you see table TJ02 that has all system status values , you will see

that I0002 stands for 'REL' which means released.

In this way you will be able to get all the object numbers and corresponding

orders which have a status 'REL'.

2. The second scenario is where I assume you do not have a list of orders with

you and you still want to find out the orders which have a status of 'REL'.

In this case:

a. Goto table JEST and get all the object numbers for which STAT = 'I0002' and

INACT NE 'X'.

b. Goto table AUFK and for the object numbers obtained above and you can get

the corresponding order numbers(AUFNR).

I hope this helps. If so please reward some points .

Cheers

shivika