topic Re: write internal table to a file on application server using OPEN DATASET in Application Development and Automation Discussions

write internal table to a file on application server using OPEN DATASET

Former Member — Wed, 23 Jan 2008 06:51:09 GMT

I have logical file path and XLS file name. I want to write internal table to a XLS or CSV file on application sever. Please give example.

Re: write internal table to a file on application server using OPEN DATASET

Former Member — Wed, 23 Jan 2008 06:57:03 GMT

Hi,

TYPES: BEGIN OF l_ty_listfile,

seq(8) TYPE c,

comma1(1) TYPE c,

record_no(8) TYPE c,

comma2(1) TYPE c,

tns_sec(1) TYPE c,

comma3(1) TYPE c,

deli_date(8) TYPE c,

END OF l_ty_listfile.

DATA: l_t_listfile TYPE l_ty_listfile with header line.

(Seperate all the fields with comma seperated and populate to appliation server file.)

OPEN DATASET i_f_fullpath FOR OUTPUT.

TRANSFER l_t_listfile TO i_f_fullpath.

CLOSE DATASET i_f_fullpath.

Re: write internal table to a file on application server using OPEN DATASET

Former Member — Wed, 23 Jan 2008 07:00:15 GMT

see this program

EXCEL SHET to INTERNAL table and then to APPLICATION server

&----

*& Report ZSD_EXCEL_INT_APP

&----

REPORT ZSD_EXCEL_INT_APP.

parameter: file_nm type localfile.

types : begin of it_tab1,

f1(20),

f2(40),

f3(20),

end of it_tab1.

data : it_tab type table of ALSMEX_TABLINE with header line,

file type rlgrap-filename.

data : it_tab2 type it_tab1 occurs 1,

wa_tab2 type it_tab1,

w_message(100) TYPE c.

at selection-screen on value-request for file_nm.

CALL FUNCTION 'KD_GET_FILENAME_ON_F4'

EXPORTING

PROGRAM_NAME = SYST-REPID
DYNPRO_NUMBER = SYST-DYNNR
FIELD_NAME = ' '

STATIC = 'X'

MASK = ' '

CHANGING

file_name = file_nm

EXCEPTIONS

MASK_TOO_LONG = 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.

start-of-selection.

refresh it_tab2[].clear wa_tab2.

file = file_nm.

CALL FUNCTION 'ALSM_EXCEL_TO_INTERNAL_TABLE'

EXPORTING

filename = file

i_begin_col = '1'

i_begin_row = '1'

i_end_col = '10'

i_end_row = '35'

tables

intern = it_tab

EXCEPTIONS

INCONSISTENT_PARAMETERS = 1

UPLOAD_OLE = 2

OTHERS = 3

IF sy-subrc <> 0.

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

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

ENDIF.

loop at it_tab.

case it_tab-col.

when '002'.

wa_tab2-f1 = it_tab-value.

when '004'.

wa_tab2-f2 = it_tab-value.

when '008'.

wa_tab2-f3 = it_tab-value.

endcase.

at end of row.

append wa_tab2 to it_tab2.

clear wa_tab2.

endat.

endloop.

data : p_file TYPE rlgrap-filename value 'TEST3.txt'.

OPEN DATASET p_file FOR OUTPUT IN TEXT MODE ENCODING DEFAULT.

*--- Display error messages if any.

IF sy-subrc NE 0.

MESSAGE e001(zsd_mes).

EXIT.

ELSE.

*---Data is downloaded to the application server file path

LOOP AT it_tab2 INTO wa_tab2.

TRANSFER wa_tab2 TO p_file.

ENDLOOP.

ENDIF.

*--Close the Application server file (Mandatory).

CLOSE DATASET p_file.

loop at it_tab2 into wa_tab2.

write : / wa_tab2-f1,wa_tab2-f2,wa_tab2-f3.

endloop.

Re: write internal table to a file on application server using OPEN DATASET

Former Member — Wed, 23 Jan 2008 07:02:20 GMT

Hi,

DATA: data_file TYPE string.

CONCATENATE c_path

filename

'.csv' INTO data_file.

OPEN DATASET data_file FOR OUTPUT IN TEXT MODE ENCODING DEFAULT.

if sy-subrc eq 0.

LOOP AT i_outtext INTO ws_outtext.

TRANSFER ws_outtext TO data_file.

CLEAR ws_outtext.

ENDLOOP.

CLOSE DATASET data_file.

endif.

Hope this helps.

Thanks,

Subramanian

Re: write internal table to a file on application server using OPEN DATASET

Former Member — Wed, 23 Jan 2008 07:05:55 GMT

Pls go thru this code. hope it will help your problem.

Reward if help.

Refer this:

http://help.sap.com/saphelp_nw04/helpdata/en/fc/eb3ca6358411d1829f0000e829fbfe/frameset.htm

ABAP code for uploading a TAB delimited file into an internal table. See code below for structures.

&----

*& Report ZUPLOADTAB * &----

*& Example of Uploading tab delimited file *

&----

REPORT zuploadtab .

PARAMETERS: p_infile LIKE rlgrap-filename

OBLIGATORY DEFAULT '/usr/sap/'..

DATA: ld_file LIKE rlgrap-filename.

*Internal tabe to store upload data

TYPES: BEGIN OF t_record,

name1 like pa0002-VORNA,

name2 like pa0002-name2,

age type i,

END OF t_record.

DATA: it_record TYPE STANDARD TABLE OF t_record INITIAL SIZE 0,

wa_record TYPE t_record.

*Text version of data table

TYPES: begin of t_uploadtxt,

name1(10) type c,

name2(15) type c,

age(5) type c,

end of t_uploadtxt.

DATA: wa_uploadtxt TYPE t_uploadtxt.

*String value to data in initially.

DATA: wa_string(255) type c.

constants: con_tab TYPE x VALUE '09'.

*If you have Unicode check active in program attributes then you will

*need to declare constants as follows:

*class cl_abap_char_utilities definition load.

*constants:

con_tab type c value cl_abap_char_utilities=>HORIZONTAL_TAB.

************************************************************************

*START-OF-SELECTION

START-OF-SELECTION.

ld_file = p_infile.

OPEN DATASET ld_file FOR INPUT IN TEXT MODE ENCODING DEFAULT.

IF sy-subrc NE 0.

ELSE.

DO.

CLEAR: wa_string, wa_uploadtxt.

READ DATASET ld_file INTO wa_string.

IF sy-subrc NE 0.

EXIT.

ELSE.

SPLIT wa_string AT con_tab INTO wa_uploadtxt-name1

wa_uploadtxt-name2

wa_uploadtxt-age.

MOVE-CORRESPONDING wa_uploadtxt TO wa_upload.

APPEND wa_upload TO it_record.

ENDIF.

ENDDO.

CLOSE DATASET ld_file.

ENDIF.

************************************************************************

*END-OF-SELECTION

END-OF-SELECTION.

*!! Text data is now contained within the internal table IT_RECORD

Display report data for illustration purposes

loop at it_record into wa_record.

write:/ sy-vline,

(10) wa_record-name1, sy-vline,

(10) wa_record-name2, sy-vline,

(10) wa_record-age, sy-vline.

endloop.

Re: write internal table to a file on application server using OPEN DATASET

Former Member — Wed, 21 Oct 2009 08:26:49 GMT

thanks

Re: write internal table to a file on application server using OPEN DATASET

Former Member — Wed, 21 Oct 2009 08:28:12 GMT

It would be better if you close the threads without your invaluable feedback instead of spaming the forums