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 28.JPG

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.

29.JPG

Click Execute Icon 31.JPGelse 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.

30.JPG

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 31.JPGelse Press F8.

33.JPG

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

34.JPG

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.

Document

Change doc. Object

Accounting Document (FI)

BELEGV

Sales Order (SD)

VERKBELEG

Purchase Order (MM)

EINKBELEG

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

35.JPG

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.

36.JPG

Click Execute I con or press F8

37.JPG

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.

38.JPG

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.

39.JPG

Click Execute I con or press F8.

40.JPG

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.

41.JPG

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

42.JPG

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

To report this post you need to login first.

43 Comments

You must be Logged on to comment or reply to a post.

    1. Lakshmi Kumari Sama Post author

      Hello Sampat,

      Thanks alot and please review the same by providing your valuable feedback alog with rating 😆 . Suggessions are always welcome

      Regards,

      Lakshmi S

      (0) 
    1. Lakshmi Kumari Sama Post author

      Hi Arshiyan,

      Thanks alot for your appreciation and req u to pls go through n review the doc to give your valuable suggestions along with ur rating.

      Regards,

      Lakshmi S

      (0) 
    1. Lakshmi Kumari Sama Post author

      Hi Marithi,

      Thanks alot for reading this doc and requesting you to please review the doc to give your valuable suggestions along with your rating 🙂

      Regards,

      Lakshmi S

      (0) 
  1. Adi Orlan

    Hi Lakshmi,

    The documents are great!


    I have a question regarding S_ALR_87012293.

    I have a list of 137 deleted parked invoices which were created on fuscal year=2014.

    I filled in the report the following parameters:

    Relevant company code, fiscal year=2014, document type = RE.

    The flags for “Document header data” and “Line item data” are marked.

    I get “List contains no data”.

    Do you have any idea why?

    (0) 
    1. Lakshmi Kumari Sama Post author

      Hello Adi,

      Aplology for the late reply. Actullay i am busy with my current project deliverables so i didnt get time to check your query.

      Can you pls confirm me the Document Type – Parked cocuments ?

      You have to select the parked documents tab in the document type. Please check this and give other parameters like co.code,doc.type,fiscal year details.

      Please try accordingly and revert us if you still face any issues.

      Thanks & Regards,

      Lakshmi S

      (0) 

Leave a Reply