Application Development Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

Finding reference documents for the lost document in SM13

Former Member

‎10-21-2011 6:40 AM

0 Kudos

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

1 REPLY 1

gokul_radhakrishnan3
Active Participant

‎11-23-2011 6:31 AM

0 Kudos

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