GUI upload

[Former Member]

Hi All,

I have a requirement that i need to upload 4.2 milllion records from presentation server file (.txt) to an internal table in a program and update it to a custom table . I could use GUI_UPLOAD function module but it will take lot many SAP memory and and will make the system slow. Do we have any option other than splitting the flat file into multiple number of flat files and and process it.

<<removed by moderator>>

Thanks,

Sagar Bhattacharjee

Edited by: kishan P on Sep 3, 2010 9:33 AM

[Former Member]

Hi Sagar,

If you have to upload the data on application server then why dont you try using FTP function modules.

Use these function modules FTP_CONNECT, FTP_COMMAND, and FTP_DISCONNECT to get/put files between FTP and application server.

Try searching for code in SCN code gallery for the same.

Regards

Abhii

[Former Member]

Ok.

There is a possibility of placing this text file in to application server. Basis people can do that .

Now what you need to do is pick the data from applciation server using datasets and update the table from program point of view.

As i said you need this file placed in to the application server path AL11.

your program will pick the data from this path and process the things . Since the data is present in application server you can run the program in background under a job .

I had a similar scenario where in the volume of records was about 10 million. This was the approach we used it then .

Good luck . BTW welcome to SCN and please use some good description for the subject line .

BR,

Vijay.