How we download master data in excel file

[Former Member]

Hi guru,

I have more than 5000 records of data in master table in Sales and FI .So how i will download all the data in excel file.

Give me step by step answer, or there is any tool for download all the data in excel file.

Thanks.

[Former Member]

Hi,

You can use "SE16N" transaction from where you can download the data to excel .Give the table name and execute then the data in the table will be displayed and then press export tab where you find the option Spreadsheet .

Thank U,

Jay....

[Former Member]

Hi:

use fm GUI_DOWNLOAD

have a look

[Link|;

Regards

Shashi

[Former Member]

Hi,

You can use "SE16N" transaction from where you can download the data to excel .Give the table name and execute then the data in the table will be displayed and then press export tab where you find the option Spreadsheet .

Thank U,

Jay....

[Former Member]

Hi,

You can also run the BDC to download the data in the spread sheet.

1.prepare the internal table with same structure as the table.

2. select the desired data from the table into the internal table.

3.then use the FM GUI_DOWNLOAD/'TEXT_CONVERT_XLS_TO_SAP' and pass the name of the internal table and the excel sheet name as the parameter.

4.save ,activate and execute the code.

Hope this helps you.

Pooja