09-21-2008 7:12 AM
Hello,
I have got a peculiar requirment. My client will be getting the records into EXCEL sheet through automatic data transfers machines. We wrote BDC for updateing those EXCEL records into SAP we gave a Txcode for our BDC program and when he executes the latest EXCEL records will be updateing when enduser gives the path of the EXCEL sheet.
Now the client is asking for automatic updation of records i.e after he gets the records into his EXCEL sheet with out his step of uploading he wants that EXCEL records to be update into SAP.
Can this requirment be fullfilled if yes help me to achieve this.
09-22-2008 5:53 PM
If you know the tentative time of the EXCEL sheet being created you can have a couple of periodic jobs that will be executed during this time. Once a particular job uploads the data the program needs to rename the EXCEL (if you dont want to change the existing program you can have one more program attached to the job) sheet or can delete so that the other program will not use this file again.
Thanks,
Mahesh
09-23-2008 4:15 PM