Skip to Content
0
Former Member
Oct 21, 2011 at 05:40 AM

Finding reference documents for the lost document in SM13

204 Views

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