topic Table for Deleted Sub Operations in Application Development and Automation Discussions

Table for Deleted Sub Operations

Former Member — Wed, 16 Mar 2011 07:39:55 GMT

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.

Re: Table for Deleted Sub Operations

Former Member — Fri, 18 Mar 2011 04:56:42 GMT

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

Regards,

Shyam

Re: Table for Deleted Sub Operations

Former Member — Fri, 18 Mar 2011 05:18:08 GMT

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.

Re: Table for Deleted Sub Operations

rahul_mb — Tue, 22 Mar 2011 04:11:50 GMT

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.

Re: Table for Deleted Sub Operations

Former Member — Tue, 22 Mar 2011 06:50:24 GMT

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.

Re: Table for Deleted Sub Operations

rahul_mb — Tue, 22 Mar 2011 08:07:06 GMT

Hi,

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

Regards,

Rahul Muraleedharan.

Re: Table for Deleted Sub Operations

Former Member — Tue, 22 Mar 2011 09:19:33 GMT

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

Re: Table for Deleted Sub Operations

Former Member — Thu, 24 Mar 2011 09:01:13 GMT

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

Re: Table for Deleted Sub Operations

Former Member — Thu, 24 Mar 2011 10:21:15 GMT

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.