Finding reference documents for the lost document in SM13

Former Member — Fri, 21 Oct 2011 05:40:53 GMT

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

Re: Finding reference documents for the lost document in SM13

gokul_radhakrishnan3 — Wed, 23 Nov 2011 06:31:29 GMT

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

topic Re: Finding reference documents for the lost document in SM13 in Application Development and Automation Discussions

Finding reference documents for the lost document in SM13

Re: Finding reference documents for the lost document in SM13