Table in which deleted operations are stored.

[Former Member]

Hi,

We are writing a report and for that i need the value of work hrs , so i would like to know in which table deleted operations of Maintenance order are stored ....

regrds

pm

[paul_meehan]

Hi,

All the operations time values are found in AFVV, this includes the deleted operations. Also read AFVC for operation number, etc. The key to both these tables is AUFPL field (available in AFKO via order number).

To decide if a particular AFVV record is deleted or not it is necessary to look at the JEST table. JEST can be accessed via Object Number, this has the format OV + AUFPL + APLZL. If the entry with status I0013 is active (no inactive flag) then this operation is deleted.

-Paul

[peter_atkin]

From memory, if the operations are deleted before release (REL), then they are deleted completely from the database..

Please do a check to confirm this...

PeteA

[Former Member]

Hi,

Yes before release it is not stored in table AFVV .. , but i could find an entry in change documents with change ID as D but they are not values related to work hrs ..., so here i am clear on how to get deleted operations after rel but before release how do we get ?

regrds

pm

[Former Member]

Hi All,

Any inputs ?

regrds

pm

[Former Member]

hi

Before Release of order system doesnt store change records so you wont get change history.

[peter_atkin]

It may be that SAP doesn't store this data in the change documents. Have a look on OSS to see if there is anything relating to this issue.

However, its relatively simple to develop a solution of your own to post change document information. This could be done when saving the order.

PeteA

[Former Member]

Hi,

The deleted operations are indicated as deletion flag in the AFVGD structure.

The filed AFVGD -LOEKZ is the key to identify the deleted operations.

If the flag is set in the structure, the operation already deleted.

Regards,

Sonai