Skip to Content
0
Former Member
May 30, 2008 at 03:42 AM

SAP_CONVERT_TO_XLS_FORMAT Dump

1711 Views

hi

when i use header Fm going to dump.If i comment I_LINE_HEADER its working fine. pls help me

DATA : BEGIN OF t_header OCCURS 0,
       name(40) TYPE c,
       END OF t_header.

CLEAR t_header.
t_header-name = 'Client'.
APPEND t_header.

t_header-name = 'Plant Code'.
APPEND t_header.
t_header-name = 'Product Code'.
APPEND t_header.
t_header-name = 'Product Description'.
APPEND t_header.
t_header-name = 'Base UM'.
APPEND t_header.
t_header-name = 'Inner Pack'.
APPEND t_header.
t_header-name = 'Outer Pack'.
APPEND t_header.
t_header-name = 'Ship Pack'.
APPEND t_header.
t_header-name = 'Lst Upd Dt'.
APPEND t_header.
t_header-name = 'Lst Upd By'.
APPEND t_header.
t_header-name = 'Ext date'.
APPEND t_header.
t_header-name = 'Ext Time'.
APPEND t_header.
t_header-name = 'Ext By'.
APPEND t_header.
t_header-name = 'File Name'.
APPEND t_header.

loop at it_material.
CONCATENATE  '''' it_material-matnr into it_material-matnr.
modify it_material.
*clear it_material.
endloop.

CALL FUNCTION 'SAP_CONVERT_TO_XLS_FORMAT'
  EXPORTING
   I_FIELD_SEPERATOR          = 'X'
*   I_LINE_HEADER              = t_header
    i_filename                 = p_pcfile
*   I_APPL_KEEP                = ' '
  tables
    i_tab_sap_data             = it_material
* CHANGING
*   I_TAB_CONVERTED_DATA       =
 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.