Excel file upload through BAPI in BACKGROUND

[Former Member]

Hi every one,

I have a requirement, to upload data from excel sheet to sap every month end, means some G/L posting from external system to sap, I need to interface this system with sap,

Here, in my external system, I have possibility to get month end data in Excel format; I need simply upload this into sap.

I have developed BAPI program for this, and its working fine. But now my problem is, my people want to execute this program in background, they ask me to do background schedule.

Here I know how to do background schedule, but my question is how system will respond in background in case of u2018ALSM_EXCEL_TO_INTERNAL_TABLEu2019 function module.

Please give the suggestions regarding to the excel upload in background schedule.

Regards,

Sreenu.

[Former Member]

Hi,

I d'nt think that will be a pbm.

while exectuing the report choose for background through menu options.

Naveen M.

[Former Member]

Hi,

Just try scheduling in background and test, I do nt think it will work in background processing as in background processing access to presentation server resumes. So you need to take help of presentation server in al11. Use open dataset, close dataset method.

Br/Manas

[Former Member]

Hi,

We run the program in background using sm36 you can define which abap program is to be run in background.During the function module 'ALSM_EXCEL_TO_INTERNAL_TABLEu2019 catch the exceptions and interpret as bapi error .

As your requirement is only upload data and not sending back messages to external system this should suffice.But if you want to send some message to external system u can send email attachement to alias stating the job failure or success.

Thanks

Anitha

[Former Member]

Hi every one,

Thanks for your replies,

I have done, like this,

I scheduled the job and given variant, in sm36 and sm37 I got error like u2018Canceledu2019. Please tell me how to do this.

Regards,

Sreenu.