Generating flat file

[Former Member]

Hi,

I'm learning ABAP and I am struck up a question, When generating a flat file, is there any method to get the information in our won specified format? e.g.: while generating a flat file with any standard table field values, can we get the field names also (in the header)?

[Former Member]

Yes its possible. Check the documentation for GUI_DOWLOAD .

Check this out..

https://www.sdn.sap.com/irj/sdn/go/portal/prtroot/docs/library/uuid/e0901cba-f49e-2910-748c-d7ce4c0c...

award points if useful

[kamesh_g]

ya u can move filed name to a variable and use pattern gui_download

[Former Member]

Refer to the code below.

DATA: BEGIN OF itab occurs 0,

vbeln TYPE vbak-vbeln,

erdat TYPE vbak-erdat,

kunnr TYPE vbak-kunnr,

END OF itab.

DATA : BEGIN OF fields OCCURS 0,

name(10),

END OF fields.

SELECT vbeln erdat kunnr INTO TABLE itab FROM vbak UP TO 10 ROWS.

MOVE 'Sales Doc|' TO fields-name.

APPEND fields.

MOVE 'Date |' TO fields-name.

APPEND fields.

MOVE 'Cust No. |' TO fields-name.

APPEND fields.

CALL FUNCTION 'GUI_DOWNLOAD'

EXPORTING

filename = 'C:\1.txt'

filetype = 'ASC'

write_field_separator = 'X'

TABLES

data_tab = itab[]

fieldnames = fields[].

Regards,

Sail

[Former Member]

Hi,

You can use GUI_DOWNLOAD you have to give the network path name followed by filename in the export parameter for filename.

Data : l_file LIKE rlgrap-filename DEFAULT 'c:\temp\inv_to_wms.txt'.

CALL FUNCTION 'GUI_DOWNLOAD'

EXPORTING

• BIN_FILESIZE =

FILENAME = l_FILE

FILETYPE = 'ASC'

• APPEND = ' '

• WRITE_FIELD_SEPARATOR = ' '

• HEADER = '00'

• TRUNC_TRAILING_BLANKS = ' '

• WRITE_LF = 'X'

• COL_SELECT = ' '

• COL_SELECT_MASK = ' '

• DAT_MODE = ' '

• CONFIRM_OVERWRITE = ' '

• NO_AUTH_CHECK = ' '

• CODEPAGE = ' '

• IGNORE_CERR = ABAP_TRUE

• REPLACEMENT = '#'

• WRITE_BOM = ' '

• TRUNC_TRAILING_BLANKS_EOL = 'X'

• IMPORTING

• FILELENGTH =

TABLES

DATA_TAB = it_datei

• FIELDNAMES =

EXCEPTIONS

FILE_WRITE_ERROR = 1

NO_BATCH = 2

GUI_REFUSE_FILETRANSFER = 3

INVALID_TYPE = 4

NO_AUTHORITY = 5

UNKNOWN_ERROR = 6

HEADER_NOT_ALLOWED = 7

SEPARATOR_NOT_ALLOWED = 8

FILESIZE_NOT_ALLOWED = 9

HEADER_TOO_LONG = 10

DP_ERROR_CREATE = 11

DP_ERROR_SEND = 12

DP_ERROR_WRITE = 13

UNKNOWN_DP_ERROR = 14

ACCESS_DENIED = 15

DP_OUT_OF_MEMORY = 16

DISK_FULL = 17

DP_TIMEOUT = 18

FILE_NOT_FOUND = 19

DATAPROVIDER_EXCEPTION = 20

CONTROL_FLUSH_ERROR = 21

OTHERS = 22

rEGARDS