DownloadingSAP table into Multiple Files

[Former Member]

Hi experts,

I have sap table (LFA1)having say 10lak records ,

How to process and download those 1olak records into multiple files (10 TO 20 ) in local pc.

thanks

NAG

[Former Member]

Hi experts,

I have sap table (LFA1)having say 10lak records ,

How to process and download those 1olak records into multiple files (10 TO 20 ) in local pc.

thanks

NAG

[Former Member]

once u get ur data into an internal table just split it based on the count and write it using gui_download

[Former Member]

Hi,

Select all the entries from the LFA1 table into an internal table.

loop at this internal table and split into files based on the no of records you went to download in each file.

Sruthi

[Former Member]

Hi NagRaju

Write a test program where you are selecting all the contents of the database table into an itab.

Then you have two options:

1) Then passing this itab to the FM: GUI_DOWNLOAD. This will copy all your data in one single file.

2) If the version you are in is ECC 5.0 or above, then go into debugging mode and select this itab where you can see all its contents. Then on the extreme right side, there is a button "Services of the Tool", in that SERVICES >> Save to Local File which gives you an option to save data line wise i.e from 1 to 100 (or anything) you can save in one file, the rest in another files as many you want.

Hope this helps.

Harsh

[Former Member]

If you are not sure about the number of records that are read-

use DESCRIBE TABLE on the internal table to get the number of records and then divide it by the number of files you want to save the records in.

So you get count which is nothing but the number of records to be written in each file. Use this in your loop-endloop.

Sumit