topic Re: Scheduling a BDC in Application Development and Automation Discussions

Scheduling a BDC

rajeshkumar_kaveti — Sat, 11 Mar 2006 19:35:01 GMT

Hi Friends,

My requirement is to upload data in Excel every 1 hour. For this i developed a BDC and i scheduled it in SM36. I am also maintaining a table to record log info. Excel Sheet file name will be combination of date and hour. My Program will pick the file from path '
sap9\c\'. Here Sap9 is the network identification. Every 1 hour the file will be placed in this path. If i run it manually it is picking the file and uploading the data. But in Scheduling it is giving me FILE NOT FOUND error. This i come to know by checking my log table.

I hope the scenario is clear.

Please help me.

Thanks in advance

Re: Scheduling a BDC

suresh_datti — Sat, 11 Mar 2006 19:42:16 GMT

Hi Rajesh,

Are you sure you are using OPEN DATASET in your BDC that reads the file? I do hope that, if you use GUI_UPLOAD it will not work in the background.

Regards,

Suresh Datti

Re: Scheduling a BDC

Former Member — Sat, 11 Mar 2006 22:03:03 GMT

While scheduling background job, you need to make sure that data is uploaded from a application server and not presentation server.

SAP does not support loading file from presentation server in background job. So make sure that you have a folder on your application server which will contain files.

You can use FTP to keep files in this application server and then use syntax OPEN DATASET, READ DATASET, CLOSE DATASET to upload data.

Message was edited by: Ashish Gundawar

Re: Scheduling a BDC

rajeshkumar_kaveti — Mon, 13 Mar 2006 07:22:34 GMT

Thanks Ashish. Can u please elaborate me how to use FTP to keep file in Application server. And one more thing is i have to keep a new file every hour. How can i automate this.

Re: Scheduling a BDC

Former Member — Sat, 23 Sep 2006 06:20:39 GMT

dear ashish,

how to schedule a bdc in background, please give details me to me. Yr valueable solution very help full for me.

Thanks & regards

Rathnam

senapathy_easan@yahoo.com

prathnam@essar.com

Re: Scheduling a BDC

Former Member — Sat, 23 Sep 2006 21:13:52 GMT

Hi,

Go through the links,

http://help.sap.com/saphelp_47x200/helpdata/en/69/c250414ba111d189750000e8322d00/frameset.htm

Regards,

Azaz Ali.