Downloading to csv excell file

[Former Member]

Hi !

I need to download a large internal table ( more then 1,000,000 records)to a csv excel file, with its a header.

My records contains also a large amount of fields ( more then 255 characters per record )

Please tell me how to do this task without a time out error dump ? what function to use and how ?.

Thanks

moshe

[anversha_s]

hi solmon,

simply it is not possible.

reasons.

1. excel sheet will not accept more than 65000 rows.

2. no of columns accepted is 255.

rgds

anver

[Former Member]

Hi,

Excel does not support more than 65000 lines/rows , so better option would be to download to some text file.

Thanks.

[Former Member]

you cant use excel in that case,you have open it in notepad(as its a csv file).

use GU_DOWNLOAD.

give FILE_NAME = 'C:\TEST.CSV'

FILETYPE = 'ASC'.

populate your internal table IT_FINAL With comma between the fields.

Regards

srikanth

Message was edited by: Srikanth Kidambi

[Former Member]

Hi Use this for getting the header data

CALL FUNCTION 'RECP_DD_TABL_FIELDNAMES_GET'

EXPORTING

IC_TABNAME = 'KNA1' "Example as KNA1

TABLES

ET_FIELDLIST = FIELDNAME

• EXCEPTIONS

• NOT_FOUND = 1

• OTHERS = 2

.

IF SY-SUBRC <> 0.

• MESSAGE ID SY-MSGID TYPE SY-MSGTY NUMBER SY-MSGNO

• WITH SY-MSGV1 SY-MSGV2 SY-MSGV3 SY-MSGV4.

ENDIF.

And in GUI_DOWNLOAD use the file with extension .csv or txt....

reward if it helps

Sony