Ok I would like to have more information
I would like to upload the invoices raised in 2007 in these 2 tables...
Next year 2009, will invoices raised in 2008 be transfered to those 2 tables so the report will use teh same table from uplaod in 2007 and 2008
I would like to create a report to compare 2009 vs 2008, 2008 vs 2007 and so on using the actual invoices vs to history invoices. The report will use the same fields in 2009 if I can upload in ADO and ADO1 invoices from 2007...
Unfortunately, ADOC and ADO1 are not exposed through DI which it means that DTW addon can't update or insert data into both tables.
The tables are updated when you create invoice A/R, so the tables are OINV and INV1 and the ADOC and ADO1 record the invoice. The main function is to back up and store the data. Once there is a problem in OINV and INV1, SAP support will use ADOC and ADO1as base document/table to insert or update your invoice.
I am not sure what ODBC you will use, I guess DTS in SQL server.
I do not know the table use. It is only invoice history table.
If we deal with history, it means that SAP created it, maybe one of them is as a tool to know whether you / end user / partner have update or insert data using SQL script directly into OINV / INV1, once in the future there is a problem with your OINV/INV1, they will check it in the ADOC/ADO1 then OINV/INV1. they compare the result and if it is different, they will check if there is any other causes e.g. user intervention or bugs.
So, the history of invoice you want to upload is using DTW template invoice (oInvoices) --> choose service type document and set the price or Total (LC) is zero. the template will insert zero invoice but recorded in OINV/INV1 and also ADOC/ADo1. good luck