the logic of the interface is as follows:
The Interface from SAP ECC to CLIENT has to be built to transmit following information-
- Vendor Invoice along with goods receipt and Purchase Order information
- Vendor credit memo resulting from goods return, retro pricing and invoice cancellation.
open invoices are then sent to CLIENT via middleware. The output from this custom program would be the Idocs sent to the middleware (SAP PI) which would do the formatting on this date to send the text file to CLIENT.
This custom program would be then scheduled as a batch job executed on daily basis (Monday-Friday).
Once the Idocs are sent to the port, the sent invoices would be cleared in SAP using standard SAP transaction F-44 thru BDC.
Internal table has entries then that documents to be collected into a custom table to make sure that they will be cleared in the next run and they will not go to CLIENT in next run
When the next job runs the program, has to select the all entries from the custom table and try to clear all these along with its documents and delete them from the internal table before the IDocs are created
However what happened is that one 01 May - IDOC was created for 200 records and these 200 records were successfully sent to CLIENT ....twist came on 02 May 2012 when 100 records from 01 May 2012 again went along with the records that should go on 02 May 2012. so these 100 records were duplicate (sent on 01 and 02 May 2012)
Cannot understand how can this happen - if there was something wrong in the interface then all the records that were sent on 01 May should have been repeated but thats not the case
--regards
Imran
Bluesky
