Skip to Content
author's profile photo Former Member
Former Member

Finding reference documents for the lost document in SM13

Hi All,

We have a report YFIR_RFVBER00 for lost documents.

This report is run to find out the list of lost document numbers.

However since SM13 logs are deleted every 60 days so we run this report every month to store the data into database tables.

This report will generate only the list of lost documents for which log available in SM13.

But is only showing the lost document and no related documents.

This makes it impossible to check if the document is invoiced with another document.

So it should also display lost invoice number, delivery, sales order and new invoice number

Selection criteria: company code and period (document date)

We are unable to find the reference between lost document and its respective

deliver or sales order or invoice.

To find the lost document in BFPF. But we are not able to find any joins with the

lost document present in the table BKPF.

Please let me know if anyone of you have an idea about it

Thanks in advance for your help.

Rgards,

Sneha

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

1 Answer

  • Posted on Nov 23, 2011 at 06:31 AM

    Please check whether you can use any of the update tables. VBHDR & VBDATA. You will not find the data directly from there & you will find only the update data key VBPARAM-key (if i remember correctly) & you may have to read cluster/files by using IMPORT statements. Look for examples by using where used for these tables.

    Regards,

    Gokul

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.