Application Development and Automation Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
Even though the sales order is gone from the database, you can still see the change history of who deleted the order and when. To do this (I'm on 3.1I), go to Sales Order --> Display --> put the number in and go to Environment --> Changes. Then Green check and it will tell you the history.
After the record (order) gets deleted from the database, to get a list of records deleted you will need to run a report (user defined), with the query for VBAK table, for order type and the missing numbers. The date may also be required. Once you get this, you can find out when and who changed (deleted) the documents.
Even though the sales order is gone from the database, you can still see the change history of who deleted the order and when. ?To do this?go to Sales Order> Display>put the number in and go to Environment>Changes ?- then check and it will tell you the history. Hope this helps somewhat!
As a List
Though Sales orders are Deleted, they will be available in Change document tables CDHDR for header changes and CDPOS for item changes . Changes includes deletion also.
So run a Logic based on these two tables.
You shud get a report of all deleted sales order.
Use the report in the following link to base your logic.
Even though the sales order is gone from the database, you can still see the change history of who deleted the order and when. To do this (I'm on 3.1I), go to Sales Order --> Display --> put the number in and go to Environment --> Changes. Then Green check and it will tell you the history.
After the record (order) gets deleted from the database, to get a list of records deleted you will need to run a report (user defined), with the query for VBAK table, for order type and the missing numbers. The date may also be required. Once you get this, you can find out when and who changed (deleted) the documents.
Bluesky
