Skip to Content
author's profile photo Former Member
Former Member

Deleted Order

Hi All,

End use was trying to create a billing & was getting an error. On verification i found that the order was deleted. Now we want to atleast know who deleted the order. Is there any provision to atleast know who deleted the order (ie through which login) & when

Add a comment
10|10000 characters needed characters exceeded

Related questions

7 Answers

  • author's profile photo Former Member
    Former Member
    Posted on Apr 10, 2008 at 05:38 AM

    Hi,

    Individually

    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.

    regards,

    Siddharth.

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Apr 10, 2008 at 05:38 AM

    hi shailendra,

    i have some doubts still in your question

    1) if the sales order is deleted then with reference to what was the end user trying to create billing document ? Say its a delivery document, an order cannot be deleted when a subsequent doc ie delivery is existing. So it means delivery is also not there. since order and delivery both are deleted in this hypothesis so with what reference the billing is being created.

    2) But to corner the user who deleted the sales order, check with basis, since there would be a continous recording of all the tasks being done by users on a PRD servers. In most cases, there would also be a back up job running where you can find the document still. Also check with basis who all users have the permission for VA02 t.code. with that clue proceed furhter who would be working on that sales process.

    But once a document is deleted unless you cannot find any data with respect to that. Even if you know the number it would only tell the doc is deleted if you try to display it.

    regards

    sadhu kishore

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Apr 10, 2008 at 05:39 AM

    Dear Shailendra,

    Go to transaction VA02 enter the sales order go to menu >Environment>Click on Changes-->System will take you to the Display document changes sreen here you can enter specifications then execute system will give the details of who made the changes.

    I hope it will help you

    Regards,

    Murali.

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Apr 10, 2008 at 05:41 AM

    Dear Sahilendra

    Go to VA03 and put any existing sales order and go to Environment->Changes there you can put your deleted sales order in selection and your will get all the details, who deleted , when it was deleted ...etc

    Regards

    Jitesh

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Apr 10, 2008 at 06:28 AM

    Hi All,

    The billing is "Order related" as it is a service which is rendered to the customer. Hence billing is done from order & no delivery is done.

    The error which is shown while using VA02 & VA03 is "Sales Doc ........ is not in database or has been archived". I just want to find out who has deleted this. May be i might have to take the help of BASIS to see the log. (I don't want to see the contain of the order only want to know who i.e. the user has deleted the order.)

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Apr 10, 2008 at 07:00 AM

    Dear Shailender,

    The Basis guys run a log which captures all the acivities being run in production server.

    Along with the User Name time and date along with the T-code executed and the transaction.

    So, with the help of basis team u can find the user who had deleted the record.

    The system will not give the details of the deleted sales order from the display sales order screen.

    Thanks and regards,

    Ranjith

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Apr 10, 2008 at 07:09 AM

    HI Siddharth,

    I tried using se11 & the table CDHDR, but it shows no result found matching ur requirement. What conclusion should i draw?

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.