on 04-10-2008 6:31 AM
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
HI Siddharth,
I tried using se11 & the table CDHDR, but it shows no result found matching ur requirement. What conclusion should i draw?
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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.)
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
88 | |
7 | |
6 | |
4 | |
3 | |
3 | |
3 | |
3 | |
3 | |
3 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.