Batch Jobs to Transfer excel to SAP

[Former Member]

Dear All,

The following is my requirement categorised into simple points:

1) After successful authentication, the user should be able to upload the excel sheet into temporary location.

2) Triggering the Batch Job in the temporary location at the end of day which should load the data into SAP.

3) After the data is loaded into SAP, it will be displayed for approval in portal.

I think point 3 is acheivable seems to be straight forward. I am concerned about the points 1 & 2.

Please let me know the way to achieve the same.

Thanks

Mano

[anja_engelhardt2]

moved to SAP NetWeaver Application Server by moderator

[Former Member]

Hi Mano,

            You can create a folder at Application server level(OS level) and configured the same in Tcode AL11 in SAP.

            Please specify what is meant by Successful authentication ,is it SAP level or non SAP level.

            ABAP developer can design the program which you can schedule to pick the file from Application server level.

Thanks and Regards,

Kunal Gahlot                 

[Former Member]

Hi,

1) After successful authentication, the user should be able to upload the excel sheet into temporary location.

use transaction CG3Z or function module ARCHIVFILE_CLIENT_TO_SERVER. 

2) Triggering the Batch Job in the temporary location at the end of day which should load the data into SAP.

Create another program to check the content of the file and upload the data in sap tables. The schedule the job to pick the file from the file system and upload in the sap system.

3) After the data is loaded into SAP, it will be displayed for approval in portal.

you are already aware of the third point.

Thanks

Rishi Abrol

[junwu]

what's version of your nw?

if nw>=7.1

SAP NetWeaver Scheduler for Java

http://help.sap.com/saphelp_nwce10/helpdata/en/44/03d66015ee10b3e10000000a11466f/content.htm

else

KM Scheduler task

http://help.sap.com/saphelp_nw04s/helpdata/en/3a/bc37b5789dee4eaa8005bff84f14cf/content.htm

http://www.sdn.sap.com/irj/scn/go/portal/prtroot/docs/library/uuid/c0748129-0d96-2c10-9392-8d03ce43e...

you can upload the excel to km folder or ECM

[Former Member]

i) Upload the file to your application server. Make a specific directory in your app. server which will be your temporary location.

ii) trigger batch job to upload data from app. server to SAP.