topic Document Deletion SAP in Application Development and Automation Discussions

Document Deletion SAP

former_member186190 — Wed, 25 Jul 2012 08:16:09 GMT

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

Re: Document Deletion SAP

Aashish28 — Wed, 25 Jul 2012 08:29:04 GMT

Hiii ,

check history table CDHDR and CDPOS table your object for vbrk and vbrp table is - Vbrk - FAKTBELEG , Vbrp - VERKBELEG . with CHANGE_IND = 'D' .

Re: Document Deletion SAP

former_member186190 — Wed, 25 Jul 2012 08:36:57 GMT

Hello Ashish

That's fine but how can do Verify those Document contained what are the items.

Thanks

engli

Re: Document Deletion SAP

Former Member — Wed, 25 Jul 2012 08:37:05 GMT

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

Re: Document Deletion SAP

former_member186190 — Wed, 25 Jul 2012 08:45:49 GMT

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

Re: Document Deletion SAP

Former Member — Wed, 25 Jul 2012 08:58:22 GMT

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