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.
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.
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
This info is very useful Lakshmi
Hi Arvind,
Thanks alot 🙂
Regards,
Lakshmi S
Good job Lakshmi
Good Info Lakshmi. Keep contributing 🙂
Thanks,
Vinod.
Hi Vinod,
Thanks alot for your encouraging appreciation 🙂
Regards,
Lakshmi S
Nice Information 🙂
Thanks
Sudhir Krishna Kumar Singh
Thanks Sudhir 🙂
Hi Lakshmi,
Good job done and good Doc.
Thanks for sharing.
Keep up the Good work. 🙂
Best of Luck. 🙂
Regards,
Eugene
Hi Ranu,
Thanks for your appreciation 🙂
Regards,
Lakshmi S
Good and helpful information. Thanks Lakshmi.
Regards,
Shakeel.
Hi Shakeeluddin,
Thanks 🙂 for reviewing the doc.
Regards,
Lakshmi S
Hello All,
Requesing you all to review the doc and provide your valuable feedback along with the rating.
Regards,
Lakshmi S
Thanks for the information it's Nice and very informative..
Hi Siraj,
Thanks alot and requesting you to please give the rating for this document.
Regards,
Lakshmi S
Hello!
GREAT! Thank you very much for sharing excellent knowledge.
all the best
Erwin
Hello Erwin,
Thanks alot for your encouraging comments.
Regards,
Lakshmi S
Hi..
Good doc..thanks for sharing...
Hello Teran,
Thanks alot and requesing you to please provide your feedback along with the rating 🙂
Regards,
Lakshmi S
Hi Lakshmi
Nice documents..thanks for sharing
Regards
sampat
Hello Sampat,
Thanks alot and please review the same by providing your valuable feedback alog with rating 😆 . Suggessions are always welcome
Regards,
Lakshmi S
Ok...
Done
Thanks Sampat 🙂
Thanks for sharing your knowledge.
Hi Raman,
Thanks alot and requesting you to pls review the doc and provide your valuable suggestions along with suitable rating 🙂
Regards,
Lakshmi S
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
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
Hi,
Yours is very detailed presentation, how can you claim yourself as a BEGINNER???
🙂
Regards,
Srinu
Hello Srinivasa,
Thanks alot for your time to reading this doc and your words are really appreciating me.
Regards,
Lakshmi S
Thanks .
its very helpful .
Regards | Maruthi
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
Hi Lakshmi,
Good doc. Good Job.... 🙂
Hello Balaji,
Thanks alot and pls review the document to provide your valuable suggestions along with your rating.
Thanks & Regards,
Lakshmi S
Hi Lakshmi,
It is very good document and useful.
Thanks for sharing the valuable document .. 🙂
Hello Venkateshwarlu,
Thanks alot and pls review the doc to provide your valuable feedback.
Regards,
Lakshmi S
Hello Lakshmi,
Thanks for sharing quite useful information. It would be good, if you add Workflow tcodes used by FICO Consultants.
Thanks
Hi Lakshmi,
Very useful documents (Part 1 & 2).
Keep up the good work.
Regards
KIM Khan
Hello KIM,
Thanks alot 🙂
Regards,
Lakshmi S
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?
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
Hi Lakshmi,
Very useful Doc.
Thanks for Sharing.
Regards,
Ramesh
Hi Ramesh,
Thanks for your comments.
Regards,
Lakshmi S
Hi Lakshmi,
Excellent document !!! keep up good work 🙂
Regards,
Lokesh Earla
Hello Lokesh,
Thank you so much!
Regards,
Lakshmi S