Create an Excel File in background

[Former Member]

Ladies and Gentlemen,

I have a requirement to create an Excel file in a program that will only be executed in background mode. This automatically rules out GUI_DOWNLOAD or any download funtion that presents the file on the presentation server.

I think that the 'Open Dataset...' command will work to create the file on the Application server, but this seems a bit archaic to me. Is there another way of creating the excel file on the application server in background? I am working on a 4.7 system at the moment, but this is scheduled for a upgrade to ECC6 sometime in the next 12 months, so I'm after a process that will be valid both before and after the upgrade.

Cheers,

Steve

[Former Member]

Hi,

Not sure you can give a try using FTP_COMMAND.

But I don't think it works for excel sheet.

Open Dataset ("OLD IS GOLD")

Thanks,

chaithanya K

[former_member189059]

Hello Stephen,

I think the best option is to manually format the output into the CSV format

ie: add commas between your output fields

then using open dataset, you can write a CSV file to the application server which will open in excel automatically

[Former Member]

Hi Stephen,

Use Open dataset, Transfer, Close dataset to create file on Application server.

Use FM Z_CONV_ITAB_TO_TAB_DELIMITED to convert your lines in TAB delimited format. you can download file from your application server to presentation server using T Code CG3Y and give extension as .xls ...

As you data is Tab delimited it will automatically get formatted in columns in your EXCEL file.

Regards,

Mohaiyuddin

[Former Member]

Hi,

Check the following link:

http://sap-img.com/abap/download-in-background-in-excel-format.htm

Regards,

Bhaskar

[Former Member]

Hi Stephen,

Give me your email address, I will send you a document with the logic and a detailed explanation...

-Muktar