Deleted Item Codes from Sales Order

[kedalenechong]

Hi All

Is there any way to trace all deleted Item Codes from Open or Closed Sales Orders?

[kothandaraman_nagarajan · Accepted solution]

Hi,

Try with below query to find deleted item from sales order,

SELECT T0.[DocNum], T1.[ItemCode] FROM ADOC T0 INNER JOIN ADO1 T1 ON T0.[DocEntry] = T1.[DocEntry] left join RDR1 T2 on T2.[DocEntry] = T1.Docentry and T2.[LineNum] = T1.[LineNum] left JOIN ORDR T3 ON T2.[DocEntry] = T3.[DocEntry] WHERE T0.[ObjType] = 17 and T2.[ItemCode] not in ( select T1.Itemcode from ADO1 T1 where T1.Docentry = T2.Docentry ) group by T0.[DocNum], T1.[ItemCode]

Regards,

Nagarajan

[former_member798634 · Accepted solution]

Hi Nagarajan,

Please help me if you can.

If i execute the query, the pane freezes.

Hope you can help me.

Regards.
Mark Oenema

[jitin_chawla]

Hi,

Check the following:

select LogInstanc, * from ADOC where ObjType = '17' and DocNum = 'xxx'

You can refer to the following thread as well:

https://archive.sap.com/discussions/thread/1238760

regards,

Jitin

[kedalenechong]

Hi Jitin

Thanks for reply.

Actually we need to trace in which Sales Order a specific item code has been deleted.