2012 Jul 25 9:16 AM
Hello All
We are facing an issue with end user, User has made sale order, Billing Document etc . and deleting the same. How can I find out which user has deleted the specific document and what are the data's included on the same doc.
It would be highly appreciated anyone can give me the solution
Thanks
Engli
Hello All
We are facing an issue with end user, User has made sale order, Billing Document etc . and deleting the same. How can I find out which user has deleted the specific document and what are the data's included on the same doc.
It would be highly appreciated anyone can give me the solution
Thanks
Engli
2012 Jul 25 9:29 AM
Hiii ,
check history table CDHDR and CDPOS table your object for vbrk and vbrp table is - Vbrk - FAKTBELEG , Vbrp - VERKBELEG . with CHANGE_IND = 'D' .
2012 Jul 25 9:36 AM
Hello Ashish
That's fine but how can do Verify those Document contained what are the items.
Thanks
engli
2012 Jul 25 9:37 AM
Hi Yoonus,
You can get details on deleted sales document/billing document from the table CDHDR/CDPOS.
You can get the changed by (User name of the person responsible/deleted by) and document number from CDHDR. For sales order, CDHDR-OBJECTCLAS = 'VERKBELEG' and CDHDR-OBJECTID = <sales document number>.
You can get the details from CDPOS by passing OBJECTCLAS and CHANGENR from CDHDR to CDPOS.
Cheers
~Niranjan
2012 Jul 25 9:45 AM
Hello Niranjan
this should not provide which item has deleted, only showing which line item , but I want to know which was that item.??
Thanks
engli
2012 Jul 25 9:58 AM
Hi,
Did you checked the CDPOS entries? Table key in CDPOS is the concatenation of client, sales document and line item.
You can get the line item number from the CDPOS.
I am not sure about getting all the sales order details after deleting. Because deleting of the document will wipe out the table entries from VBAK/VBAP also,
Cheers
~Niranjan
| User | Count |
|---|---|
| 3 | |
| 1 | |
| 1 | |
| 1 | |
| 1 | |
| 1 | |
| 1 | |
| 1 | |
| 1 | |
| 1 |