06-19-2007 7:40 PM
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)?
06-19-2007 8:01 PM
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
06-19-2007 7:43 PM
Yes its possible. Check the documentation for GUI_DOWLOAD .
Check this out..
award points if useful
08-01-2007 8:25 AM
ya u can move filed name to a variable and use pattern gui_download
06-19-2007 8:01 PM
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
06-20-2007 5:57 AM
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