Table for Deleted Sub Operations

[Former Member]

Hi,

I am searching for a table which stores the sub-operation details for a given order.I have JEST table for specific order -> operations which have been deleted.Likewise I want a table which stores the values of Deteled Sub Operations of a given order.

Please suggest.

Thanks.

[Former Member]

Hi,

I am searching for a table which stores the sub-operation details for a given order.I have JEST table for specific order -> operations which have been deleted.Likewise I want a table which stores the values of Deteled Sub Operations of a given order.

Please suggest.

Thanks.

[Former Member]

Table Jest stores status. For operations, please check table AFVC - Operations within an order.

Regards,

Shyam

[Former Member]

Thanks for your prompt reply.

We are looking for a status field which will give us the value of sub-operation if it has been deleted or released.We have checked transaction IW49 & IW33.Please suggest for other tables.

[rahul_mb]

Hi,

In JEST table give the Object Number of the sub operation in the field OBJNR and check the output. Hope this is your req.

Regards,

Rahul Muraleedharan.

[Former Member]

Thanks for your prompt reply.

JEST has a OBJNR field,but when I compare the value of AFVC-OBJNR the values are different.So we cannot have a key field to compare the two tables?

They have already used JEST table to check order status in the code.

Please suggest for any other option.

[rahul_mb]

Hi,

Can you please tell where does the field AFVC-OBJNR comes in tcode IW32?

Regards,

Rahul Muraleedharan.

[Former Member]

Hi Rahul,

AFVC-OBJNR has been used in the code.They have just used 2 tables,AFVC,AFKO & 1 View VIAFVC.Now when they have included JEST table,its just to ""check order status"".

Please suggest if in the above scenario I can use some table to exculde the sub-operations with the system status as ''DLT REL''

Thanks for your replies

[Former Member]

Hi,

Fetch the Object number (field OBJNR) from table AUFK, depending on Production order number.

Then fetch the data from JEST , depnding on object number found from AUFK and status (say for example I0002), as shown below :

• fetch the data from JEST table for object status

SELECT SINGLE objnr " Object number

stat " Object status

inact " Indicator: Status Is Inactive

FROM jest "Object Status table

INTO ws_jest

WHERE objnr EQ w_aufk-objnr

AND stat EQ k_i0002.

Please let me know if any details are needed.

Regards,

Darshana

[Former Member]

Thanks for your prompt reply.

This code has already been included in the program.

For example we have a folowing scenario:

Order Operation sub-operation system status

123 220 10 DLT REL

123 220 15 DLT REL

123 220 40 REL

We don't want the line item with system staus as DLT REL to be there in the internal table.I need a option for this so that I can include a check in the select & remove the sub-operations which are deleted from the internal table.

Thanks.