I need to fill up the set up tables for 2LIS_06_INV - Invoice Verification datasource. When I run the program in background from time to time I get the following message "the recompilation has successfully processed 1 blocksu201D. This message may appear to be Ok. However when I tested the extractor RSA3, I only get a handful of records say 198. The Table RBKP has 38, 000+ records. These records should have being extracted. Then, I delete the set up and I start the process again and again with no real positive results. The source system is SAP ECC 6.0.
In another note, the transaction OLI6BW u2013 Invoice verification execution is different from the other 2LISs datasources. This screen does not have u201Cnew run?u201D option. I am not sure if there is a step I may have to do for this datasource for successfully filling the set up tables. I checked the content of table MC06M_0ITMSETUP. To my shock, I only got 12 entries in the table.
The questions here are as follows:
Why is this datasource not extracting the right amount of records?
Is there any step that I accidentally missed?
Should the above mentioned table display the right number of records extracted?
Any idea is welcome.
First delete the setup tables in LBWG transaction for applicaton 06.
Now delete the extraction queue.
Now fill the set up tables.
I think giving the selection for fiscal period is mandatory while filling the set up tables.
Try to give the selection from 2006 to 2009 and then see how many records you get.
Let me know if this works. I used this option.
I have deleted the set up tables and delta queue several times. In OLE6BW, I set up the following:
Document No "*"
Fiscal year "2005"
Company code "value"
I get the following short dump " DBIF_RSQL_SQL_ERROR". The selection is to complex. I quite do not follow this as I am only filling in the fields SAP is providing.
Is this datasource working properly in your system?
I try to use the 2LIS_06_INV datasource since few days, and after reading all of the thread, i have a question :
I use the LBWG transaction to delete the setup table, but how can i delete the extraction queue ?
Somebody knows if it exists a document where it explains exactly how to use this datasource (or a 2LIS* datasource)
thanks a lot,
Thank you for your advice.
Over the years I have developed some skills with the LISs datasources. This is the first time, I have seen this issue.
The technical people found an issue with the database DB2. They are correcting the settings.
I'll let you know the outcome shortly.