How to identify production order operation records that marked for deletion

[Former Member]

Hi all,

Can anyone give us a hint abouth how we can differantiate marked for deletion production order operation records in the database for manually added operations to production order ? Table AFVC contains all operation records for production order both active and marked for deletion ones. However since _manually added AFVC operation records do not have PLAS records we cannot use LOEKZ field of PLAS in order to identify records marked for deletion.

Thanks in advance.

Levent Arslan

[Former Member]

Hi Levent Arslan,

AFVC -> shows all opearations including deletion records for Order.

S022 - > shows only active opeartions for Order.

U can differantiate this way

PLAS table is related to routing masted data, changes in Production order will not be updated this tabel.

I hope this will solve ur problem, ifso Please close the thread and reward.

Regards

Pradeep

[Former Member]

Dear Kumar,

I've checked S022 table but it is empty ! I got hundreds of records in AFKO and AFVC but nothing in S022. Can the table name be incorrect ?

[ManjeetSingh]

working