topic Re: csv format in Application Development and Automation Discussions

csv format

Former Member — Wed, 04 Jul 2007 10:14:05 GMT

how to download data into csv format?here i down-loaded the file, in that sheet its giving boxes ?

Re: csv format

Former Member — Wed, 04 Jul 2007 10:15:58 GMT

type-pools:TRUXS.
data: begin of itab occurs 0,
      vbeln like vbap-vbeln,
      posnr like vbap-posnr,
      end of itab.
data:  itab1 type TRUXS_T_TEXT_DATA.
  select vbeln
         posnr
         up to 10 rows
         from vbap
         into table itab.
 
CALL FUNCTION 'SAP_CONVERT_TO_CSV_FORMAT'
 EXPORTING
   I_FIELD_SEPERATOR          = ','
  TABLES
    I_TAB_SAP_DATA             = itab
 CHANGING
   I_TAB_CONVERTED_DATA       =  itab1
 EXCEPTIONS
   CONVERSION_FAILED          = 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.
 
   CALL FUNCTION 'GUI_DOWNLOAD'
    EXPORTING
      filename = 'C:TEMPtest.TXT'
    TABLES
      data_tab = itab1
    EXCEPTIONS
      OTHERS   = 1.

Re: csv format

amit_khare — Wed, 04 Jul 2007 10:18:57 GMT

Refer the links -

Regards,

Amit

Reward all helpful replies.

Re: csv format

Former Member — Wed, 04 Jul 2007 10:22:23 GMT

HI,

If your file is in application server then you can use OPEN DATASET

TYPES : BEGIN OF ty_data,

data TYPE char2000,

END OF ty_data.

data wa_data TYPE ty_data,

data it_data TYPE STANDARD TABLE OF ty_data,

*Open the file and transfer the data into the internal table

OPEN DATASET 'xxx
xxa.com\dd\factory\asbcd.csv'

FOR INPUT IN TEXT MODE ENCODING DEFAULT.

IF sy-subrc = 0.

DO.

READ DATASET

'same file path as above'

INTO wa_data .

IF sy-subrc = 0.

APPEND wa_data TO it_data.

CLEAR wa_data.

ELSE.

EXIT.

ENDIF.

ENDDO.

endif.

rewards if useful

regards,

nazeer