Gui Download DBF format

[Former Member]

Dear All,

I am using the GUI_Download to download the data from an internal table to the Excel Sheet. I am also filling the fieldnames tab as required. The Problem i am facing is when i export the data to excel the fieldnames of the columns are truncated to 10 characters in length. However, the data is intact. Can anybody help me here.

Thanks in advance

Ashok

[Former Member]

Dear All,

I am using the GUI_Download to download the data from an internal table to the Excel Sheet. I am also filling the fieldnames tab as required. The Problem i am facing is when i export the data to excel the fieldnames of the columns are truncated to 10 characters in length. However, the data is intact. Can anybody help me here.

Thanks in advance

Ashok

[Former Member]

Hi Ashok,

I raised a question about this on SDN earlier this year. I also checked the issue with SAP, who replied as follows:

"I am sorry, but the code in OSS Note 762579 is correct: We have had some serious problems with fieldnames longer then 10 chars when trying to import the dbf file into Excel. So we found that fieldnames <= 10 Chars did not lead to such problems and decided to go sure and to truncate fieldnames longer then 10 chars.

I am sorry for that but in order to keep a minimum compatibility with Excel (which is used by customers for importing dbf files) we have been forced to do so."

So I am trying to use the append feature of GUI_DOWNLOAD as recommended in other threads on this site.

Hope that helps.

Peter

[Former Member]

Hi Peter,

Thanks for providing your valuable inputs.

Thanks

Ashok

[Former Member]

Hi,

Check if its any useful to download your excel file as required.

call function 'MS_EXCEL_OLE_STANDARD_DAT'

exporting

file_name = filename "Specify the path here

tables

• PIVOT_FIELD_TAB =

data_tab = gt_itabe " internal table

• FIELDNAMES = it_fieldnames

exceptions

file_not_exist = 1

filename_expected = 2

communication_error = 3

ole_object_method_error = 4

ole_object_property_error = 5

invalid_pivot_fields = 6

download_problem = 7

others = 8.

thanks,

Adithya