Skip to Content
Author's profile photo Lakshmi Kumari Sama

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 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

Assigned Tags

      43 Comments
      You must be Logged on to comment or reply to a post.
      Author's profile photo Arvind Pereira
      Arvind Pereira

      This info is very useful Lakshmi

      Author's profile photo Lakshmi Kumari Sama
      Lakshmi Kumari Sama
      Blog Post Author

      Hi Arvind,

      Thanks alot 🙂

      Regards,

      Lakshmi S

      Author's profile photo Arvind Pereira
      Arvind Pereira

      Good job Lakshmi

      Author's profile photo Vinod Vemuru
      Vinod Vemuru

      Good Info Lakshmi. Keep contributing 🙂

      Thanks,

      Vinod.

      Author's profile photo Lakshmi Kumari Sama
      Lakshmi Kumari Sama
      Blog Post Author

      Hi Vinod,

      Thanks alot for your encouraging appreciation 🙂

      Regards,

      Lakshmi S

      Author's profile photo Former Member
      Former Member

      Nice Information 🙂

      Thanks

      Sudhir Krishna Kumar Singh

      Author's profile photo Lakshmi Kumari Sama
      Lakshmi Kumari Sama
      Blog Post Author

      Thanks Sudhir 🙂

      Author's profile photo Ranu Eugene
      Ranu Eugene

      Hi Lakshmi,

      Good job done and good Doc.

      Thanks for sharing.

      Keep up the Good work. 🙂

      Best of Luck. 🙂

      Regards,

      Eugene

      Author's profile photo Lakshmi Kumari Sama
      Lakshmi Kumari Sama
      Blog Post Author

      Hi Ranu,

      Thanks for your appreciation 🙂

      Regards,

      Lakshmi S

      Author's profile photo Shakeeluddin Khaja
      Shakeeluddin Khaja

      Good and helpful information. Thanks Lakshmi.

      Regards,

      Shakeel.

      Author's profile photo Lakshmi Kumari Sama
      Lakshmi Kumari Sama
      Blog Post Author

      Hi Shakeeluddin,

      Thanks 🙂 for reviewing the doc.

      Regards,

      Lakshmi S

      Author's profile photo Lakshmi Kumari Sama
      Lakshmi Kumari Sama
      Blog Post Author

      Hello All,

      Requesing you all to review the doc and provide your valuable feedback along with the rating.

      Regards,

      Lakshmi S

      Author's profile photo Former Member
      Former Member

      Thanks for the information it's Nice and very informative..

      Author's profile photo Lakshmi Kumari Sama
      Lakshmi Kumari Sama
      Blog Post Author

      Hi Siraj,

      Thanks alot and requesting you to please give the rating for this document.

      Regards,

      Lakshmi S

      Author's profile photo Erwin Leitner
      Erwin Leitner

      Hello!

      GREAT! Thank you very much for sharing excellent knowledge.

      all the best

      Erwin

      Author's profile photo Lakshmi Kumari Sama
      Lakshmi Kumari Sama
      Blog Post Author

      Hello Erwin,

      Thanks alot for your encouraging comments.

      Regards,

      Lakshmi S

      Author's profile photo Former Member
      Former Member

      Hi..

      Good doc..thanks for sharing...

      Author's profile photo Lakshmi Kumari Sama
      Lakshmi Kumari Sama
      Blog Post Author

      Hello Teran,

      Thanks alot and requesing you to please provide your feedback along with the rating 🙂

      Regards,

      Lakshmi S

      Author's profile photo Sampat Kumkar
      Sampat Kumkar

      Hi Lakshmi

      Nice documents..thanks for sharing

      Regards

      sampat

      Author's profile photo Lakshmi Kumari Sama
      Lakshmi Kumari Sama
      Blog 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

      Author's profile photo Sampat Kumkar
      Sampat Kumkar

      Ok...

      Done

      Author's profile photo Lakshmi Kumari Sama
      Lakshmi Kumari Sama
      Blog Post Author

      Thanks Sampat 🙂

      Author's profile photo Raman Korrapati
      Raman Korrapati

      Thanks for sharing your knowledge.

      Author's profile photo Lakshmi Kumari Sama
      Lakshmi Kumari Sama
      Blog Post Author

      Hi Raman,

      Thanks alot and requesting you to pls review the doc and provide your valuable suggestions along with suitable rating 🙂

      Regards,

      Lakshmi S

      Author's profile photo Former Member
      Former Member

      Gr8. I feel so lucky that I have read today an other new doc related to my work. Thanks for sharing n keep it up buddy.

      Arshiyan

      Author's profile photo Lakshmi Kumari Sama
      Lakshmi Kumari Sama
      Blog 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

      Author's profile photo Srinivasa Borigi
      Srinivasa Borigi

      Hi,

      Yours is very detailed presentation, how can you claim yourself as a BEGINNER???

      🙂

      Regards,

      Srinu

      Author's profile photo Lakshmi Kumari Sama
      Lakshmi Kumari Sama
      Blog Post Author

      Hello Srinivasa,

      Thanks alot for your time to reading this doc and your words are really appreciating me.

      Regards,

      Lakshmi S

      Author's profile photo Former Member
      Former Member

      Thanks .

      its very helpful .

      Regards | Maruthi

      Author's profile photo Lakshmi Kumari Sama
      Lakshmi Kumari Sama
      Blog 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

      Author's profile photo Former Member
      Former Member

      Hi Lakshmi,

      Good doc. Good Job.... 🙂

      Author's profile photo Lakshmi Kumari Sama
      Lakshmi Kumari Sama
      Blog Post Author

      Hello Balaji,

      Thanks alot and pls review the document to provide your valuable suggestions along with your rating.

      Thanks & Regards,

      Lakshmi S

      Author's profile photo Former Member
      Former Member

      Hi Lakshmi,

      It is very good document and useful.

      Thanks for sharing the valuable document .. 🙂

      Author's profile photo Lakshmi Kumari Sama
      Lakshmi Kumari Sama
      Blog Post Author

      Hello Venkateshwarlu,

      Thanks alot and pls review the doc to provide your valuable feedback.

      Regards,

      Lakshmi S

      Author's profile photo Godavari SAP
      Godavari SAP

      Hello Lakshmi,

      Thanks for sharing quite useful information. It would be good, if you add Workflow tcodes used by FICO Consultants.

      Thanks

      Author's profile photo Consultant Khan
      Consultant Khan

      Hi Lakshmi,

      Very useful documents (Part 1 & 2).

      Keep up the good work.

      Regards

      KIM Khan

      Author's profile photo Lakshmi Kumari Sama
      Lakshmi Kumari Sama
      Blog Post Author

      Hello KIM,

      Thanks alot 🙂

      Regards,

      Lakshmi S

      Author's profile photo Former Member
      Former Member

      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?

      Author's profile photo Lakshmi Kumari Sama
      Lakshmi Kumari Sama
      Blog 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

      Author's profile photo Former Member
      Former Member

      Hi Lakshmi,

      Very useful Doc.

      Thanks for Sharing.

      Regards,

      Ramesh

      Author's profile photo Lakshmi Kumari Sama
      Lakshmi Kumari Sama
      Blog Post Author

      Hi Ramesh,

      Thanks for your comments.

      Regards,

      Lakshmi S

      Author's profile photo Lokesh Earla
      Lokesh Earla

      Hi Lakshmi,

      Excellent document !!! keep up good work 🙂

      Regards,

      Lokesh Earla

      Author's profile photo Lakshmi Kumari Sama
      Lakshmi Kumari Sama
      Blog Post Author

      Hello Lokesh,

      Thank you so much!

      Regards,

      Lakshmi S