Track the deleted operations maintained on a work order

[Former Member]

Hello All,

I am creating a task list for a given workorder and fetching operations maintained on that workorder from tables AFVC and AFVV.

Certain operations are deleted in the workorder but these appear in task list. There isn't any delete indicator maintained in these tables to check if the operations are deleted. Is there a way to check wether an operation is deleted while actually getting them from the tables mentioned above?

I have found a delete flag, but still it brings all the deleted operations. Couldn't reason why.

Any help regarding the above issue will be highly appreciated.

Regards,

Farheen

Edited by: Farheen Fatima on May 8, 2009 8:08 AM

[Former Member]

HI Farheen

I was stock in same problem.

You can solve with join 2 tables.

It's afvc and jest.

there is status of task (object) in jest.

ex)

afvc as a

inner join jest as b

on a.objnr eq b.objnr

and b.stat = 'I0013'

i hope that it can be a Ur answer.

bye

[Former Member]

Hey Kim,

This issue has been resolved; I have implemented the same but thanks anyways for answering

Regards,

Farheen