How to Trace the History of Deleted Parked Documents : Part – II

This blog is a continuation to the earlier blog “How to Trace the History of Deleted Parked Documents : Part – I”

http://scn.sap.com/docs/DOC-48771

C.2. S_ALR_87012293 – Display of Changed Documents: – This S_ALR_87012293 standard report provides a list of the document changes. And it doesn’t tell anything about the vendor or customer pertaining to which the report caters to and the value of document also. Please give the following details.

Document Type: – Parked documents

General selections:-

          Mandatory fields: – Company code, document number & Fiscal years

          Optional Fields: – Changed on & Changed by

Receiving Co. code – Useful only for Cross- CC transactions

Further Selections: – If you are aware of the data exactly so give the data here else just click the document header data, line item data.

Click Execute Icon else Press F8.

Then the following screen will appear which contains the details of co. code, entry date, entered on, doc. no., fiscal year, user name and line items got deleted.

C.3. BKPF Table – Accounting Doc Header: – This BKPF table stores data at accounting document header level. With the help of this table we can easily trace the no. of documents posted for a company code in period wise in a year or whole documents in a fiscal year. Doc. header text, date of posing, doc. status, reversal doc. no, reversal date and transaction code used to post the document, user id who got posted this document.

Go to SE16 t code and give this table and press Enter then the following screen will appear. Please give the following fields as stated below.

Mandatory fields: – Company code, document number & Fiscal years

Optional Fields: – Document type, document date, posting date and period

Here in our e.g. I am aware of the exact details of posting date of parked document, doc. Type and period so I am giving all these details.

Click Execute Icon else Press F8.

Just double click the line item then the following screen will appear.

Here please observe the document status as Z – Parked document which was deleted

C.4. CDHDR Table – Change document header: – CDHDR table is a header table to store change documents and it is a transparent table. So you cannot join CDHDR and CDPOS tables directly. Generally, old change documents from these tables are always archived for better performance of inserting data. Go to SE16 t code and give this table and press Enter then the following screen will appear. Please give the following fields as stated below.

Mandatory Fields:-

Change doc. object – BELEGV (Accounting Doc). It is changing for MM, SD and FI areas. Please find the details as given below.

Objects Value – You can get this data through FBV5 t code as highlighted below.

Optional Fields:-

Date – Date of deletion of parked document else give probable date like give this as 08/01/2013.Here in our example I just gave the details which I was known very clear.

Click Execute I con or press F8

Click the line item in order to view the details (i.e. User name who got deleted this parked document, date of deletion & T code used for deletion of parked document) in a detailed manner.

C.5. CDPOS Table – Change document items: – CDPOS table has the information for the positions of the object and it stores data at line item level. It is a cluster table.

Go to SE16 t code and give this table and press Enter then the following screen will appear. Please give the mandatory fields like Change Doc. object & Object fields as shown below.

Click Execute I con or press F8.

We can trace the details by any one of the line item.Then double click on the first line item in order to view the details in a detailed manner.

After executing the screen you can observe the Change ID- D i.e. Deleted as highlighted in the below given screenshot.

Then double click on the second line item in order to view the details in a detailed manner.

After executing the screen you can observe the Change ID- D i.e. Deleted as highlighted in the below given screenshot

Hope this blog helps to give better understanding on Tracing the history of deleted parked documents.

Your valuable feed back along with the rating on this blog is most welcome

Thanks & Regards,

Lakshmi S