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 · Accepted solution]

manually added operations will not have following field values in AFVC

PLNFL

PLNKN

PLNNR

ZAEHL

please come back if not answered

[Former Member · Accepted solution]

Thanks but problem is to differantiate the "marked for deletion" manually added operation records from the active manually added ones. So we can see wich operations manually added using the fields you've mentioned also. But we cannot identify which ones marked for deletion.

[Former Member · Accepted solution]

the marked for delition where LOEKZ = X and all other fields (manually added operations will not have following field values in AFVC - PLNFL, PLNKN, PLNNR, ZAEHL) mention empty will give manually added operation and deleted operation.

I hope it is clear

Edited by: Rajesha Vittal on Jan 3, 2008 11:46 AM

[Former Member · Accepted solution]

Hi Levent,

I doknow the reason for, not updating S022 at ur end, yes it is correct one only,

Still we have one option, please check Field BEDZL at Tabel AFVC. if u create (manually or from routing ) one operation in prod order the field has got assigned some value (Counter), once u delete that opeartion, the field becomes blank (Value has been deleted). if u set condtion BEDZL equal to "Blank" u will get list of the deleted operation from active list.

To identify Opertaion has been added manually or copeid from routing, follow as suggested By Mr Rajesha.

Please try and comeback

Regards

Pradeep

[Former Member · Accepted solution]

Dear Kumar,

Thanks for recommendation but field BEDZL is filled with 000000 for all records both marked for deletion and the active ones.Somehow she knows which AFVC records marked for deletion but this is not being kept in AFVC table directly. As a walk-arround I told users to blank out operation description before marking it for deletion.With this we can eleminate the records already merked for deletion.

Rgds.

Levent Arslan

[Former Member · Accepted solution]

Dear Vittal,

Let me explain the scenario in detail. Users are creating a production order with one standart routing operation. Than they are adding manually 2 more operations to that prod order. So prod order has 3 operation records in total in AFVC table that one comes from standart routing and two are added manually . Finally user marks one of manually added operation for deletion. So prod order has still 3 records in AFVC , but one of manually added records has already been marked for deletion.In this case it is imposible to identify which manually added operation record marked for deletion using AFVC table. On the otherhand since both of manually added records do not have PLAS records it is also imposibble to check LOEKZ field in PLAS. I hope I could explain the case.

Rgds.

Levent Arslan

[Former Member · Accepted solution]

This you can get only through status cha nge the status of del operation is DEL.

Hence you can get the object number of oprations from AFVC-OBJNR and pass ALL this to TABLE JEST-OBJNR, WITH

JEST-STAT = I0013

INACT = SPACE

YOU WILL GET THE OPERATION WHICH IS DELETED. AND AS PER EARLIER YOU CAN SEPERATE THE MANUALLY CREATED OPRATIONS

HENCE YOU GOT THE ANSWER, RIGHT?

[Former Member · Accepted solution]

Thanks lot Vittal. I've checked the JEST records and saw that deleted operations have STAT=I0013 records in that table.

Thanks again.

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