topic Re: Generating flat file in Application Development and Automation Discussions

Generating flat file

Former Member — Tue, 19 Jun 2007 18:40:58 GMT

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)?

Re: Generating flat file

Former Member — Tue, 19 Jun 2007 18:43:45 GMT

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-d7ce4c0c4c1c

award points if useful

Re: Generating flat file

Former Member — Tue, 19 Jun 2007 19:01:34 GMT

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

Re: Generating flat file

Former Member — Wed, 20 Jun 2007 04:57:17 GMT

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

Re: Generating flat file

kamesh_g — Wed, 01 Aug 2007 07:25:27 GMT

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